Re: Slow Query on Postgres 8.2

Поиск
Список
Период
Сортировка
Искать
От
Dave Dutcher
Тема
Re: Slow Query on Postgres 8.2
Дата
Msg-id
012601c73357$1736ff00$8300a8c0@tridecap.com
Ответ на
Список
Дерево обсуждения
Slow Query on Postgres 8.2 "Dave Dutcher" <dave@tridecap.com>
Re: Slow Query on Postgres 8.2 "Adam Rich" <adam.r@sbcglobal.net>
Re: Slow Query on Postgres 8.2 "Dave Dutcher" <dave@tridecap.com>
Re: Slow Query on Postgres 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: Slow Query on Postgres 8.2 "Dave Dutcher" <dave@tridecap.com>
Re: Slow Query on Postgres 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: Slow Query on Postgres 8.2 "Dave Dutcher" <dave@tridecap.com>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org 
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Tom Lane
> 
> [ fools around with it for awhile... ]  I think this is already fixed
> for 8.2.1.  Note the costs of the two related index scans:

I installed 8.2.1 this morning and it works much better.  The query that was
taking 3411.429ms on 8.2.0 now takes 9.3ms.  Thanks for your help.

В списке pgsql-performance по дате отправления
От: Bruce Momjian
Дата:
От: Steven Flatt
Дата:
FAQ