[PERFORM] Time of query result delivery

Hello. A description of what you are trying to achieve and what results you expect.: There are two PG server: physical and virtaul. Physical server hardware: 1 Xeon(R) CPU E31235 @ 3.20GHz 8GB RAM sw RAID 2x250GB WesternDigital SATA. iperf test between PC and Physical server shown 891 Mbit/sec (o

[PERFORM] Increasing query time after updates

Hi, We have a PostgreSQL DB, version 8.4 on a Suse Linux system. Every night a script runs with several updates and inserts. The query time at day increases after approximately 3 weeks from a few minutes to about an hour. After export, drop and import the DB the query time is again at a few min