Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55232=pgsql-performance-ar@postgresql.org>)
	id 1dUcSg-0003Bb-Ar
	for pgsql-performance@arkaria.postgresql.org; Mon, 10 Jul 2017 17:27:06 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M55232=pgsql-performance-ar@postgresql.org>)
	id 1dUcSf-00033v-Tg
	for pgsql-performance@arkaria.postgresql.org; Mon, 10 Jul 2017 17:27:05 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <riyav@hotmail.com>)
	id 1dUcQu-00074A-AN
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 17:25:16 +0000
Received: from mwork.nabble.com ([162.253.133.43])
	by makus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <riyav@hotmail.com>)
	id 1dUcQm-0002gc-LK
	for pgsql-performance@postgresql.org; Mon, 10 Jul 2017 17:25:15 +0000
Received: from mben.nabble.com (unknown [162.253.133.72])
	by mwork.nabble.com (Postfix) with ESMTP id 67D0451A0F9F5
	for <pgsql-performance@postgresql.org>; Mon, 10 Jul 2017 10:25:07 -0700 (MST)
Date: Mon, 10 Jul 2017 10:25:07 -0700 (MST)
From: rverghese <riyav@hotmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1499707507430-5970681.post@n3.nabble.com>
Subject: vacuum analyze affecting query performance
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

We are on Postgres 9.5, and have been running a daily vacuum analyze on the
entire database since 8.2 
The data has grown exponentially since, and we are seeing that queries are
now being significantly affected while the vacuum analyze runs. The query
database is a Slony slave. 
So the question is, is this typical behavior and should we still be running
a daily vacuum analyze on the database?

Thanks!
RV



--
View this message in context: http://www.postgresql-archive.org/vacuum-analyze-affecting-query-performance-tp5970681.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance