max table size
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and the search isn't
working.
Thanks,
--
Alan Carbutt
Systems Administrator/Programmer
Adams State College
719-587-7741
arcarbut@adams.edu
On Tue, Mar 02, 2004 at 07:59:07 -0700,
Alan Carbutt <arcarbut@adams.edu> wrote:
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and the search isn't
working.
The limit on columns is between 250 and 1600 depending on data types in
recent versions of Postgres. I think that rows are only limited by the amount
of disc space available.
Oficial answer in FAQ:
http://www.postgresql.org/docs/faqs/FAQ.html#4.6
Alan Carbutt wrote:
Show quoted text
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and the search isn't
working.Thanks,
sorry wrong link at erlier response.
here is correct
http://www.postgresql.org/docs/faqs/FAQ.html#4.5
Alan Carbutt wrote:
Show quoted text
Hi all,
I'm running a data warehouse in Postgres and I was wondering what the
max table size is column-wise and row-wise. I tried to search the lists
and documentation on the http://www.postgresql.org and the search isn't
working.Thanks,