Re: [PERFORM] General performance problem!

2004-08-17 Thread olivier HARO
Thanks for the tip for the index on multiple columns ! (I never do inserts on this table so insert time doesn't matter) Mys posgresql version is : PostgreSQL 7.2.1 Here are the results of the EXPLAIN ANALYZE you asked me to execute. explain analyse select cp from base_aveugle where cp='69740'

[PERFORM] General performance problem!

2004-08-17 Thread olivier HARO
Hello,   I have a dedicated server for my posgresql database :   P4 2.4 GHZ HDD IDE 7200 rpm 512 DDR 2700   I have a problem whith one table of my database :   CREATE SEQUENCE "base_aveugle_seq" START 1;CREATE TABLE "base_aveugle" ( "record_id" integer DEFAULT nextval('"base_aveugle_seq"'::t