Postgres Pro
Downloads
Home   >   mailing lists

Re: A slow query - Help please? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: A slow query - Help please?
Date
Msg-id 449273AC.8030505@magproductions.nl
Whole thread Raw
In response to A slow query  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: A slow query - Help please?  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Confused about locales  (John Gunther <owner@bucksvsbytes.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: postgres and ldap
Next
From: John Gunther
Date:
Subject: Forcing backslash to be treated as ordinary string character