PostgreSQL Performance Checklist

I found some very valuable tips in the web site of an unpublished book: Power PostgreSQL by Josh Berkus and Joe Conway. If you are working with large data sets and complex queries, pay special attention to the section that discusses work_mem.

One Response to “PostgreSQL Performance Checklist”

  1. Nathan says:

    The link for Power PostgreSQL is no longer working. Any chance you have some good information to share on tuning postgresql for data warehousing? I am currently looking at building a data warehouse in postgresql and would really appreciate any information you could share on maximizing the effectiveness of postgresql.

    Thanks,

    N

Leave a Reply