Обсуждение: WAL Sequence
Dear list member:
I have small problem,
below is the output from ls -larth command for listing WAL segments.
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.
Can anybody please suggest me is ther anything going wrong or am i just doing something silly. :)
OS:Suse 10.3 64 bit,PostgreSQL server:8.2.4
$ ls -alrth
total 129M
-rw------- 1 postgres postgres 269 2008-01-06 23:59 000000010000001700000003.00010588.backup
drwx------ 11 postgres postgres 4.0K 2008-01-06 23:59 ..
-rw------- 1 postgres postgres 16M 2008-01-07 08:59 000000010000001700000014
-rw------- 1 postgres postgres 16M 2008-01-07 09:59 000000010000001700000015
-rw------- 1 postgres postgres 16M 2008-01-07 10:59 000000010000001700000016
-rw------- 1 postgres postgres 16M 2008-01-07 11:59 000000010000001700000017
-rw------- 1 postgres postgres 16M 2008-01-07 12:59 000000010000001700000018
-rw------- 1 postgres postgres 16M 2008-01-07 13:59 000000010000001700000019
-rw------- 1 postgres postgres 16M 2008-01-07 14:59 00000001000000170000001A
drwxr-xr-x 2 postgres postgres 4.0K 2008-01-07 15:09 archive_status
drwxr-xr-x 3 postgres postgres 4.0K 2008-01-07 15:09 .
-rw------- 1 postgres postgres 16M 2008-01-07 15:15 000000010000001700000013
With Regards
Ashish
Chat on a cool, new interface. No download required. Click here.
I have small problem,
below is the output from ls -larth command for listing WAL segments.
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.
Can anybody please suggest me is ther anything going wrong or am i just doing something silly. :)
OS:Suse 10.3 64 bit,PostgreSQL server:8.2.4
$ ls -alrth
total 129M
-rw------- 1 postgres postgres 269 2008-01-06 23:59 000000010000001700000003.00010588.backup
drwx------ 11 postgres postgres 4.0K 2008-01-06 23:59 ..
-rw------- 1 postgres postgres 16M 2008-01-07 08:59 000000010000001700000014
-rw------- 1 postgres postgres 16M 2008-01-07 09:59 000000010000001700000015
-rw------- 1 postgres postgres 16M 2008-01-07 10:59 000000010000001700000016
-rw------- 1 postgres postgres 16M 2008-01-07 11:59 000000010000001700000017
-rw------- 1 postgres postgres 16M 2008-01-07 12:59 000000010000001700000018
-rw------- 1 postgres postgres 16M 2008-01-07 13:59 000000010000001700000019
-rw------- 1 postgres postgres 16M 2008-01-07 14:59 00000001000000170000001A
drwxr-xr-x 2 postgres postgres 4.0K 2008-01-07 15:09 archive_status
drwxr-xr-x 3 postgres postgres 4.0K 2008-01-07 15:09 .
-rw------- 1 postgres postgres 16M 2008-01-07 15:15 000000010000001700000013
With Regards
Ashish
Chat on a cool, new interface. No download required. Click here.
Ashish Karalkar <ashish_postgre@yahoo.co.in> writes:
> As far as my understanding every new WAL segment created is numerically greater than the previous one,but below out
showthe 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