Re: Performance problem - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Performance problem
Date
Msg-id Pine.BSF.4.21.0101241133470.57849-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Performance problem  (Andreas Rieke <andreas.rieke@isl-online.de>)
List pgsql-general
Have you done a vacuum analyze on the database?  And what
does explain show for the query?

On Wed, 24 Jan 2001, Andreas Rieke wrote:

>
> SELECT DISTINCT level_1_de from property_list pl, properties p,
> materials m where m.oid=p.material_oid and p.property_list_oid=pl.oid
> and m.is_new=FALSE;
>
> The command returns about 10 items.
> The tables mentioned contain the following number of entries:
>
> materials: 2476
> properties: 30 323
> property_list: 349
>
>
> I hope that using INDEXes should speed up the search, but although I
> made
> several attempts, the search is too slow. Since I am not an expert on
> databases and PostgreSQL, maybe somebody who had similar problems is
> able to help me.
> Also, I do not know whether the DISTINCT in the SELECT statement forces
> the database to
> use algorithms which have not been optimized yet.
>
> Thanks in advance for your help,
>
> kind regards,
>
> Andreas
>


pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: backend closing connections while executing...
Next
From: Heiko Irrgang
Date:
Subject: timestamp usage?