Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 456F72E0039
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue,  6 May 2008 21:48:43 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 93063-08
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue,  6 May 2008 21:48:34 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from dc.baikal.ru (dc.baikal.ru [212.176.3.237])
	by developer.postgresql.org (Postfix) with ESMTP id 704B72E004D
	for <pgsql-performance@postgresql.org>;
	Tue,  6 May 2008 21:48:39 -0300 (ADT)
Received: from it319k5.dc-local (it319k5.dc-local [10.0.4.75])
	(authenticated bits=0)
	by dc.baikal.ru (8.13.8/8.13.8) with ESMTP id m470mZNX030801;
	Wed, 7 May 2008 09:48:35 +0900
Message-ID: <4820FC64.9090308@dc.baikal.ru>
Date: Wed, 07 May 2008 09:48:36 +0900
From: Vlad Arkhipov <arhipov@dc.baikal.ru>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-performance@postgresql.org
Subject: Re: Seqscan problem
References: <48203D7B.2000809@dc.baikal.ru> <13631.1210083727@sss.pgh.pa.us>
In-Reply-To: <13631.1210083727@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------050800070300090902080602"
X-Virus-Scanned: ClamAV version 0.93,
	clamav-milter version 0.93 on dc.baikal.ru
X-Virus-Status: Clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.000,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200805/112
X-Sequence-Number: 30080

This is a multi-part message in MIME format.
--------------050800070300090902080602
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------050800070300090902080602
Content-Type: text/html; charset=windows-1251
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=windows-1251"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tom Lane writes:
<blockquote cite="mid:13631.1210083727@sss.pgh.pa.us" type="cite">
  <pre wrap="">Vlad Arkhipov <a class="moz-txt-link-rfc2396E" href="mailto:arhipov@dc.baikal.ru">&lt;arhipov@dc.baikal.ru&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">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.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
What have you got effective_cache_size set to?

			regards, tom lane

  </pre>
</blockquote>
<br>
1024M
</body>
</html>

--------------050800070300090902080602--