Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2004-01-02T03:37:43Z
Lists: pgsql-general 
"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.

			regards, tom lane