olivier HARO wrote:
This table contains 5 000 000 records

I have a PHP application which often makes queries on this table (especially on the 
"cp","naf","effectif" fields)

Querries are like :
      select (distint cp) from base_aveugle where cp='201A' and effectif between 1 and 
      select (*) from base_aveugle where naf in ('721A','213F','421K') and cp in 
('54210','21459','201A') and effectif < 150

We'll need to know what version of PostgreSQL you're using and also what the output of EXPLAIN ANALYZE shows for your example queries.

  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to