| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Andrew Bartley <abartley(at)evolvosystems(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 4 billion + oids |
| Date: | 2003-03-25 02:32:41 |
| Message-ID: | 20030325023241.GB6247@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2003-03-25 03:02:48 | Re: Retrieving database schema |
| Previous Message | Karen Grose | 2003-03-25 01:29:28 | Re: Non Identifying Foreign Key Relationships |