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
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
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
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