From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | "Lee, Mija" <mija(at)scharp(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: out of memory for query, partitioning & vacuuming |
Date: | 2009-07-15 19:18:01 |
Message-ID: | f2fd819a0907151218t56e2cd9cva6f0ad639d8687e8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
What are your work_mem settings ? Work_mem limits the amount of memory used
before using the disk. You may have a large value and a few sessions may end
up using all the available memory.
Read this on work_mem
http://www.postgresql.org/docs/8.3/static/runtime-config-resource.html
On Wed, Jul 15, 2009 at 11:59 AM, Lee, Mija <mija(at)scharp(dot)org> wrote:
> 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.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2009-07-15 20:54:32 | pg_dump dumping out some irrelevant grants |
Previous Message | Scott Marlowe | 2009-07-15 19:16:04 | Re: out of memory for query, partitioning & vacuuming |