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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Re: [QUESTIONS] Business cases
Дата
Msg-id 199801180256.VAA29999@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: [QUESTIONS] Business cases  (darrenk@insightdist.com (Darren King))
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] S_LOCK() change produces error...
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] S_LOCK() change produces error...