Re: Postgres Query Plan Live Lock

From: bricklen <bricklen(at)gmail(dot)com>
To: "Pweaver (Paul Weaver)" <pweaver(at)panjiva(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org>, Michael Vezza <michael(at)panjiva(dot)com>
Subject: Re: Postgres Query Plan Live Lock
Date: 2014-02-05 16:39:45
Message-ID: CAGrpgQ-RrBaCGgAXQ1gHGmg9mHp7LW5VJ4L6jM8Sba1ubj5COg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Feb 3, 2014 at 1:35 PM, Pweaver (Paul Weaver)
<pweaver(at)panjiva(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pweaver (Paul Weaver) 2014-02-05 19:36:47 Re: Postgres Query Plan Live Lock
Previous Message Claudio Freire 2014-02-05 15:28:39 Re: increasing query time after analyze