From eeeggg499@netscape.net Thu Feb 19 17:07:26 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5CD96D1D132 for ; Thu, 19 Feb 2004 17:07:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 41946-01 for ; Thu, 19 Feb 2004 13:07:19 -0400 (AST) Received: from imo-d07.mx.aol.com (imo-d07.mx.aol.com [205.188.157.39]) by svr1.postgresql.org (Postfix) with ESMTP id B91BAD1B52F for ; Thu, 19 Feb 2004 13:07:13 -0400 (AST) Received: from imo-d01.mx.aol.com (imo-d01.mx.aol.com [205.188.157.33]) by imo-d07.mx.aol.com (v93.12) with ESMTP id RELAYIN1-24034ed30260; Thu, 19 Feb 2004 12:06:56 -0500 Received: from Eeeggg499@netscape.net by imo-d01.mx.aol.com (mail_out_v36_r4.14.) id k.2.c2e49b2 (16239) for ; Thu, 19 Feb 2004 12:06:46 -0500 (EST) Received: from netscape.net (host191.200-82-26.telecom.net.ar [200.82.26.191]) by air-in03.mx.aol.com (v98.6) with ESMTP id MAILININ33-3f6f4034ed233c2; Thu, 19 Feb 2004 12:06:45 -0500 Message-ID: <4034EE99.9090105@netscape.net> Date: Thu, 19 Feb 2004 14:12:57 -0300 From: Eduardo Leva User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: WAL logs and segment files Content-Type: multipart/alternative; boundary="------------050707000800000204000608" X-AOL-IP: 200.82.26.191 X-Mailer: Unknown (No Version) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/304 X-Sequence-Number: 12478 --------------050707000800000204000608 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment files, each 16 MB in size. Each segment is divided into 8 kB pages. The log record headers are described in access/xlog.h; record content is dependent on the type of event that is being logged. Segment files are given ever-increasing numbers as names, starting at 0000000000000000. The numbers do not wrap, at present, but it should take a very long time to exhaust the available stock of numbers. " in item 12.2 Implementation. The question is: How do I solve this situation, the remarked situation? The answer is not in the docs. Thanks. Pd. Sorry about my poor english. I speak spanish every day of my 3rd. world's life... Sigan adelante... Saludos. Eduardo Leva Programador Santa Fe Argentina. --------------050707000800000204000608 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, guys... I'm reading the version 7.3.4 documentation and I found this: "
"WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment
 files, each 16 MB in size. Each segment is divided into 8 kB pages. The
 log record headers are described in access/xlog.h; record content is
 dependent on the type of event that is being logged. Segment files are
 given ever-increasing numbers as names, starting at 0000000000000000. The
 numbers do not wrap, at present, but it should take a very long time to
 exhaust the available stock of numbers. "
in item 12.2 Implementation. The question is: How do I solve this situation, the remarked situation? The answer is not in the docs. Thanks.

Pd. Sorry about my poor english. I speak spanish every day of my 3rd. world's life...
Sigan adelante... Saludos.

