Re: Seqscan problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Seqscan problem
Date: 2008-05-06 14:22:07
Message-ID: 13631.1210083727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> writes:
> I've just discovered a problem with quite simple query. It's really
> confusing me.
> Postgresql 8.3.1, random_page_cost=1.1. All tables were analyzed before
> query.

What have you got effective_cache_size set to?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Antoine Baudoux 2008-05-06 15:03:44 multiple joins + Order by + LIMIT query performance issue
Previous Message Tom Lane 2008-05-06 14:17:10 Re: plan difference between set-returning function with ROWS within IN() and a plain join