Re: Billions of records?

On Tuesday 15 July 2003 20:01, John Bercik wrote:
> Thanks for the reply.  So given my conditions, how many records can PG
> hold?  I got the 16TB from the limitations page but I don't see how to
> calculate how many records I can hold.

OK. Let's calculate. You have 50 fields of 20 char each. So each field would
go for 24 bytes at least assuming a 4 byte integer for length.

So a tuple size is 50*24+28=1228 bytes. So in a page of 8KB, you would get 6
tuples.

In 16TB you can accomodate, 2GB pages. So you can accomodate around 12 billion
tuples for your table schema.

If you get true char types, that would accomodate  7 tuples per page. So you
could get around 14 billion tuples in there.

HTH

BTW How much data you actually have?

 Shridhar