Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance query about large tables, lots of concurrent access - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance query about large tables, lots of concurrent access
Date
Msg-id 29698.1182268111@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
List pgsql-performance
Tree view 
Karl Wright <kwright@metacarta.com> writes:
> I did an ANALYZE on that table and repeated the explain, and got this:
> ...
> ... even more wildly wrong.

Hmm.  You might need to increase the statistics target for your larger
tables.  It's probably not a big deal for queries like this one, but I'm
worried that you may be getting bad plans for complicated joins.

            regards, tom lane

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Performance query about large tables, lots of concurrent access
Next
From: Francisco Reyes
Date:
Subject: Re: Performance query about large tables, lots of concurrent access