Skip site navigation (1) Skip section navigation (2)

Re: Very long deletion time on a 200 GB database

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 (view raw or flat)
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

In response to

Responses

pgsql-performance by date

Next:From: Claudio FreireDate: 2012-02-24 13:07:00
Subject: Re: Very long deletion time on a 200 GB database
Previous:From: Samuel GendlerDate: 2012-02-24 08:22:21
Subject: Re: Very long deletion time on a 200 GB database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group