Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D8C399FB1D6 for ; Tue, 3 Jul 2007 14:21:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 31896-05 for ; Tue, 3 Jul 2007 14:21:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.234]) by postgresql.org (Postfix) with ESMTP id 04F619FB2B9 for ; Tue, 3 Jul 2007 14:21:26 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1095121nzf for ; Tue, 03 Jul 2007 10:21:26 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=D9XU9008RQdcXnICVLYvKhCyDkP1OQUBcNn4CPNiJa9e6IVeseyh7QHkpfTcAYbzJdzgGWkr5YtyKUs2+xh5LXgKB+RBb3Pu+qfEK/lMGvKIRU6+FtGULMXm/7IzDkScfAfww/FYgEDEt3ZbM2khy8KYsdf28EuP5gY6xZ3A9BY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=rKI5kI4OYB84Yt9zphLYe13zpYss+zzREI40N0AW+XAYSUwhVMu/7mQ+br6k/RmZqnqJunzLzZVPpyuML462Q5xzPF37+SQYQ6X+tVNGvAiPfIYxsaKCmQVYL4a0YwuO7VEphimcfOqq4l8XzFkas+hUR5biGGVlnX/bDNucWnY= Received: by 10.143.39.16 with SMTP id r16mr457851wfj.1183483285667; Tue, 03 Jul 2007 10:21:25 -0700 (PDT) Received: by 10.143.30.13 with HTTP; Tue, 3 Jul 2007 10:21:25 -0700 (PDT) Message-ID: <97e6e20f0707031021h1dbee4deld1f87c53e74a7286@mail.gmail.com> Date: Wed, 4 Jul 2007 01:21:25 +0800 From: "Ho Fat Tsang" To: "Greg Smith" Subject: Re: PostgreSQL 8.0 occasionally slow down Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_94005_7479624.1183483285630" 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/16 X-Sequence-Number: 25700 ------=_Part_94005_7479624.1183483285630 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 2007/7/3, Greg Smith : > > 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 > ------=_Part_94005_7479624.1183483285630 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_94005_7479624.1183483285630--