Re: Analyzer is clueless

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: josh@xxxxxxxxxxxx
Subject: Re: Analyzer is clueless
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 17 Nov 2004 20:57:44 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx, "Jim C. Nasby" <decibel@xxxxxxxxxxx>, Simon Riggs <simon@xxxxxxxxxxxxxxx>, David Brown <time@xxxxxxxxxxxxxx>
Comments: In-reply-to Josh Berkus <josh@xxxxxxxxxxxx> message dated "Wed, 17 Nov 2004 17:41:16 -0800"
In-reply-to: <200411171741.16515.josh@xxxxxxxxxxxx>
References: <20041117160824.B694D3A3ECC@xxxxxxxxxxxxxxxxxxx> <1100730768.4113.7709.camel@xxxxxxxxxxxxxxxxxxxxx> <20041118002008.GL80532@xxxxxxxxxxx> <200411171741.16515.josh@xxxxxxxxxxxx>

>> I've seen cases where it seems the
>> planer doesn't think it'll be getting a unique value or a small set of
>> values even though stats indicates that it should be.

A test case exhibiting the problem would be helpful.

			regards, tom lane

References:
- Analyzer is clueless
  - From: David Brown
- Re: Analyzer is clueless
  - From: Simon Riggs
- Re: Analyzer is clueless
  - From: Jim C. Nasby
- Re: Analyzer is clueless
  - From: Josh Berkus

Prev by Date: Re: Analyzer is clueless
Next by Date: Re: postgres eating CPU
Previous by thread: Re: Analyzer is clueless
Next by thread: sort_mem affect on inserts?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux