Re: WAL insert delay settings - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: WAL insert delay settings
Date
Msg-id 20190213153129.GU6197@tamriel.snowman.net
Whole thread Raw
In response to WAL insert delay settings  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: WAL insert delay settings  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Greetings,

* Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote:
> Bulk operations like CREATE INDEX, ALTER TABLE, or bulk loads can create
> a lot of WAL.  A lot of WAL at once can cause delays in replication.

Agreed, though I think VACUUM should certainly be included in this.

I'm all for the idea though it seems like a different approach is needed
based on the down-thread discussion.  Ultimately, having a way to have
these activities happen without causing issues for replicas is a great
idea and would definitely address a practical issue that a lot of people
run into.

Thanks!

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Re: libpq compression
Next
From: "Daniel Verite"
Date:
Subject: replace_text optimization (StringInfo to varlena)