Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 4E955424B for ; Thu, 22 Mar 2012 21:48:04 -0300 (ADT) Received: from cl-174.chi-02.us.sixxs.net ([2001:4978:f:ad::2] helo=tamriel.snowman.net) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SAsfi-0005QW-2B for pgsql-performance@postgresql.org; Fri, 23 Mar 2012 00:48:03 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 4EE18229CE; Thu, 22 Mar 2012 20:47:49 -0400 (EDT) Date: Thu, 22 Mar 2012 20:47:49 -0400 From: Stephen Frost To: Sebastian Melchior Cc: pgsql-performance@postgresql.org Subject: Re: Sudden Query slowdown on our Postgresql Server Message-ID: <20120323004749.GG3938@tamriel.snowman.net> References: <03615FD7-20B3-49AB-AC5E-484544D03933@mailz.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="DvpQYQy10PodzGf7" Content-Disposition: inline In-Reply-To: <03615FD7-20B3-49AB-AC5E-484544D03933@mailz.de> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.2.0-1-amd64 (x86_64) X-Uptime: 20:46:59 up 25 days, 6:52, 5 users, load average: 0.01, 0.04, 0.05 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/152 X-Sequence-Number: 46602 --DvpQYQy10PodzGf7 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Sebastian Melchior (webmaster@mailz.de) wrote: > Does anyone have any idea what could cause this issue or how we can further debug it? Are you logging checkpoints? If not, you should, if so, then see if they correllate to the time of the slowdown..? Thanks, Stephen --DvpQYQy10PodzGf7 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9ryDUACgkQrzgMPqB3kigLRgCfWra1Euu8J0JEOt+rHKT+x4Mg 7DgAnAjcBUsEjfJD7lZi+zHs/gboBTjz =gUO5 -----END PGP SIGNATURE----- --DvpQYQy10PodzGf7--