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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: darrenk(at)insightdist(dot)com (Darren King)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [QUESTIONS] Business cases
Date: 1998-01-18 02:56:22
Message-ID: 199801180256.VAA29999@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)candle(dot)pha(dot)pa(dot)us

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-01-18 02:59:43 Re: [HACKERS] S_LOCK() change produces error...
Previous Message The Hermit Hacker 1998-01-18 02:35:52 More on free() bug...