Home > mailing lists

Re: monitoring CREATE INDEX [CONCURRENTLY] - Mailing list pgsql-hackers

From	Simon Riggs
Subject	Re: monitoring CREATE INDEX [CONCURRENTLY]
Date	February 13, 2019 05:59:27
Msg-id	CANP8+jJ9e4fv3NUcVgbgME6VhmSZLf42a8MD9yNCJNnNcXZe6w@mail.gmail.com Whole thread Raw
In response to	Re: monitoring CREATE INDEX [CONCURRENTLY] (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses	Re: monitoring CREATE INDEX [CONCURRENTLY]
List	pgsql-hackers

On Wed, 13 Feb 2019 at 00:46, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

Here's a sample
concurrent index build on a 100M tuple table.

Cool

There are no concurrent
transactions, so phases that wait for lockers don't appear.

Would prefer to see them, so we know they are zero.

Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

From: Shawn Debnath
Date: 13 February 2019, 05:58:43
Subject: Re: Refactoring the checkpointer's fsync request queue

From: "Jonathan S. Katz"
Date: 13 February 2019, 06:00:15
Subject: 2019-02-14 Press Release Draft