Cabbar Duzayak wrote:
> Hi,
>
> We have huge amount of data, and we are planning to use logical
> partitioning to divide it over multiple machines instances. We are
> planning to use Intel based machines and there is not much updates but
> mostly selects. The main table that constitutes this much of data has
> about 5 columns, and rows are about 50 bytes in size, and 3 columns in
> this table need to be indexed.
>
> So, what I wanted to learn is how much can we push it to the limits on
> a single machine with about 2 gig rams? Do you think PostGres can
> handle ~ 700-800 gigabyte on a single machine? And, is it OK to put
> this much data in a single table, or should we divide it over multiple
> tables? If that is the case, what would be the limit for a single
> table?
>
> Any help/input on this is greatly appreciated.
>
> Thanks.
Yeah, pg can handle that much data. As an example, we have some
databases in that size range on commodity hardware with comparable ram
etc. However, all of the large tables are partitioned into manageable
sizes (daily tables, in this case).