Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
От | Jim C. Nasby |
---|---|
Тема | Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) |
Дата | |
Msg-id | 20050407214015.GT93835@decibel.org обсуждение исходный текст |
Ответ на | Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane) |
Список | pgsql-performance |
Дерево обсуждения
Plan for relatively simple query seems to be very inefficient
(Arjen van der Meijden,
)
Re: Plan for relatively simple query seems to be very inefficient (Steve Atkins, )
Re: Plan for relatively simple query seems to be very inefficient (Arjen van der Meijden, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Arjen van der Meijden, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) ("Jim C. Nasby", )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan (John A Meinel, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) ("Jim C. Nasby", )
Re: Recognizing range constraints (was Re: Plan for (Simon Riggs, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Bruno Wolff III, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Mischa, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (, )
Re: Plan for relatively simple query seems to be very inefficient ("Dave Held", )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Mischa, )
Re: Plan for relatively simple query seems to be very inefficient (Steve Atkins, )
Re: Plan for relatively simple query seems to be very inefficient (Arjen van der Meijden, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Arjen van der Meijden, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) ("Jim C. Nasby", )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan (John A Meinel, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: [HACKERS] Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) ("Jim C. Nasby", )
Re: Recognizing range constraints (was Re: Plan for (Simon Riggs, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Bruno Wolff III, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Mischa, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (Tom Lane, )
Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient) (, )
Re: Plan for relatively simple query seems to be very inefficient ("Dave Held", )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Tom Lane, )
Re: Plan for relatively simple query seems to be very inefficient (Mischa, )
On Wed, Apr 06, 2005 at 06:35:10PM -0400, Tom Lane wrote: > "Jim C. Nasby" <> writes: > > On Wed, Apr 06, 2005 at 06:09:37PM -0400, Tom Lane wrote: > >> Can anyone suggest a more general rule? Do we need for example to > >> consider whether the relation membership is the same in two clauses > >> that might be opposite sides of a range restriction? It seems like > >> > >> a.x > b.y AND a.x < b.z > > > In a case like this, you could actually look at the data in b and see > > what the average range size is. > > Not with the current statistics --- you'd need some kind of cross-column > statistics involving both y and z. (That is, I doubt it would be > helpful to estimate the average range width by taking the difference of > independently-calculated mean values of y and z ...) But yeah, in > principle it would be possible to make a non-default estimate. Actually, it might be possible to take a SWAG at it using the histogram and correlation stats. You know... since getting universally useful cross-platform stats seems to be pretty pie-in-the-sky, would it be possible to generate more complex stats on the fly from a sampling of a table? If you're looking at a fairly sizeable table ISTM it would be worth sampling the rows on 10 or 20 random pages to see what you get. In this case, you'd want to know the average difference between two fields. Other queries might want something different. -- Jim C. Nasby, Database Consultant Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
В списке pgsql-performance по дате отправления:
Предыдущее
От: "Greg Sabino Mullane"Дата:
Сообщение: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)