Re: Seqscan problem

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

Tom Lane writes:
> 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
>
>

1024M

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-05-07 01:57:53 Re: Possible Redundancy/Performance Solution
Previous Message Guillaume Smet 2008-05-07 00:31:52 Re: pgfouine - commit details?