Hi,

i have a problem with index in pgsql 7.2.1(i think it's indexes the problem). I insert a lot of records in a table and delete in a ratio of 1:5... When I do request on this table..it's working fine for 10-12 hours but after it's very slow (10-15 minutes) but when I delete the indexes and recreate it.. it's ok for 10-12 hours again.. it's a live db 24/7... I cannot stop the db often... process insert record all the time...

have idea? pgsql problem?

 

thanks

 

Stephane



---------------------------------
Yahoo! Mail -- Une adresse @yahoo.fr gratuite et en français !