Re: Slow Query / Check Point Segments

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alex - <aintokyo(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow Query / Check Point Segments
Date: 2010-01-22 05:49:09
Message-ID: dcc563d11001212149m5ef014b8n13e5614b98560f0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh yeah, what's your swappiness setting (assuming you're running some
flavor of linux:

sysctl -a|grep swapp

should tell you. I set it to something small like 5 or so on db
servers. Default of 60 is fine for an interactive desktop but usually
too high for a server.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-01-22 06:16:06 Re: Extremely Slow Cascade Delete Operation
Previous Message Scott Marlowe 2010-01-22 05:46:50 Re: Slow Query / Check Point Segments