public inbox for [email protected]  

help / color / mirror / Atom feed

From: rverghese <[email protected]>
To: [email protected]
Subject: vacuum analyze affecting query performance
Date: Mon, 10 Jul 2017 10:25:07 -0700 (MST)
Message-ID: <[email protected]> (raw)
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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 using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: vacuum analyze affecting query performance
  In-Reply-To: <[email protected]>

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

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