Thread: Re: [HACKERS] Re: [QUESTIONS] Business cases

Re: [HACKERS] Re: [QUESTIONS] Business cases

From
darrenk@insightdist.com (Darren King)
Date:
> >   Also, how are people handling tables with lots of rows?  The 8k tuple
> > size can waste a lot of space.  I need to be able to handle a 2 million
> > row table, which will eat up 16GB, plus more for indexes.
>

16GB?!?  Not unless your tuples are 8k.  The 8k is/was the max _tuple_ size,
but more than one tuple can be stored per block. :)

Try the formula in the FAQ to get a reasonable estimate for the table's size.

>     This oen is improved upon in v6.3, where at compile time you can stipulate
> the tuple size.  We are looking into making this an 'initdb' option instead,
> so that you can have the same binary for multiple "servers", but any database
> created under a particular server will be constrained by that tuple size.

If the patch I sent to PATCHES is applied, then it will be a compile-time setting
and you'll need a postmaster for each database w/differing block sizes.  Not the
greatest solution, but it would work.

I almost have the "-k" option working today. Two files left to do...

backend/access/nbtree/nbtsort.c
backend/utils/adt/chunk.c

I'm being careful about pfree'ing all the stuff that I'm going to have to palloc.

Tiggers definitely do _not_ like memory leaks.

darrenk

Re: [HACKERS] Re: [QUESTIONS] Business cases

From
Tom
Date:
On Sat, 17 Jan 1998, Darren King wrote:

> 16GB?!?  Not unless your tuples are 8k.  The 8k is/was the max _tuple_ size,
> but more than one tuple can be stored per block. :)
>
> Try the formula in the FAQ to get a reasonable estimate for the table's size.

  The sentence "Tuples do not cross 8k boundaries so a 5k tuple will
require 8k of storage" in 3.8 of the FAQ confused me.  I did not realize
that multiple tuples could be stored in a page.  So I took it to mean
that one tuple was stored in page.  I didn't even even see 3.26, because I
thought that 3.8 answered my question :(

Tom


Re: [HACKERS] Re: [QUESTIONS] Business cases

From
Bruce Momjian
Date:
>
> > >   Also, how are people handling tables with lots of rows?  The 8k tuple
> > > size can waste a lot of space.  I need to be able to handle a 2 million
> > > row table, which will eat up 16GB, plus more for indexes.
> >
>
> 16GB?!?  Not unless your tuples are 8k.  The 8k is/was the max _tuple_ size,
> but more than one tuple can be stored per block. :)
>
> Try the formula in the FAQ to get a reasonable estimate for the table's size.
>

The FAQ copy on the web page has it.  The FAQ in the 6.2.1 distribution
does not.

--
Bruce Momjian
maillist@candle.pha.pa.us