Re: Performance query about large tables, lots of concurrent access

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karl Wright <kwright(at)metacarta(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance query about large tables, lots of concurrent access
Date: 2007-06-19 15:48:31
Message-ID: 29698.1182268111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Karl Wright <kwright(at)metacarta(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2007-06-19 15:49:58 Re: Performance query about large tables, lots of concurrent access
Previous Message Gregory Stark 2007-06-19 15:46:20 Re: Performance query about large tables, lots of concurrent access