Re: seqscan strikes again - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: seqscan strikes again
Date
Msg-id 41931BA3.5010008@bigfoot.com
Whole thread Raw
In response to seqscan strikes again  ("Jim C. Nasby" <decibel@decibel.org>)
List 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

pgsql-performance by date:

Previous
From: Edwin Eyan Moragas
Date:
Subject: Re: How to speed-up inserts with jdbc
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: How to speed-up inserts with jdbc