pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ho Fat Tsang <namiwf@gmail.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 8.0 occasionally slow down
Date: Wed, 4 Jul 2007 01:21:25 +0800
Message-ID: <97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0707021819410.11762@westnet.com>
References: <97e6e20f0706272354m5e42c91em177c8b80abb2ea52@mail.gmail.com>
	<468361A9.1040308@archonet.com>
	<97e6e20f0706280101y543b871ao4cbf85e57f07f7e9@mail.gmail.com>
	<46836B66.7050109@archonet.com>
	<97e6e20f0706280117h20ab2e03n770abc588f17742@mail.gmail.com>
	<46837C50.20603@archonet.com>
	<97e6e20f0706281904v4b7c4a97p570deda85e590ee4@mail.gmail.com>
	<Pine.GSO.4.64.0707021819410.11762@westnet.com>

2007/7/3, Greg Smith <gsmith@gregsmith.com>:
>
> On Fri, 29 Jun 2007, Ho Fat Tsang wrote:
>
> > I noticed that for each time the pgsql slow down, there is a short
> > period a process called "pdflush" eating up lot of I/O. I've goolgled
> > and know it is a process for writing dirty pages back to the disk by the
> > Linux kernel.
>
> The pdflush documentation is really spread out, you may find my paper at
> http://www.westnet.com/~gsmith/content/linux-pdflush.htm a good place to
> start looking into that.


When i found the "pdflush" process is the major clue of PG slow down, i
googled and found this article !
it is a really good one for tuning pdflush ! Thank a lot !

--
> * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>

view thread (18+ messages)

Message-ID: <97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com>
Permalink:  ../97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com/
Also on:    postgresql.org/message-id/97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: namiwf@gmail.com, gsmith@gregsmith.com
  Subject: Re: PostgreSQL 8.0 occasionally slow down
  In-Reply-To: <97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com>
  References: <97e6e20f0706272354m5e42c91em177c8b80abb2ea52@mail.gmail.com> <468361A9.1040308@archonet.com> <97e6e20f0706280101y543b871ao4cbf85e57f07f7e9@mail.gmail.com> <46836B66.7050109@archonet.com> <97e6e20f0706280117h20ab2e03n770abc588f17742@mail.gmail.com> <46837C50.20603@archonet.com> <97e6e20f0706281904v4b7c4a97p570deda85e590ee4@mail.gmail.com> <Pine.GSO.4.64.0707021819410.11762@westnet.com> <97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox