Re: A slow query - Help please?

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: A slow query - Help please?
Дата
Msg-id 449273AC.8030505@magproductions.nl
обсуждение исходный текст
Ответ на A slow query  (Alban Hertroys <alban@magproductions.nl>)
Ответы Re: A slow query - Help please?  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Confused about locales  (John Gunther <owner@bucksvsbytes.com>)
Список pgsql-general
Alban Hertroys wrote:
> Hi all,
>
> We're using some 3rd party product that uses inheritence, and the
> following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any
> suggestions how to speed it up?

We really need this solved. Isn't anybody able to shed some light on
this? Is it possible to make this query use an index scan, preferably
w/o disabling sequential scanning?

Regards,
--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

В списке pgsql-general по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: postgres and ldap
Следующее
От: John Gunther
Дата:
Сообщение: Forcing backslash to be treated as ordinary string character