Re: Index Unqiueness

On Fri, Mar 8, 2013 at 10:26:21AM -0500, Robert Haas wrote:
> overhead seems badly overpriced for insert-only tables. These are not
> fundamental truths of the universe, or even of PostgreSQL; they are
> specific consequences of the representation we've chosen for heaps.
> Many of them are things that we've grown into, rather than designed
> with malice aforethought: for example, freezing is a consequence of
> the after-the-fact desire to be able to support more than 4bn
> transactions over the lifetime of the database. So it's way better
> than what we had before, and yet, if we all sat down and designed a
> new on-disk storage format for a new product today, I'm sure none of
> us would pick one that expires after 2bn transactions.

One thing to remember is that our freeze level is 200M transactions
because of clog lookups/size, not wraparound concerns.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +