Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zbz2W-0003r2-QY for pgsql-performance@arkaria.postgresql.org; Tue, 15 Sep 2015 22:49:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zbz2W-0001kK-BM for pgsql-performance@arkaria.postgresql.org; Tue, 15 Sep 2015 22:49:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZZcqK-0001Dq-V7 for pgsql-performance@postgresql.org; Wed, 09 Sep 2015 10:43:09 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZZcqG-0004vx-HX for pgsql-performance@postgresql.org; Wed, 09 Sep 2015 10:43:07 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id D7BA915155D5 for ; Wed, 9 Sep 2015 03:39:03 -0700 (PDT) Date: Wed, 9 Sep 2015 03:43:01 -0700 (MST) From: anil7385 To: pgsql-performance@postgresql.org Message-ID: <1441795381877-5865303.post@n5.nabble.com> Subject: VACUUM VERBOSE ANALYZE taking long time to process. MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.1 (/) 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 Hi, We have a table which consists of 3 millions of records and when we try to delete them and run VACUUM VERBOSE ANALYZE on it in production environment , it takes 6/7 hours to process. our understanding is that ,there are other processes running in the prod environment which may acquire lock on this table and due to this vacuum keeps waiting continuously for getting lock and due to this it takes long time to finish . can any body suggest me a solution by which we can reduce the time to 1 to 2 hours ? please reply me on this with your suggestions . -- View this message in context: http://postgresql.nabble.com/VACUUM-VERBOSE-ANALYZE-taking-long-time-to-process-tp5865303.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