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'
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