Postgres Pro
Downloads
Home   >   mailing lists

Re: Seqscan problem - Mailing list pgsql-performance

From Tom Lane
Subject Re: Seqscan problem
Date
Msg-id 13631.1210083727@sss.pgh.pa.us
Whole thread Raw
In response to Seqscan problem  (Vlad Arkhipov <arhipov@dc.baikal.ru>)
Responses Re: Seqscan problem
List pgsql-performance
Tree view 
Vlad Arkhipov <arhipov@dc.baikal.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: plan difference between set-returning function with ROWS within IN() and a plain join
Next
From: Frank van Vugt
Date:
Subject: Re: plan difference between set-returning function with ROWS within IN() and a plain join