Eduardo Leva
Programador
Santa Fe Argentina.
--------------050707000800000204000608-- From pgman@candle.pha.pa.us Fri Feb 20 20:29:41 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A00D9D1E0CD for ; Fri, 20 Feb 2004 20:29:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35392-05 for ; Fri, 20 Feb 2004 16:29:37 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 9F2F7D1E0C7 for ; Fri, 20 Feb 2004 16:29:34 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i1KKTNJ22723; Fri, 20 Feb 2004 15:29:23 -0500 (EST) From: Bruce Momjian Message-Id: <200402202029.i1KKTNJ22723@candle.pha.pa.us> Subject: Re: WAL logs and segment files In-Reply-To: <4034EE99.9090105@netscape.net> To: Eduardo Leva Date: Fri, 20 Feb 2004 15:29:23 -0500 (EST) Cc: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/313 X-Sequence-Number: 12487 Eduardo Leva wrote: > Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " > > "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment > files, each 16 MB in size. Each segment is divided into 8 kB pages. The > log record headers are described in access/xlog.h; record content is > dependent on the type of event that is being logged. Segment files are > given ever-increasing numbers as names, starting at 0000000000000000. The > numbers do not wrap, at present, but it should take a very long time to > exhaust the available stock of numbers. " > > in item 12.2 Implementation. The question is: How do I solve this > situation, the remarked situation? The answer is not in the docs. Thanks. What situation do you need to solve? The wrapping? The documention states "a very long time", but it more of a joke. That number would be huge to wrap around and you would be updating your PostgreSQL version long before it would ever wrap. The number is actually an int8 that has a maximum value of: 18446744073709551616 -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 From cognosco@tentacle.net Fri Feb 20 22:05:51 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C5C00D1F736 for ; Fri, 20 Feb 2004 22:05:51 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55457-06 for ; Fri, 20 Feb 2004 18:05:51 -0400 (AST) Received: from mspiggy.office.timbuk2.com (dsl092-028-014.sfo4.dsl.speakeasy.net [66.92.28.14]) by svr1.postgresql.org (Postfix) with ESMTP id 8B09DD1F6E7 for ; Fri, 20 Feb 2004 18:05:48 -0400 (AST) Received: (qmail 5219 invoked by uid 509); 20 Feb 2004 22:04:11 -0000 Received: from cognosco@tentacle.net by mspiggy.office.timbuk2.com by uid 107 with qmail-scanner-1.20 (clamuko: 0.65. spamassassin: 2.61. Clear:RC:0(192.168.1.253):SA:0(-4.9/5.0):. Processed in 0.69143 secs); 20 Feb 2004 22:04:11 -0000 Received: from snarf.office.timbuk2.com (HELO ?192.168.1.253?) (kaolin@timbuk2.com@192.168.1.253) by mspiggy.office.timbuk2.com with SMTP; 20 Feb 2004 22:04:10 -0000 Mime-Version: 1.0 (Apple Message framework v609) In-Reply-To: <200402202029.i1KKTNJ22723@candle.pha.pa.us> References: <200402202029.i1KKTNJ22723@candle.pha.pa.us> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: kaolin fire Subject: Re: WAL logs and segment files Date: Fri, 20 Feb 2004 14:05:49 -0800 To: pgsql-admin@postgresql.org X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/315 X-Sequence-Number: 12489 If you know where I can get a 1.5e+11 terabyte drive, I'd love to hear it. ;) -kaolin fire -http://erif.org/code/fallingup/ On Feb 20, 2004, at 12:29 PM, Bruce Momjian wrote: > Eduardo Leva wrote: >> Hi, guys... I'm reading the version 7.3.4 documentation and I found >> this: " >> >> "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of >> segment >> files, each 16 MB in size. Each segment is divided into 8 kB pages. >> The >> log record headers are described in access/xlog.h; record content is >> dependent on the type of event that is being logged. Segment files >> are >> given ever-increasing numbers as names, starting at >> 0000000000000000. The >> numbers do not wrap, at present, but it should take a very long time >> to >> exhaust the available stock of numbers. " >> >> in item 12.2 Implementation. The question is: How do I solve this >> situation, the remarked situation? The answer is not in the docs. >> Thanks. > > What situation do you need to solve? The wrapping? The documention > states "a very long time", but it more of a joke. That number would be > huge to wrap around and you would be updating your PostgreSQL version > long before it would ever wrap. > > The number is actually an int8 that has a maximum value of: > > 18446744073709551616 > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match From scott@QNET.COM Sat Feb 21 00:14:23 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3E73AD1D4E7 for ; Sat, 21 Feb 2004 00:14:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95491-10 for ; Fri, 20 Feb 2004 20:14:24 -0400 (AST) Received: from mx-i.qnet.com (mx-i.qnet.com [209.221.198.23]) by svr1.postgresql.org (Postfix) with ESMTP id 1B552D1D132 for ; Fri, 20 Feb 2004 20:14:21 -0400 (AST) Received: from cello.qnet.com ([209.221.198.10]) by mx-i.qnet.com with esmtp (Exim 4.30) id 1AuKmh-0001a5-Tz; Fri, 20 Feb 2004 16:14:19 -0800 Received: from scott (arc0-pool223-158.dial.qnet.com [209.221.223.158]) by cello.qnet.com (8.9.3/8.9.1) with SMTP id QAA06554; Fri, 20 Feb 2004 16:14:12 -0800 (PST) Message-ID: <001b01c3f80f$2fcd7de0$9edfddd1@scott> From: "scott" To: "Bruce Momjian" Cc: , "Cc:" References: <200402202029.i1KKTNJ22723@candle.pha.pa.us> Subject: Re: WAL logs and segment files Date: Fri, 20 Feb 2004 16:10:59 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/318 X-Sequence-Number: 12492 Take me off your list! You have the wrong scott! ----- Original Message ----- From: "Bruce Momjian" To: "Eduardo Leva" Cc: Sent: Friday, February 20, 2004 12:29 PM Subject: Re: [ADMIN] WAL logs and segment files > Eduardo Leva wrote: > > Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " > > > > "WAL logs are stored in the directory $PGDATA/pg_xlog, as a set of segment > > files, each 16 MB in size. Each segment is divided into 8 kB pages. The > > log record headers are described in access/xlog.h; record content is > > dependent on the type of event that is being logged. Segment files are > > given ever-increasing numbers as names, starting at 0000000000000000. The > > numbers do not wrap, at present, but it should take a very long time to > > exhaust the available stock of numbers. " > > > > in item 12.2 Implementation. The question is: How do I solve this > > situation, the remarked situation? The answer is not in the docs. Thanks. > > What situation do you need to solve? The wrapping? The documention > states "a very long time", but it more of a joke. That number would be > huge to wrap around and you would be updating your PostgreSQL version > long before it would ever wrap. > > The number is actually an int8 that has a maximum value of: > > 18446744073709551616 > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match