Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VXvTU-0004rT-Nk for pgsql-performance@arkaria.postgresql.org; Sun, 20 Oct 2013 16:03:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VXvTT-000244-Tq for pgsql-performance@arkaria.postgresql.org; Sun, 20 Oct 2013 16:03:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VXvTS-00023x-IG for pgsql-performance@postgresql.org; Sun, 20 Oct 2013 16:03:26 +0000 Received: from nm21.bullet.mail.bf1.yahoo.com ([98.139.212.180]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VXvTO-0001bC-2T for pgsql-performance@postgresql.org; Sun, 20 Oct 2013 16:03:25 +0000 Received: from [66.196.81.173] by nm21.bullet.mail.bf1.yahoo.com with NNFMP; 20 Oct 2013 16:03:19 -0000 Received: from [98.139.212.217] by tm19.bullet.mail.bf1.yahoo.com with NNFMP; 20 Oct 2013 16:03:19 -0000 Received: from [127.0.0.1] by omp1026.mail.bf1.yahoo.com with NNFMP; 20 Oct 2013 16:03:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 342156.77578.bm@omp1026.mail.bf1.yahoo.com Received: (qmail 36864 invoked by uid 60001); 20 Oct 2013 16:03:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1382284999; bh=1E9aGqwtwvPrs8B/dTX2MdjZDKlzGFKH+Pwhp0jTkzU=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=f5Bs0ZpFMb5IXK/4vsb3AqiHYU522sWJLVpqhJwyiNNWNJALAB5Wti60iohjNB76quNYwGOFyFkP4PCk7UfoE2A2/2XlAhmbN7aVOiW7B3RQy+J24d2FqHjVnjVYg3MMIGdEymjFd/SrOBu+xR16Ih4FuoXUnovHD/se7lkYICY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=OYD6x3PhHDr4qDC4FLbP4vZuG69H5IzapmkaU9nUrw1XNftvvXgHs6AO0dbSFRJLlq1bOacJ5k0vR1n9h6lEtT9PE7qrhMHexeSvoJTI1kv9lWs2eeFGhbkO53N694/X+z3CEpeYsPQar+PMyrM6knqWlsLOOrQghufN2pi14vo=; X-YMail-OSG: PmrIlbkVM1kWsSwuNSzlz_LAPTD3rTt7TKWbdh74pcu4g9W .wt9IwPa7SWWsByv2j22VMZ5NuxmeYSQRxaOK3HD3adBwxt4QJAKvW.coASI Vh15ENQpDP819rpP2Gs.cIB_1uaPuf.kj8CaRMN4RXff33NLRGeWcSifPs6N 2mb1AEXoxcilk.fgnoaRcGf2sH65GkABqNw185LtnSxO3kBw.zgBrdK_C5ry XZITdH_iri43xVexXAMwHAv7Z4.hSFEQ3ERkrvVc4E3cEXbEwa0N0nouaDOW LZcc4UxtfFlOJuJNE5JPhmr3ruIClERM0KtL5QhQCQqdPtyxh9DQUUa1N5Yi 50rESg7cs7CZO7AzZMHsRQ8e_A_I7aIcdvVCXsIYOR13SbU2nan6Xu1FZqD9 iyQnb1qEI2UBQo7W2hHigz0OgcumbwiTDYJKl.x5GVLbcQWtHmNMfF6LtmDU 9bU8QCkWueYLYfllLWo5x_Q9rSQgIzAWuX9Jy4wAB7NeUHH76m9ISQiALalX 0mEhxGGybJrrfJ0aHA9baj9.AHquVBp9mHrVQ7XFrwJUTEjose6gykQ6g47h l22_yXE3cM4LXVfr4qFf6EPZkZA1ymTSfqkd8i27ldFqzNAHF7jADrulM.x_ OdHARM7VmXHNA2mYujg5O1CqDpWJEBtMQ0Mt7MI0cV6oZ.ByYxaZ109j2Yd1 ifQxkFo0Gi4JM0gGFyYdI13H_9e6HisfEto7zaRfW6sDgL9CiIuY- Received: from [76.255.18.237] by web162904.mail.bf1.yahoo.com via HTTP; Sun, 20 Oct 2013 09:03:19 PDT X-Rocket-MIMEInfo: 002.001, c3BhcmlraCA8c3BhcmlraEBlY290YWxpdHkuY29tPiB3cm90ZToKCj4gUG9zdGdyZVNRTCA5LjEuMQoKWW91IHJlYWxseSBzaG91bGQgYXBwbHkgdGhlIGZpeGVzIGZvciBidWdzIGFuZCBzZWN1cml0eQp2dWxuZXJhYmlsaXRpZXMgd2hpY2ggYXJlIGF2YWlsYWJsZS7CoCBTb21lIG9mIHRob3NlIG1heSBhZGRyZXNzIGEKcmVsZXZhbnQgcGVyZm9ybWFuY2UgcHJvYmxlbS4KCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvc3VwcG9ydC92ZXJzaW9uaW5nLwoKPiB0aGUgcGVyZm9ybWFuY2Ugd2FzIGdvb2QgaW4BMAEBAQE- X-Mailer: YahooMailWebService/0.8.160.587 References: <1381869626548-5774673.post@n5.nabble.com> <5261C20D.1020003@fuzzy.cz> <1382144016561-5775123.post@n5.nabble.com> Message-ID: <1382284999.20481.YahooMailNeo@web162904.mail.bf1.yahoo.com> Date: Sun, 20 Oct 2013 09:03:19 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Hot Standby performance issue To: sparikh , "pgsql-performance@postgresql.org" In-Reply-To: <1382144016561-5775123.post@n5.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org sparikh wrote: > PostgreSQL 9.1.1 You really should apply the fixes for bugs and security vulnerabilities which are available.=A0 Some of those may address a relevant performance problem. http://www.postgresql.org/support/versioning/ > the performance was good in September and somewhere in October it > started slowing down. I guess it was gradual. There were no code > change in the application or major change in the data volume. We really need to see your configuration, along with a description of the machine.=A0 One common cause for such a slowdown is not having autovacuum configured to be aggressive enough.=A0 Another possible cause is a transaction which has been left open for too long.=A0 Look at pg_stat_activity and pg_prepared_xacts for xact_start or prepared more than an hour old. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance