cityvox_prod=# select version(); version ----------------------------------------------------------------------------------------------------------- PostgreSQL 8.3RC2 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14) (1 row) cityvox_prod=# show shared_buffers; shared_buffers ---------------- 2GB (1 row) cityvox_prod=# show work_mem; work_mem ---------- 32MB (1 row) cityvox_prod=# show effective_cache_size; effective_cache_size ---------------------- 5GB (1 row) cityvox_prod=# show lc_collate; lc_collate ------------- fr_FR.UTF-8 (1 row) cityvox_prod=# show random_page_cost ; random_page_cost ------------------ 2 (1 row) (same result with a random page cost of 4) cityvox_prod=# \d association Table "cityvox.association" Column | Type | Modifiers ---------------------+-----------------------------+----------------------------------------------------------------------- numasso | integer | not null default nextval(('seq_association_numasso'::text)::regclass) nomasso | character varying(144) | nomassoofficiel | character varying(144) | not null mots_cleasso | character varying(150) | adremailasso | character varying(200) | adrurlsitepersoasso | character varying(400) | adresseasso | character varying(200) | codepostalasso | character varying(7) | villeasso | character varying(40) | codepaysasso | character varying(3) | dcreaasso | timestamp without time zone | not null default now() ddermodifasso | timestamp without time zone | not null default now() nbrclicssiteweb | integer | default 0 codequarasso | character varying(5) | not null nbradherents | integer | not null default 0 loginmodif | character varying(20) | not null default 'Association'::character varying logincrea | character varying(20) | not null default 'Association'::character varying adresseasso2 | character varying(200) | villepostale | character varying(40) | codeact | character varying(3) | wgslat | numeric(11,8) | wgslon | numeric(11,8) | vilsup | character varying(100) | fax | character varying(12) | telephone | character varying(12) | dderactivite | timestamp without time zone | not null default now() assomaj | integer | not null default 0 Indexes: "pk_association" PRIMARY KEY, btree (numasso) Foreign-key constraints: "fk_association_codepays" FOREIGN KEY (codepaysasso) REFERENCES pays(codepays) "fk_association_codequar" FOREIGN KEY (codequarasso) REFERENCES quartier(codequar) "fk_association_validation" FOREIGN KEY (codeact) REFERENCES statuttraitement(codestatutttmt) cityvox_prod=# \d assovil Table "cityvox.assovil" Column | Type | Modifiers ---------+----------------------+----------- numasso | integer | not null codevil | character varying(3) | not null Indexes: "pk_assovil" PRIMARY KEY, btree (numasso, codevil) Foreign-key constraints: "fk_assovil_codevil" FOREIGN KEY (codevil) REFERENCES vilsite(codevil) ON DELETE CASCADE "fk_assovil_numasso" FOREIGN KEY (numasso) REFERENCES association(numasso) ON DELETE CASCADE cityvox_prod=# \d evelieu Table "cityvox.evelieu" Column | Type | Modifiers -----------------+-----------------------------+-------------------- numlieu | integer | not null numeve | integer | not null ddebevelieu | timestamp without time zone | not null dfinevelieu | timestamp without time zone | not null logincrea | character varying(32) | not null loginmodif | character varying(32) | not null dcreaevelieu | timestamp without time zone | not null ddermajevelieu | timestamp without time zone | not null inforeservation | character varying(200) | codestatut | character varying(2) | not null prolongation | integer | not null default 0 nummanif | integer | flagphoto | integer | not null default 0 codestatutresa | integer | not null default 0 codemodelivr | character varying(1) | codetypebillets | character varying(1) | pushbilletterie | integer | not null default 9 partenaire_cit | integer | not null default 0 numasso | integer | Indexes: "pk_evelieu" PRIMARY KEY, btree (numlieu, numeve) "idx_evelieu_ddebevelieu_trunc" btree (date_trunc('day'::text, ddebevelieu)) "idx_evelieu_dfinevelieu" btree (dfinevelieu) "idx_evelieu_dfinevelieu_trunc" btree (date_trunc('day'::text, dfinevelieu)) "idx_evelieu_numeve" btree (numeve) "idx_evelieu_numeve_numlieu_ddebevelieu_dfinevelieu" btree (numeve, numlieu, ddebevelieu, dfinevelieu) "idx_evelieu_numeve_numlieu_dfinevelieu" btree (numeve, numlieu, dfinevelieu) "idx_evelieu_numeve_nummanif" btree (numeve, nummanif) "idx_evelieu_numlieu_ddermajevelieu" btree (numlieu, ddermajevelieu) "idx_on_evelieu_numeve_numlieu_dfinevelieu" btree (numeve, numlieu, date_trunc('day'::text, dfinevelieu)) Foreign-key constraints: "fk_evelieu_numasso" FOREIGN KEY (numasso) REFERENCES association(numasso) "fk_evelieu_ref_codemodelivr" FOREIGN KEY (codemodelivr) REFERENCES modelivraison(codemodelivr) ON DELETE CASCADE "fk_evelieu_ref_codetypebillets" FOREIGN KEY (codetypebillets) REFERENCES typebillets(codetypebillets) ON DELETE CASCADE "fk_evelieu_ref_eve" FOREIGN KEY (numeve) REFERENCES evenement(numeve) ON DELETE CASCADE "fk_evelieu_ref_lieu" FOREIGN KEY (numlieu) REFERENCES lieu(numlieu) ON DELETE CASCADE "fk_evelieu_ref_nummanif" FOREIGN KEY (nummanif) REFERENCES evenement(numeve) ON DELETE CASCADE "fk_evelieu_ref_statut" FOREIGN KEY (codestatut) REFERENCES statut(codestatut) ON DELETE CASCADE "fk_evelieu_statutresa" FOREIGN KEY (codestatutresa) REFERENCES statutresa(codestatutresa) ON DELETE CASCADE cityvox_prod=# \d lieu Table "cityvox.lieu" Column | Type | Modifiers ----------------------+-----------------------------+------------------------------ numlieu | integer | not null codequar | character varying(5) | not null a lot of other fields... Indexes: "pk_lieu" PRIMARY KEY, btree (numlieu) "idx_lieu_identifianturl" UNIQUE, btree (identifianturl) "idx_lieu_codepostallieu" btree (codepostallieu) "idx_lieu_codequar_nomlieu_upper_like" btree (codequar, upper(nomlieu::text) varchar_pattern_ops) "idx_lieu_codequar_notmoylieu_flagphoto_interditalaune" btree (codequar, notmoylieu, flagphoto, interditalaune) "idx_lieu_coordonnees_terrestres" gist (ll_to_earth(wgslat::double precision, wgslon::double precision)) "idx_lieu_dfinvalidlieu" btree (dfinvalidlieu) "idx_lieu_libvilpostalelieu" btree (libvilpostalelieu) "idx_lieu_nomlieu_upper_like" btree (upper(nomlieu::text) varchar_pattern_ops) "idx_lieu_numcamerapress" btree (numcamerapress) "idx_lieu_numlieu_codequar_dfinvalidlieu" btree (numlieu, codequar, dfinvalidlieu) "idx_lieu_presenceplus" btree (presenceplus) WHERE presenceplus = 1 "lieu_i_codequar" btree (codequar) "lieu_i_nomlieu" btree (nomlieu) Foreign-key constraints: "fk_lieu_est_situe_quartier" FOREIGN KEY (codequar) REFERENCES quartier(codequar) "fk_lieu_ref_sourceinfo" FOREIGN KEY (codesourceinfo) REFERENCES sourceinfo(codesourceinfo) "fk_lieu_tyvoielie_tyvoie" FOREIGN KEY (codetyvoie) REFERENCES tyvoie(codetyvoie) cityvox_prod=# \d vilquartier Table "cityvox.vilquartier" Column | Type | Modifiers ----------------+------------------------+----------------------------------------- codevil | character varying(3) | not null codequar | character varying(5) | not null liblong | character varying(100) | not null flagintramuros | character varying(1) | not null default 'O'::character varying libcourt | character varying(100) | not null Indexes: "pk_vilquartier" PRIMARY KEY, btree (codequar, codevil) "idx_vilquartier_codevil" btree (codevil) "vilquartier_i_codequar" btree (codequar) Foreign-key constraints: "fk_vilqtier_ref_quartier" FOREIGN KEY (codequar) REFERENCES quartier(codequar) ON DELETE CASCADE "fk_vilqtier_ref_vilsite" FOREIGN KEY (codevil) REFERENCES vilsite(codevil) ON DELETE CASCADE