Re: [HACKERS] tcp_keepalives_idle

2013-11-13 Thread Tom Lane
Tatsuo Ishii writes: > I am struggling to understand what following phrase says: > tcp_keepalives_idle (integer) > Specifies the number of seconds before sending a keepalive packet > on an otherwise idle connection. It means "the connection is idle except for keepalive packets". We could

[HACKERS] Logging WAL when updating hintbit

2013-11-13 Thread Sawada Masahiko
Hi all, I attached patch adds new wal_level 'all'. If wal_level is set 'all', the server logs WAL not only when wal_level is set 'hot_standby' ,but also when updating hint bit. That is, we will be able to know all of the changed block number by reading the WALs. This wal_level is infrastructure fo

Re: [HACKERS] tcp_keepalives_idle

2013-11-13 Thread Tatsuo Ishii
> Tatsuo Ishii writes: >> I am struggling to understand what following phrase says: > >> tcp_keepalives_idle (integer) >> Specifies the number of seconds before sending a keepalive packet >> on an otherwise idle connection. > > It means "the connection is idle except for keepalive packet

Re: [HACKERS] Proof of concept: standalone backend with full FE/BE protocol

2013-11-13 Thread Amit Kapila
I have gone through the mail chain of this thread and tried to find the different concerns or open ends for this patch. Summarisation of the discussion and concerns for this patch: 1. Security concern in interface 2. Security concern in Windows implementation 3. Handling of Ctrl-C/SIGTERM 4. Seco

Re: [HACKERS] Proof of concept: standalone backend with full FE/BE protocol

2013-11-13 Thread Tom Lane
Amit Kapila writes: > Any objections for adding this idea/patch to CF? You should certainly add it to the CF. You've listed lots of matters for review, but that's no reason to not get it in the queue to be reviewed. regards, tom lane -- Sent via pgsql-hackers mailing

Re: [HACKERS] Logging WAL when updating hintbit

2013-11-13 Thread Michael Paquier
On Thu, Nov 14, 2013 at 3:02 PM, Sawada Masahiko wrote: > I attached patch adds new wal_level 'all'. > If wal_level is set 'all', the server logs WAL not only when wal_level > is set 'hot_standby' ,but also when updating hint bit. > That is, we will be able to know all of the changed block number

[HACKERS] Small improvement to json out functions by using cstring_to_text_with_len instead of cstring_to_text

2013-11-13 Thread David Rowley
Hi, Here's a small patch which should speedup json out functions a little bit by removing a call to strlen for which could be a long string. The length of the string is already known by the StringInfoData, so there's no point in letting cstring_to_text() loop over the whole string again. Regards

Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: [HACKERS] Proposal for Allow postgresql.conf values to be changed via SQL [review])

2013-11-13 Thread Amit Kapila
On Wed, Nov 13, 2013 at 7:23 PM, Amit Kapila wrote: > On Wed, Nov 13, 2013 at 4:05 PM, Haribabu kommi > wrote: >> On 01 October 2013 00:56 Amit Kapila wrote: >>> On Mon, Sep 30, 2013 at 9:07 PM, Peter Eisentraut >>> wrote: >>> > On 9/28/13 3:05 AM, Amit Kapila wrote: >>> >> Now as we have an agr

<    1   2