Re: 4 billion + oids - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: 4 billion + oids
Date
Msg-id 20030325023241.GB6247@dcc.uchile.cl
Whole thread Raw
In response to Re: 4 billion + oids  ("Andrew Bartley" <abartley@evolvosystems.com>)
List pgsql-general
On Tue, Mar 25, 2003 at 11:43:57AM +1100, Andrew Bartley wrote:

> 3.reduce number of tables,indexes etc.
>  pros - less chance of oid clash
>  cons - application may require high number of tables,indexes etc.
>
> Re: our application problem, the cons for solutions 2/3 are
> significant so as to prevent them being used in our application.

Note that you probably need to REINDEX the table pg_class if you use too
much temp tables.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La gente vulgar solo piensa en pasar el tiempo;
el que tiene talento, en aprovecharlo"


pgsql-general by date:

Previous
From: "Karen Grose"
Date:
Subject: Re: Non Identifying Foreign Key Relationships
Next
From: Lamar Owen
Date:
Subject: Re: Retrieving database schema