From: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
---|---|
To: | <cedric(at)2ndquadrant(dot)com>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "'Fujii Masao'" <masao(dot)fujii(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>, "'Robert Haas'" <robertmhaas(at)gmail(dot)com>, "'Greg Smith'" <greg(at)2ndquadrant(dot)com>, "'Josh Berkus'" <josh(at)agliodbs(dot)com>, "'Magnus Hagander'" <magnus(at)hagander(dot)net>, "'Christopher Browne'" <cbbrowne(at)gmail(dot)com> |
Subject: | Re: Proposal for Allow postgresql.conf values to be changed via SQL |
Date: | 2012-11-19 07:04:27 |
Message-ID: | 007e01cdc624$1e2a66b0$5a7f3410$@kapila@huawei.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sunday, November 18, 2012 3:22 PM Cédric Villemain wrote:
> Le samedi 17 novembre 2012 22:57:49, Tom Lane a écrit :
> > Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> > > Do we really need to store the settings in a system table?
> > > Since WAL would be generated when storing the settings in a system
> > > table, this approach seems to prevent us from changing the settings
> > > in the standby.
> >
> > That's a really good point: if we try to move all GUCs into a system
> > table, there's no way for a standby to have different values; and for
> > some of them different values are *necessary*.
> >
> > I think that shoots down this line of thought entirely. Can we go
> > back to the plain "write a file" approach now? I think a "SET
> > PERSISTENT" command that's disallowed in transaction blocks and just
> > writes the file immediately is perfectly sensible.
>
> I was justifying the usage of a table structure, not to keep it in sync
> (just use it to hide the complexity of locks).
>
> Anyway that was just comments.
Thanks.
You comments are thought provoking. I was able to proceed for table
related approach based on your suggestions.
With Regards,
Amit Kapila.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2012-11-19 07:28:55 | Re: logical changeset generation v3 |
Previous Message | Amit Kapila | 2012-11-19 07:01:00 | Re: Proposal for Allow postgresql.conf values to be changed via SQL |