From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Adrian 'Dagurashibanipal' von Bidder" <avbidder(at)fortytwo(dot)ch> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: OIDs (Or: another RTFM question?) |
Date: | 2002-07-16 16:12:09 |
Message-ID: | 200207161612.g6GGC9p29764@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian 'Dagurashibanipal' von Bidder wrote:
Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
> Yo!
>
> Browsing through the online docs, I see the special columns documented
> in http://www.postgresql.org/idocs/index.php?sql-syntax-columns.html .
>
> But I'm missing discussion about significance of the oids - something
> along the lines of 'Creating tables WITHOUT OIDS does *not* safe any
> disk space, but does <give you what?> at the expense of <what? being not
> backward compatible, I guess>.'
Yes, WITHOUT OIDs just prevents the oid counter from incrementing as
quickly and perhaps rolling over. In 7.3 I think WITHOUT OID may save
storage so I am going to avoid documenting it at this point.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-07-16 16:13:07 | Re: brk() function and performance |
Previous Message | Tom Lane | 2002-07-16 16:09:45 | Re: Backend died abnormally - postgresql 7.2.1-5 |