| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> |
| Cc: | pggeneral <pgsql-general(at)postgresql(dot)org>, ashish(dot)karalkar(at)netcore(dot)co(dot)in |
| Subject: | Re: WAL Sequence |
| Date: | 2008-01-07 19:59:29 |
| Message-ID: | 24439.1199735969@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> writes:
> As far as my understanding every new WAL segment created is numerically greater than the previous one,but below out show the WAL 13 is created after wal 14,15,16,17,18,19 checked by creation time.
You're in error to assume that the creation times are always matched to
the file names.
What is actually happening here is that the 00013 file is the latest in
actual use, and the ones that are named numerically higher are available
to use but haven't yet been written into. Their mod times correspond to
when they were last written into under their former names as prior
segments.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-01-07 20:00:59 | Re: calculating shared data memory space |
| Previous Message | Greg Smith | 2008-01-07 19:46:50 | Re: Performance problem. Could it be related to 8.3-beta4? |