Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Query Plan Live Lock - Mailing list pgsql-performance

From bricklen
Subject Re: Postgres Query Plan Live Lock
Date
Msg-id CAGrpgQ-RrBaCGgAXQ1gHGmg9mHp7LW5VJ4L6jM8Sba1ubj5COg@mail.gmail.com
Whole thread Raw
In response to Postgres Query Plan Live Lock  ("Pweaver (Paul Weaver)" <pweaver@panjiva.com>)
List pgsql-performance
Tree view
On Mon, Feb 3, 2014 at 1:35 PM, Pweaver (Paul Weaver) <pweaver@panjiva.com> wrote:

table_name stats:
~ 400,000,000 rows
We are deleting 10,000,000s of rows in 100,000 row increments over a few days time prior/during this slowdown.

If you issue "VACUUM" or "VACUUM ANALYZE" after each DELETE, do the SELECTs become more responsive?

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: increasing query time after analyze
Next
From: "Pweaver (Paul Weaver)"
Date:
Subject: Re: Postgres Query Plan Live Lock