| From: | "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il> |
|---|---|
| To: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
| Cc: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Very long deletion time on a 200 GB database |
| Date: | 2012-02-24 12:37:30 |
| Message-ID: | 4F47848A.20800@lerner.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, everyone. Samuel wrote:
>
> What is work_mem set to? If all the other values were set so low, I'd
> expect work_mem to also be small, which could be causing all kind of
> disk activity when steps don't fit into a work_mem segment.
I just checked, and work_mem is set to 30 MB. That seems a bit low to
me, given the size of the database and the fact that we're doing so much
sorting and subselecting. Am I right that we should push that up some more?
Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2012-02-24 13:07:00 | Re: Very long deletion time on a 200 GB database |
| Previous Message | Samuel Gendler | 2012-02-24 08:22:21 | Re: Very long deletion time on a 200 GB database |