,
Duane
-Original
Message-
From: olivier HARO
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004
6:30 AM
To:
[EMAIL PROTECTED]
Subject: [PERFORM] General
performance problem!
Hello,
I
have a dedicated server for my posgresql database :
P4
2.4 GHZ
HDD
IDE 7200 rpm
512
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'
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
150
select (
olivier HARO wrote:
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_a
al Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of olivier
HAROSent: dinsdag 17 augustus 2004 15:30To:
[EMAIL PROTECTED]Subject: [PERFORM] General
performance problem!
Hello,
I have a dedicated server for my
posgresql database :
P4 2.4 GHZ
HDD ID
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