Re: [GENERAL] confusting results from pg_database_size

2010-02-04 Thread Adrian Klaver
On Thursday 04 February 2010 1:52:36 am AutoVHC Dev Team wrote: > As part of an testing an archive solution I've updated and deleted 3 or 4 > million rows in different tables. I wanted to see how much this shrunk the > database size by running, so I ran a VACUUM FULL FREEZE ANALYZE on both > databa

[GENERAL] confusting results from pg_database_size

2010-02-04 Thread AutoVHC Dev Team
As part of an testing an archive solution I've updated and deleted 3 or 4 million rows in different tables. I wanted to see how much this shrunk the database size by running, so I ran a VACUUM FULL FREEZE ANALYZE on both databases - this took a long time, which is ok considering the number of rows