Postgres Pro
Downloads
Home   >   mailing lists

Re: Seqscan problem - Mailing list pgsql-performance

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

1024M

pgsql-performance by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: pgfouine - commit details?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Possible Redundancy/Performance Solution