Re: Performance problem

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
>