On 0, mwi <[EMAIL PROTECTED]> wrote:
> PostgreSQL is installed on a RedHat 7.1 with Kernel 2.4.2-2. The
> hardware is a PIII-500 with 256MB RAM and 10GB HD (IDE).
Does running
=# VACUUM ANALYZE
help?
Stefan
--
Q: Could you please describe a bovril sandwich?
Douglas Adams: Not on a family show
Hi everybody,
I'm having a serious performance problem. We're using PostgreSQL
(7.1.3) for data collection (appr. 3 000 000 new records per day).
Every night all records older than 3 days are deleted, after that a
vacuumdb is done. The table has about 7-8 M records and is about 2,5GB
size on the
