| From: | "Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Expectations of MEM requirements for a DB with large tables. |
| Date: | 2000-11-06 05:17:52 |
| Message-ID: | 000801c047b0$ea12ca10$aa00a8c0@ncc1701e |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello to all,
I am new to the PostgreSQL world, as well as the Linux world... kind of a
double whammy...
Anyway, I crashed my system the other day when I did a "select *" from one
of my large tables (about 5.5gb in size). Now this is not something that
will normally happen, as I would normally have some criteria to reduce the
output size, but it got me thinking...
Does anyone know what the ratio of data output size (say from a select) to
the amount of
RAM used is?
Hopefully the answer is not 1 to 1... as I would need to buy ALOT of RAM...
Other relevant info, RedHat Linux 2.2.17 kernel, PostgreSQL 7.0.2.
Thank you in advance for any and all help.
Note: I posted this to "Admin" also, but I'm not quite sure if it's really a
"installation" question, so I'm posting it here also.
-Michael Miyabara-McCaskey
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Guenter | 2000-11-06 05:34:19 | Re: Expectations of MEM requirements for a DB with large tables. |
| Previous Message | Peter Eisentraut | 2000-11-05 22:22:30 | Re: PG and login |