Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Andrew Dunstan
On 05/05/2014 07:16 PM, Bruce Momjian wrote: On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote: On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan and...@dunslane.net wrote: How about: This data type allows for faster access to values in the json document and faster and more

Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Peter Geoghegan
On Mon, May 5, 2014 at 4:26 PM, Andrew Dunstan and...@dunslane.net wrote: After all, everything that's not a number or boolean is typed as text (just as it is in JSON). We don't, for example, map anything to timestamp types. JSON doesn't have a timestamp primitive type. Of those types that it

Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Andrew Dunstan
On 05/05/2014 07:34 PM, Peter Geoghegan wrote: On Mon, May 5, 2014 at 4:26 PM, Andrew Dunstan and...@dunslane.net wrote: After all, everything that's not a number or boolean is typed as text (just as it is in JSON). We don't, for example, map anything to timestamp types. JSON doesn't have a

Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Bruce Momjian
On Mon, May 5, 2014 at 04:20:26PM -0700, Peter Geoghegan wrote: On Mon, May 5, 2014 at 4:14 PM, Bruce Momjian br...@momjian.us wrote: We rarely get into specific numers like this. It says higher limit(s) and hopefully that is enough. If you want to create a documentation 'id' I can like

Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Peter Geoghegan
On Mon, May 5, 2014 at 5:13 PM, Bruce Momjian br...@momjian.us wrote: OK, I understand now. I also split the item into two separate ones so I could highlight things. Please see the new ouput --- I ended up creating a pg_stat_statements section because there are now three items:

Re: [HACKERS] 9.4 release notes

2014-05-05 Thread Bruce Momjian
On Mon, May 5, 2014 at 05:22:59PM -0700, Peter Geoghegan wrote: On Mon, May 5, 2014 at 5:13 PM, Bruce Momjian br...@momjian.us wrote: OK, I understand now. I also split the item into two separate ones so I could highlight things. Please see the new ouput --- I ended up creating a

Re: [HACKERS] [PATCH] `pg_dump -Fd` doesn't check write return status...

2014-05-05 Thread Bruce Momjian
On Tue, Apr 22, 2014 at 03:19:15PM -0400, Bruce Momjian wrote: On Sat, Mar 1, 2014 at 12:27:19PM -0800, Sean Chittenden wrote: The attached patch fixes the case when `pg_dump -Fd …` is called on a partition where write(2) fails for some reason or another. In this case, backup jobs were

Re: [HACKERS] pg_shmem_allocations view

2014-05-05 Thread Robert Haas
On Mon, May 5, 2014 at 6:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Mon, May 5, 2014 at 3:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: And the controlled shared segment is likely to be how big exactly? It's probably not even possible for it to be

Re: [HACKERS] Docs for 9.4's worker_spi?

2014-05-05 Thread Robert Haas
On Mon, May 5, 2014 at 1:30 PM, Bruce Momjian br...@momjian.us wrote: Seems there is no documentation for the 9.4 worker_spi contrib module. Is this OK? The comment at the top of the C file says: * Sample background worker code that demonstrates various coding * patterns:

Re: [HACKERS] Docs for 9.4's worker_spi?

2014-05-05 Thread Alvaro Herrera
Robert Haas wrote: On Mon, May 5, 2014 at 1:30 PM, Bruce Momjian br...@momjian.us wrote: Seems there is no documentation for the 9.4 worker_spi contrib module. Is this OK? The comment at the top of the C file says: * Sample background worker code that demonstrates various coding

Re: [HACKERS] Per table autovacuum vacuum cost limit behaviour strange

2014-05-05 Thread Amit Kapila
On Mon, May 5, 2014 at 11:57 AM, Mark Kirkwood mark.kirkw...@catalyst.net.nz wrote: On 05/05/14 15:22, Amit Kapila wrote: Right, but have a look at the 1st message in this thread - the current behavior (and to a large extent the above condition) means that setting cost limits per table does

Re: [HACKERS] elog a stack trace

2014-05-05 Thread MauMau
From: Jeff Janes jeff.ja...@gmail.com Does anyone have any hints on how to get a stack trace programmatically, rather than trying to run ps to get the pid and then attach gdb to a ephemeral process and hoping the situation has not been changed while you are doing that? I'd like to set

Re: [HACKERS] Per table autovacuum vacuum cost limit behaviour strange

2014-05-05 Thread Mark Kirkwood
On 06/05/14 16:28, Amit Kapila wrote: On Mon, May 5, 2014 at 11:57 AM, Mark Kirkwood mark.kirkw...@catalyst.net.nz wrote: On 05/05/14 15:22, Amit Kapila wrote: Right, but have a look at the 1st message in this thread - the current behavior (and to a large extent the above condition) means that

Re: [HACKERS] Fix initdb for path with whitespace and at char

2014-05-05 Thread Amit Kapila
On Mon, May 5, 2014 at 6:38 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 05/01/2014 07:55 AM, Amit Kapila wrote: 4. Similar to Andrew, I also could not reproduce this problem on my Windows system (Windows 7 64 bit) e:\e:\PostgreSQL\master\install 1\ins@1\bin\initdb.exe -D e:

<    1   2