by arhipov@[EMAIL PROTECTED]
(Vlad Arkhipov)
May 7, 2008 at 09:48 AM
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@[EMAIL PROTECTED]
> 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@[EMAIL PROTECTED]
" type="cite">
<pre wrap="">Vlad Arkhipov <a class="moz-txt-link-rfc2396E"
href="mailto:arhipov@[EMAIL PROTECTED]
"><arhipov@[EMAIL PROTECTED]
>
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--
