Re: [HACKERS] 9.3 release notes suggestions

2013-08-19 Thread 'Bruce Momjian'
On Mon, Aug 19, 2013 at 01:38:13PM +0900, Etsuro Fujita wrote: > > From: 'Bruce Momjian' [mailto:br...@momjian.us] > > > On Tue, Aug 13, 2013 at 05:59:05PM +0900, Etsuro Fujita wrote: > > > > Thanks for the many suggestions on improving the 9.3 release notes. > > > > There were many ideas I would

Re: [HACKERS] 9.3 release notes suggestions

2013-08-18 Thread Etsuro Fujita
> From: 'Bruce Momjian' [mailto:br...@momjian.us] > On Tue, Aug 13, 2013 at 05:59:05PM +0900, Etsuro Fujita wrote: > > > Thanks for the many suggestions on improving the 9.3 release notes. > > > There were many ideas I would have never thought of. Please keep > > > the > > suggestions > > > comin

Re: [HACKERS] 9.3 release notes suggestions

2013-08-13 Thread 'Bruce Momjian'
On Tue, Aug 13, 2013 at 05:59:05PM +0900, Etsuro Fujita wrote: > > Thanks for the many suggestions on improving the 9.3 release notes. > > There were many ideas I would have never thought of. Please keep the > suggestions > > coming. > > One small suggestion: > > > > Allow

Re: [HACKERS] 9.3 release notes suggestions

2013-08-13 Thread Etsuro Fujita
> Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the suggestions > coming. One small suggestion: Allow foreign data wrappers to support writes (inserts/updates/deletes) on forei

Re: [HACKERS] 9.3 release notes suggestions

2013-05-06 Thread Bruce Momjian
On Mon, May 6, 2013 at 06:23:07PM +0300, Heikki Linnakangas wrote: > On 05.05.2013 18:51, Andrew Dunstan wrote: > > > >On 05/05/2013 01:35 AM, Tom Lane wrote: > >>Bruce Momjian writes: > >>>OK, so we can either use 4 hex digits minimum and have a fixed with on > >>>most platforms, extend it to 8

Re: [HACKERS] 9.3 release notes suggestions

2013-05-06 Thread Heikki Linnakangas
On 05.05.2013 18:51, Andrew Dunstan wrote: On 05/05/2013 01:35 AM, Tom Lane wrote: Bruce Momjian writes: OK, so we can either use 4 hex digits minimum and have a fixed with on most platforms, extend it to 8 hex digits, or revert the entire fixed-width idea. I think we should lose the idea th

Re: [HACKERS] 9.3 release notes suggestions

2013-05-06 Thread Bruce Momjian
On Mon, May 6, 2013 at 06:54:06AM -0400, Robert Haas wrote: > On May 5, 2013, at 11:51 AM, Andrew Dunstan wrote: > > I can't off the top of my head see any good reason for zero padding, so I'm > > with Tom. > > Same here. Agreed, reverted. -- Bruce Momjian http://momjian.us Ente

Re: [HACKERS] 9.3 release notes suggestions

2013-05-06 Thread Robert Haas
On May 5, 2013, at 11:51 AM, Andrew Dunstan wrote: > I can't off the top of my head see any good reason for zero padding, so I'm > with Tom. Same here. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.o

Re: [HACKERS] 9.3 release notes suggestions

2013-05-05 Thread Andrew Dunstan
On 05/05/2013 01:35 AM, Tom Lane wrote: Bruce Momjian writes: OK, so we can either use 4 hex digits minimum and have a fixed with on most platforms, extend it to 8 hex digits, or revert the entire fixed-width idea. I think we should lose the idea that it's fixed-width. 16-bit PIDs are a limi

Re: [HACKERS] 9.3 release notes suggestions

2013-05-05 Thread Gavin Flower
On 05/05/13 17:35, Tom Lane wrote: Bruce Momjian writes: OK, so we can either use 4 hex digits minimum and have a fixed with on most platforms, extend it to 8 hex digits, or revert the entire fixed-width idea. I think we should lose the idea that it's fixed-width. 16-bit PIDs are a limitation

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Tom Lane
Bruce Momjian writes: > OK, so we can either use 4 hex digits minimum and have a fixed with on > most platforms, extend it to 8 hex digits, or revert the entire > fixed-width idea. I think we should lose the idea that it's fixed-width. 16-bit PIDs are a limitation whose days are obviously number

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 10:01:18PM -0400, Noah Misch wrote: > On Sat, May 04, 2013 at 01:17:44PM -0400, Bruce Momjian wrote: > > On Sun, May 5, 2013 at 01:21:12AM +0900, Ian Lawrence Barwick wrote: > > > > Well, basically, if you used %c in log_line_prefix, the session id was > > > > not a fixed l

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Noah Misch
On Sat, May 04, 2013 at 01:17:44PM -0400, Bruce Momjian wrote: > On Sun, May 5, 2013 at 01:21:12AM +0900, Ian Lawrence Barwick wrote: > > > Well, basically, if you used %c in log_line_prefix, the session id was > > > not a fixed length, so your output shifted around based on the pid, see: > > > >

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 07:59:40PM +0200, Tomas Vondra wrote: > On 24.4.2013 05:41, Bruce Momjian wrote: > > Thanks for the many suggestions on improving the 9.3 release notes. > > There were many ideas I would have never thought of. Please keep the > > suggestions coming. > > Lovely, good job Br

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Tomas Vondra
On 24.4.2013 05:41, Bruce Momjian wrote: > Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the > suggestions coming. Lovely, good job Bruce! I've checked descriptions of changes I've been working on, and I thi

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Tomas Vondra
On 24.4.2013 05:41, Bruce Momjian wrote: > Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the > suggestions coming. Lovely, good job Bruce! I've checked descriptions of changes I've been working on, and I thi

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 01:17:44PM -0400, Bruce Momjian wrote: > Yes, I see it is wrong now. I came up with this new query: > > SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || > regexp_replace('' || to_hex(pid), '^0*(.*)$', '\1') > FROM pg_stat_

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sun, May 5, 2013 at 01:21:12AM +0900, Ian Lawrence Barwick wrote: > > Well, basically, if you used %c in log_line_prefix, the session id was > > not a fixed length, so your output shifted around based on the pid, see: > > > > > > http://www.postgresql.org/message-id/20121012185127.gb31

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Ian Lawrence Barwick
2013/5/5 Bruce Momjian : (...) >> > This is such a minor change I am trying to keep it short. >> >> Just out of curiosity, what was the reason for the change in the first place? >> (Not that it's something I'm particularly passionate about, I just noticed it >> when listing changes with potential b

Re: [HACKERS] 9.3 release notes suggestions (typo)

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 05:12:31PM +0200, Erik Rijkers wrote: > Plural to singular: > > s/Allow a streaming replication standbys to/Allow a streaming replication > standby to/ > > > Perhaps this one too? (not sure, 'tooling' just seems strange to my > non-native reading)) > > s/Allow tool

