max table size

[Alan Carbutt]

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
ar******@adams. edu

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQBARKE680x gawKGzrMRAkKjAJ wPMlCG8rLy4RK8w cRIeuCl6wUAAQCf YLiz
9ZLWrIzUKBmiDDg GbwP/yLY=
=GJIj
-----END PGP SIGNATURE-----

[Bruno Wolff III]

On Tue, Mar 02, 2004 at 07:59:07 -0700,
Alan Carbutt <ar******@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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Paulovi� Michal]

Oficial answer in FAQ:
http://www.postgresql.org/docs/faqs/FAQ.html#4.6

Alan Carbutt 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.

Thanks,

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Paulovi� Michal]

sorry wrong link at erlier response.
here is correct
http://www.postgresql.org/docs/faqs/FAQ.html#4.5

Alan Carbutt 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.

Thanks,

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match