PostgreSQL 9.0 High Performance

Chapter 16. Avoiding Common Problems

Beyond the expected day-to-day setup and design issues, there are some recurring issues PostgreSQL administrators and developers run into regularly that don't have really obvious answers. PostgreSQL has "Frequently Asked Questions" lists available at http://wiki.postgresql.org/wiki/Category:FAQ, and you may find reading them interesting, even though some of those topics are covered in this chapter too.

Bulk loading

There are two slightly different types of bulk data loads you might want to do. The first type, and main focus of this section, is when you're initially populating an empty database. Sometimes you also need to do later bulk loads into tables that are already populated. In that case, some of the techniques ...