Re: [HACKERS] 9.3 release notes suggestions (typo)

2013-05-04 Thread Erik Rijkers
Plural to singular: s/Allow a streaming replication standbys to/Allow a streaming replication standby to/ Perhaps this one too? (not sure, 'tooling' just seems strange to my non-native reading)) s/Allow tooling like pg_receivexlog to run/Allow tools like pg_receivexlog to run/ thanks,

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 11:55:09PM +0900, Ian Lawrence Barwick wrote: > >> more pedantically > >> accurate: > >> > >> > >> > >> Have session id (%c) in >> linkend="guc-log-line-prefix">log_line_prefix > >> always pad the PID value with zeros so at least four

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Ian Lawrence Barwick
2013/5/4 Bruce Momjian : > On Sat, May 4, 2013 at 08:34:18PM +0900, Ian Lawrence Barwick wrote: >> 2013/4/24 Bruce Momjian : >> > Thanks for the many suggestions on improving the 9.3 release notes. >> > There were many ideas I would have never thought of. Please keep the >> > suggestions coming.

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 03:50:34PM +0300, Marti Raudsepp wrote: > 2. "Dramatically reduce System V shared memory usage" > > I find this description misleading. When reading for the first time, > it sounds as if Postgres memory usage is reduced, but it's actually > just using different kind of shar

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 03:50:34PM +0300, Marti Raudsepp wrote: > Hi! > > On Wed, Apr 24, 2013 at 6:41 AM, Bruce Momjian wrote: > > Thanks for the many suggestions on improving the 9.3 release notes. > > There were many ideas I would have never thought of. Please keep the > > suggestions coming.

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Bruce Momjian
On Sat, May 4, 2013 at 08:34:18PM +0900, Ian Lawrence Barwick wrote: > 2013/4/24 Bruce Momjian : > > Thanks for the many suggestions on improving the 9.3 release notes. > > There were many ideas I would have never thought of. Please keep the > > suggestions coming. > > One small suggestion: > >

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Marti Raudsepp
Hi! On Wed, Apr 24, 2013 at 6:41 AM, Bruce Momjian wrote: > Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the > suggestions coming. Some observations: 1. "Allow CREATE TABLE IF NOT EXISTS to succeed for a

Re: [HACKERS] 9.3 release notes suggestions

2013-05-04 Thread Ian Lawrence Barwick
2013/4/24 Bruce Momjian : > Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the > suggestions coming. One small suggestion: Have session id (%c) in log_line_prefix always output

Re: [HACKERS] 9.3 release notes suggestions

2013-04-25 Thread Joshua D. Drake
On 04/25/2013 04:48 PM, Daniel Farina wrote: On Wed, Apr 24, 2013 at 6:30 AM, Robert Haas wrote: On Tue, Apr 23, 2013 at 11:41 PM, Bruce Momjian wrote: Thanks for the many suggestions on improving the 9.3 release notes. There were many ideas I would have never thought of. Please keep the s

Re: [HACKERS] 9.3 release notes suggestions

2013-04-25 Thread Daniel Farina
On Wed, Apr 24, 2013 at 6:30 AM, Robert Haas wrote: > On Tue, Apr 23, 2013 at 11:41 PM, Bruce Momjian wrote: >> Thanks for the many suggestions on improving the 9.3 release notes. >> There were many ideas I would have never thought of. Please keep the >> suggestions coming. > > Bruce, > > Thanks

Re: [HACKERS] 9.3 release notes suggestions

2013-04-24 Thread Robert Haas
On Tue, Apr 23, 2013 at 11:41 PM, Bruce Momjian wrote: > Thanks for the many suggestions on improving the 9.3 release notes. > There were many ideas I would have never thought of. Please keep the > suggestions coming. Bruce, Thanks for writing them! -- Robert Haas EnterpriseDB: http://www.ente

[HACKERS] 9.3 release notes suggestions

2013-04-23 Thread Bruce Momjian
Thanks for the many suggestions on improving the 9.3 release notes. There were many ideas I would have never thought of. Please keep the suggestions coming. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for e