Postgres Pro
Downloads
Home   >   mailing lists

Re: config postgresql.conf?? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: config postgresql.conf??
Date
Msg-id web-1574707@davinci.ethosmedia.com
Whole thread Raw
In response to config postgresql.conf??  (Jie Liang <jie@stbernard.com>)
List pgsql-sql
Tree view 
Jie,

> What parameter I should change in order to make postmaster taking CPU
> as
> much as
> possible?
> Maybe I should ask: how can I make big tables equijoin faster?
> I have a serveral tables that contain more 2.5 million records, I
> need to
> equijoin
> those tables often.

There are several good articles on PostgreSQL performance tuning up at
http://techdocs.postgresql.org/

check 'em out.

-Josh

pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: config postgresql.conf??
Next
From: Dmitry Tkach
Date:
Subject: It is a bug in pred_test()! (Was: Please, HELP! Why is the query plan so wrong???)