Re: [HACKERS] Vacuum writes on empty system

2004-10-01 Thread Tom Lane
"onion" <[EMAIL PROTECTED]> writes: > I just loaded up 9GB of data (32 tables) into a brand new system (Postgres > 7.4.5 on Linux 2.4 with 1GB ram, IDE). I immediately ran "vacuum analyze" > but Postgres seems to be writing a lot to disk even though none of the > tables have incurred any UPDATES or

[HACKERS] Vacuum writes on empty system

2004-10-01 Thread onion
I just loaded up 9GB of data (32 tables) into a brand new system (Postgres 7.4.5 on Linux 2.4 with 1GB ram, IDE). I immediately ran "vacuum analyze" but Postgres seems to be writing a lot to disk even though none of the tables have incurred any UPDATES or DELETES yet and there are no other connecti