Re: Slow Query / Check Point Segments - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Slow Query / Check Point Segments
Date
Msg-id dcc563d11001212149m5ef014b8n13e5614b98560f0@mail.gmail.com
Whole thread Raw
In response to Re: Slow Query / Check Point Segments  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Slow Query / Check Point Segments
Next
From: Yan Cheng Cheok
Date:
Subject: Re: Extremely Slow Cascade Delete Operation