From: | "Lee, Mija" <mija(at)scharp(dot)org> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | out of memory for query, partitioning & vacuuming |
Date: | 2009-07-15 18:59:23 |
Message-ID: | 5D1219ADBE9E6C4CA6F0F89C811C102F03497C6B@ISIS.fhcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi -
I'm not a particularly experienced dba, so I'm hoping this isn't a
ridiculous question.
I have a 5 GB table with lots of churn in a 14 GB database. Querying
this one table without limits has just started throwing "out of memory
for query" from multiple clients (psql, java). I'm working with the
developers to look at it from the client side, but I'm wondering if
either partitioning the table or more aggressive vacuuming of this table
would have an effect on the out of memory problem.
I'm running 8.3.5 on solaris 10.
Thanks!
Mija
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential, proprietary, and/or privileged information protected by
law. If you are not the intended recipient, you may not use, copy, or
distribute this e-mail message or its attachments. If you believe you
have received this e-mail message in error, please contact the sender by
reply e-mail and destroy all copies of the original message.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-07-15 19:16:04 | Re: out of memory for query, partitioning & vacuuming |
Previous Message | Chander Ganesan | 2009-07-15 18:22:32 | Re: Old version? |