Re: config postgresql.conf??

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: config postgresql.conf??
Date: 2002-07-12 15:56:33
Message-ID: web-1574707@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Tkach 2002-07-12 16:17:18 It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???)
Previous Message Luis Alberto Amigo Navarro 2002-07-12 15:32:50 Re: [HACKERS] please help on query