Archiwizowane August, 2010

I'm quite often doing stuff on remote machines, and quite frequently I start some long-running job, when I remember that I didn't ran it via screen - so it will break, if my network connection will die. Is there any sane ...

On 24th of August, Takahiro Itagaki committed patch: Log Message: ----------- Add string functions: concat(), concat_ws(), left(), right(), and reverse(). Pavel Stehule, reviewed by me.

Every now and then somebody asks how to make diff of database schemata. Usual background is like: we have production database, and development database, and we want to see what is different on development to be able to change production in ...

Well, the biggest information is that hot-backups on slave work. And they work fine. Really fine. Some more information (with nice graph!):

August 11th, 2010 by depesz | Tags: , , | 4 comments »

"Zainspirowany" pismem o kuchni amerykańskiej, zrobiłem sobie słodko-ostry chłodnik arbuzowy. Wyszło nieźle, więc dla potomności:

Yesterday (August, 7th), Tom Lane committed: Log Message: ----------- Recognize functional dependency on primary keys. This allows a table's other columns to be referenced without listing them in GROUP BY, so long as the primary key column(s) are listed in GROUP BY. Eventually we ...

On 28th of July, Simon Riggs committed patch which: Log Message: ----------- Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions. Avoid hard-coding lockmode used for many altering DDL commands, allowing easier future changes of lock levels. Implementation of initial analysis ...

Some guy came to #postgresql today. Described his problem, got additional question, and then ... well .. I wouldn't believe if it didn't happen to me.