ALTER TABLE: High-Availability taken care of
Adding columns, dropping columns,... might be necessary. But changing data structures should not be done mindlessly. Use ALTER TABLE wisely.
PostgreSQL & tablespaces - it's not so scary ...
What are tablespaces? How and why should I use them? Get the most out of PostgreSQL tablespaces, us CREATE, GRANT CREATE ON and ALTER
Inheritance - One more reason to love PostgreSQL
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
Naming temporary tables properly in PostgreSQL
What if a temporary table in PostgreSQL has the same name as a “real” table? What happens? Find out about naming temporary tables properly.
effective_cache_size: Better set it right
effective_cache_size can have a serious impact on execution plans and change things dramatically. See what kind of difference it can make.
CREATE TABLE – the fancy way with LIKE
The LIKE keyword: Using LIKE is especially useful if you want to clone tables which have dozens of indexes and constraints.
