Re: [HACKERS] Re: [QUESTIONS] Business cases
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: darrenk@insightdist.com (Darren King)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-01-18T02:56:22Z
Lists: pgsql-hackers
> > > > 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