Re: A question on the query planner

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jared Carr <jared(at)89glass(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: A question on the query planner
Date: 2003-12-02 00:45:29
Message-ID: 8532.1070325929@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jared Carr <jared(at)89glass(dot)com> writes:
> I am currently working on optimizing some fairly time consuming queries
> on a decently large dataset.

It doesn't look that large from here ;-). I'd suggest experimenting
with reducing random_page_cost, since at least for your test query
it sure looks like everything is in RAM. In theory random_page_cost = 1.0
is the correct setting for all-in-RAM cases.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Erik Norvelle 2003-12-02 15:53:16 Update performance ... is 200, 000 updates per hour what I should expect?
Previous Message Bruce Momjian 2003-12-01 22:37:31 Re: Is clustering possible to enhance the performance?