Re: seqscan strikes again

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Subject: Re: seqscan strikes again
Date: 2004-11-11 07:58:27
Message-ID: 41931BA3.5010008@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jim C. Nasby wrote:
> I'm wondering if there's any way I can tweak things so that the estimate
> for the query is more accurate (I have run analyze):

Can you post your configuration file ? I'd like to see for example your
settings about: random_page_cost and effective_cache_size.

Regards
Gaetano Mendola

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gaetano Mendola 2004-11-11 08:03:24 Re: vacuum analyze slows sql query
Previous Message Mike Rylander 2004-11-11 05:53:09 Re: int4 in a GiST index