At 03:11 PM 18/12/2002 +0100, Roel Rozendaal - IC&S wrote:
At 12:47 PM 18/12/2002 +0100, Roel Rozendaal - IC&S wrote:
pg_toast_10945937 | 3841293
It is the messageblks table. However, the query
select sum(blocksize) from messageblks;
(which should return the amount of actual data in the table) gives ~10 GB
- so where does the extra 20 GB come from?
Wasted space because the FSM is not reclaiming it properly; this happens on
very high transient data databases when MAX_FSM_* are too low and/or VACUUM
frequency is too low. The default is to remember about 80MB of free space -
which you will easily exceed between daily vacuums.
The system has high-speed SCSI disks, a PIII 1.2 GHz processor and 512 MB
of ram - should be sufficient shouldn't it?
Plenty. When you say the system dies during a vacuum, can you be more
specific about the cause? Can you also arrange downtime to do a vacuum FULL
followed by hourly VACUUMs? You may find that the system will not die if
vacuum is run more regularly.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
