On Thu, 1 Jan 2004, Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
> > I'm still loading the 'WITHOUT OIDS' database ... should I expect that,
> > with CLUSTERing, its performance would be slightly better yet, or would
> > the difference be negligible?
>
> I think the difference will be marginal, but worth doing; you're
> reducing the row size from 40 bytes to 36 if I counted correctly,
> so circa-10% I/O saving, no?
>
> 24 bytes minimum 7.4 HeapTupleHeader
> 4 bytes OID
> 12 bytes three int4 fields
>
> On a machine with 8-byte MAXALIGN, this would not help, but on
> Intel hardware it should.
I take it there is no way of drop'ng OIDs after the fact, eh? :)
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
