Archiwizowane July, 2011

On 19th of July, Simon Riggs committed patch: Cascading replication feature for streaming log-based replication. Standby servers can now have WALSender processes, which can work with either WALReceiver or archive_commands to pass data. Fully updated docs, including new conceptual terms of sending server, upstream ...

One month ago, on 20th of June, I posted a plea for help. During this time, I received $225 in donations (minus PayPal provision). All of these came from 6 different people, and, what I find a bit amusing, residents of 6 ...

On 18th of July, Tom Lane committed patch: Add GET STACKED DIAGNOSTICS plpgsql command to retrieve exception info. This is more SQL-spec-compliant, more easily extensible, and better performing than the old method of inventing special variables. Pavel Stehule, reviewed by Shigeru Hanada and David ...

On 18th of July, Robert Haas committed patch: Avoid index rebuild for no-rewrite ALTER TABLE .. ALTER TYPE. Noah Misch. Review and minor cosmetic changes by me.

Zadzwoniła do mnie żona. Oboje mamy komórki w Erze (tzn. T-Mobile). Nie odebrałem, spadła na pocztę głosową. OK. Zadzwoniłem na pocztę głosową, odsłuchałem, skasowałem. W międzyczasie żona wróciła do domu. Chwilę później słyszymy, że jej komórka informuje o SMSie. Czyta, pokazuje mi, a ...

While there are some docs on it, I decided to write about it, in perhaps more accessible language - not as a developer, but as PostgreSQL user. Some parts (quite large parts) were described in one of my earlier posts, but ...

Just updated explain.depesz.com site with new functionality - when showing parsed plan, there is new tab "stats". In there you can see some basic statistics of the query, used types of nodes, and tables that were used by it. There are ...

July 8th, 2011 by depesz | Tags: , , | 17 comments »

Yesterday I talked a bit with David Fetter about improvements in psql. We both would like to get proper stored procedures (with multiple result sets, and transaction control), but since this seems to be too complicated, I thought about what ...

On 6th of July, Robert Haas committed patch: Add \ir command to psql. \ir is short for "include relative"; when used from a script, the supplied pathname will be interpreted relative to the input file, rather than to the current working directory. Gurjeet Singh, reviewed ...

July 6th, 2011 by depesz | Tags: , , , , , , , | 20 comments »

For various reasons, and in various cases, bloat happens. Theoretically autovacuum protects us all, but sometimes it doesn't. Sometimes someone disables it, or mis-configures, or bad planet alignment happens, and we end up in deep bloat. What to do then? Vacuum? ...