Re: Hot Standby Feedback should default to on in 9.3+

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Claudio Freire" <klaussfreire(at)gmail(dot)com>,"Heikki Linnakangas" <hlinnakangas(at)vmware(dot)com>
Cc: "Andres Freund" <andres(at)2ndquadrant(dot)com>,"PostgreSQL-Dev" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hot Standby Feedback should default to on in 9.3+
Date: 2012-11-30 21:06:10
Message-ID: 20121130210610.69290@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Claudio Freire wrote:

> Without hot standby feedback, reporting queries are impossible.
> I've experienced it. Cancellations make it impossible to finish
> any decently complex reporting query.

With what setting of max_standby_streaming_delay? I would rather
default that to -1 than default hot_standby_feedback on. That way
what you do on the standby only affects the standby.

A default that allows anyone who has a read-only login to a standby
to bloat the server by default, which may require hours of down
time to correct, seems dangerous to me.

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Claudio Freire 2012-11-30 21:07:38 Re: Hot Standby Feedback should default to on in 9.3+
Previous Message Heikki Linnakangas 2012-11-30 21:03:36 Re: Hot Standby Feedback should default to on in 9.3+