I was faced with interesting problem. Which schema, in my DB, uses the most disk space? Theoretically it's trivial, we have set of helpful functions:
But in some cases it becomes more of a problem. For example – when you have thousands of tables …
Continue reading Which schema is using the most disk space?
On 8th of December, Simon Riggs committed patch:
Add new SCHEMA option to REINDEX and reindexdb.
Reviewed by Michael Paquier and Fabrízio de Royes Mello
Continue reading Waiting for 9.5 – REINDEX SCHEMA
On 10th of July, Tom Lane committed patch:
Implement IMPORT FOREIGN SCHEMA.
This command provides an automated way to create foreign table definitions
that match remote tables, thereby reducing tedium and chances for error.
In this patch, we provide the necessary core-server infrastructure and
implement the feature fully in the postgres_fdw foreign-data wrapper.
Other wrappers will throw a "feature not supported" error until/unless
they are updated.
Ronan Dunklau and Michael Paquier, additional work by me
Continue reading Waiting for 9.5 – Implement IMPORT FOREIGN SCHEMA.
On 8th of February, Tom Lane committed patch:
Core support for "extensions", which are packages of SQL objects.
This patch adds the server infrastructure to support extensions.
There is still one significant loose end, namely how to make it play nice
with pg_upgrade, so I am not yet committing the changes that would make
all the contrib modules depend on this feature.
In passing, fix a disturbingly large amount of breakage in
AlterObjectNamespace() and callers.
Dimitri Fontaine, reviewed by Anssi Kääriäinen,
Itagaki Takahiro, Tom Lane, and numerous others
Continue reading Waiting for 9.1 – EXTENSIONS
Absolutely great post about designing database schema to contain information about marriages and partnerships with emphasis on changes brought to us by modern day – gay marriages, non-trivial sex/gender identities and polygamy.