Skip site navigation (1) Skip section navigation (2)

RE: [HACKERS] What I'm working on

From: "Stupor Genius" <stuporg(at)erols(dot)com>
To: "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [HACKERS] What I'm working on
Date: 1998-08-24 03:01:08
Message-ID: 000401bdcf0b$70fc1340$9b98accf@darren (view raw or flat)
Thread:
Lists: pgsql-hackers
> 	There *has* to be some overhead, performance wise, in the database
> having to keep track of row-spanning, and being able to reduce that, IMHO,
> is what I see being able to change the blocksize as doing...

If both features were present, I would say to increase the blocksize of
the db to the max possible.  This would reduce the number of tuples that
are spanned.  Each span would require another tuple fetch, so that could
get expensive with each successive span or if every tuple spanned.

But if we stick with 8k blocksizes, people with tuples between 8 and 16k
would get absolutely killed performance-wise.  Would make sense for them
to go to 16k blocks where the reading of the extra bytes per block would
be minimal, if anything, compared to the fetching/processing of the next
span(s) to assemble the whole tuple.

In summary, the capability to span would be the next resort after someone
has maxed out their blocksize.  Each OS would have a different blocksize
max...an AIX driver breaks when going past 16k...don't know about others.

I'd say make the blocksize a run-time variable and then do the spanning.

Darren


In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-08-24 03:13:52
Subject: Re: [HACKERS] What I'm working on
Previous:From: The Hermit HackerDate: 1998-08-24 02:34:19
Subject: Re: [HACKERS] What I'm working on

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group