Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5B4bUE30607 for ; Mon, 11 Jun 2001 00:37:31 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f5B4bMH18423; Mon, 11 Jun 2001 00:37:22 -0400 (EDT) From: Bruce Momjian Message-Id: <200106110437.f5B4bMH18423@candle.pha.pa.us> Subject: Re: maximum number of rows in table - what about oid limits? In-Reply-To: <6671.991879991@sss.pgh.pa.us> "from Tom Lane at Jun 6, 2001 10:13:11 pm" To: Tom Lane Date: Mon, 11 Jun 2001 00:37:22 -0400 (EDT) CC: Josh Berkus , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200106/147 X-Sequence-Number: 3368 > "Josh Berkus" writes: > > Given this, why bother with system-generated OIDs on user rows at all? > > Why not simply reserve the OIDs for the system tables? > > An option to not generate OIDs unless requested (on a table-by-table > basis) has been discussed. It seems like a fine near-term solution > to me. 8-byte OIDs are a longer-term solution, because they'll break > a lot of things (including clients...) > > >> This is certainly not ideal, but it's not nearly as big a problem as > >> transaction ID wraparound. You can live with it, whereas right now > >> xact ID wraparound is catastrophic. That we gotta work on, soon. > > > Nothing like reassuring us commercial DB users, Tom. :-P > > Can you describe what you're talking about? > > It's in the archives: after 4G transactions, your database curls up > and dies. When your pg_log starts to approach 1Gbyte (2 bits per > transaction) you'd better plan on dump/initdb/reload. I wonder is we should check the size of pg_log on startup and warn the administrator? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026