WAL questions

From: "Steve Oualline" <soualline(at)stbernard(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: WAL questions
Date: 2006-01-27 19:11:27
Message-ID: E7E213858379814A9AE48CA6754F5ECB0675104F@mail01.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 the time?

2) When postmaster starts, it replays the WAL files. During this time
any connection is rejected with an error indicating that the database
is starting up. What the longest amount of time that you'd expect
postmaster to be in the "starting up" state?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gray 2006-01-27 20:23:36 Re: xml_valid function
Previous Message Bruno Wolff III 2006-01-27 18:28:28 Re: Allowing Custom Fields