[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

[GENERAL] postmaster startup time

2006-02-01 Thread Steve Oualline
Title: postmaster startup time What is the maximum time it takes for postmaster to start? Postmaster takes some time to open it's connections, process any WAL entries, and start accepting connections. What's the longest time you'd expect between the execution of the postmaster command

[GENERAL] postmaster crash

2006-01-31 Thread Steve Oualline
We have an interesting problem here. We have a server at a customer's site on which the database will not come up. Because of the nature of the product we make, we don't turn on Postgresql logs, so no log data is avaliable. What we see is that when we start postmaster it starts, but anyone who

[GENERAL] WAL questions

2006-01-27 Thread Steve Oualline
Title: WAL questions We have a system with 1202 files in the WAL directory (pg_xlog). When we start postmaster, it goes into the starting state for 5 minutes and then crashes. Questions: 1) What is the biggest number of WAL files you've seen and what were you doing to the database at