Greg Sabino Mullane's PostgreSQL tips and how-to articles
by Jon Jensen
January 15, 2007

End Point engineer Greg Sabino Mullane is a prolific writer of PostgreSQL tips, suggestions, and how-to articles in his Planet PostgreSQL blog. Some posts involve emergency procedures to diagnose and fix an ailing database, while others are helpful recipes developers can use. The strengths and weaknesses of various approaches are compared, and there are lots of neat things to learn along the way.

Here's my list of favorites from those Greg has posted since last March, in reverse chronological order:

• Turning a table into a queue
• Reindexing the PostgreSQL system tables
• Viewing nearby rows
• Finding multi-column keys
• In-database email address validation without reinventing the wheel
• Making a copy of a unique row
• Finding the median of a table using PL/Perl
• Finding the value closest to the average using PL/Perl
• Getting random rows from a database table
• Scripting with psql
• The million table challenge

Enjoy!