Archiwizowane December, 2011

If you have production DB servers, chances are you're running variant of these queries: SELECT sum(pg_relation_size(oid)) from pg_class where relkind = 'i' SELECT sum(pg_relation_size(oid)) from pg_class where relkind = 'r' To get summarized size of tables and/or indexes in your database (for example ...

I got asked on irc to show some examples how to use recursive CTE. Apparently my previous post wasn't good enough :) I think that most of the users will use recursive cte to deal with trees I decided to show ...

On 14h of December, Andrew Dunstan committed patch: Add --exclude-table-data option to pg_dump. Andrew Dunstan, reviewed by Josh Berkus, Robert Haas and Peter Geoghegan. This allows dumping of a table definition but not its data, on a per table basis. Table name patterns are ...

I'm huge fan of stand-up comedy, and one of the guys that I like is Louis CK. Learned today that he made new movie - "Live at the Beacon Theater", and it's available on his site. For $5. Without DRM, ...

( title, in case you don't know, comes from excellent "movie" about databases ) The secret ingredient is of course sharding. Can we do sharding in PostgreSQL? First, let's define what sharding is: