Hi there,
maybe anyone can help me with the following problem.
Using PostgreSQL 7.03 on a Suse 6.3 Linux (kernel 2.2.13) with a P3/550
MHz,
I get a performance problem with a select command which takes up to 10
seconds.
The following tables are involved in this command:
CREATE TABLE "property_list" (
"number" float8,
"level_1_de" text,
"level_1_en" text,
"level_2_de" text,
"level_2_en" text,
...
);
CREATE TABLE "properties" (
"material_oid" oid NOT NULL,
"property_list_oid" oid NOT NULL,
...
);
CREATE TABLE "materials" (
"user_oid" oid NOT NULL,
"material_class" oid,
"is_new" bool DEFAULT 't'::bool,
...
);
and the command is
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