On Thu, May 23, 2013 at 1:25 AM, Amit Langote <[email protected]> wrote: > Okay, now I understand. Also, looking at his "ls -l pg_xlog", I could > find that modified timestamps of all those pre-allocated segments are > about similar (around 12:10), whereas the latest modified time (15:37) > is of segment 000000010000000E000000A7. > > Wonder if whatever configuration he is using is sub-optimal that these > many WAL segments can be re-cycled upon a checkpoint? Or is this okay?
Is archive_mode=on? What is archive_command? Is the server in the recovery mode? -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: [email protected] -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
