> How big is this database? (how many rows?)
around 10000 rows
> Do you have more than one table?
2 big tables (10-16 col) and 18 small tables (2-3 col).
only 1 table cause me trouble :
medias=> \d contacts_secteurs
Table = contacts_secteurs
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| contact_id | int4 |
4 |
| soussecteur_id | int2 |
2 |
| secteur_id | int2 |
2 |
+----------------------------------+----------------------------------+-----
--+
Index: contacts_secteurs_contact_id_ke
and it seem that the contacts_secteurs_contact_id_ke is causing also
trouble. can i "reload" it ?
patrick