Re: [GENERAL] How to tell how much of the database is being used for data.

2006-02-26 Thread Michael Fuhr
On Fri, Feb 24, 2006 at 03:04:27PM -0800, Steve Oualline wrote: > Question: How can I tell how much free space is in the database itself? contrib/pgstattuple shows dead tuple and free space statistics for individual tables. Will that work? > Background: We want to keep as many records as possibl

[GENERAL] How to tell how much of the database is being used for data.

2006-02-24 Thread Steve Oualline
Title: How to tell how much of the database is being used for data. Question: How can I tell how much free space is in the database itself? Background: We want to keep as many records as possible in the database as possible.  Currently we fill the database until the disk usage reaches 80