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.
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.
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