Re: Mnogosearch (Was: Re: website doc search is ... )

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