Re: [HACKERS] Patch for reserved connections for replication users

2013-10-13 Thread Amit Kapila
On Thu, Oct 10, 2013 at 3:17 AM, Gibheer gibh...@zero-knowledge.org wrote: On Mon, 7 Oct 2013 11:39:55 +0530 Amit Kapila amit.kapil...@gmail.com wrote: Robert Haas wrote: On Mon, Aug 5, 2013 at 2:04 AM, Andres Freund andres(at)2ndquadrant(dot)com wrote: Hmm. It seems like this match is

Re: [HACKERS] dynamic shared memory

2013-10-13 Thread Amit Kapila
On Wed, Oct 9, 2013 at 1:10 AM, Robert Haas robertmh...@gmail.com wrote: On Thu, Sep 26, 2013 at 9:27 AM, Noah Misch n...@leadboat.com wrote: There's no data corruption problem if we proceed - but there likely has been one leading to the current state. +1 for making this one a PANIC,

Re: [HACKERS] Patch for reserved connections for replication users

2013-10-13 Thread Gibheer
On Sun, 13 Oct 2013 11:38:17 +0530 Amit Kapila amit.kapil...@gmail.com wrote: On Thu, Oct 10, 2013 at 3:17 AM, Gibheer gibh...@zero-knowledge.org wrote: On Mon, 7 Oct 2013 11:39:55 +0530 Amit Kapila amit.kapil...@gmail.com wrote: Robert Haas wrote: On Mon, Aug 5, 2013 at 2:04 AM, Andres

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Tom Lane
Andres Freund and...@2ndquadrant.com writes: I think we should remove support for the following architectures: - superH This one was contributed just a year or two ago, if memory serves, which suggests that somebody out there cares about it. OTOH, if they still care, we could insist they

Re: [HACKERS] Compression of full-page-writes

2013-10-13 Thread Jesper Krogh
On 11/10/13 19:06, Andres Freund wrote: On 2013-10-11 09:22:50 +0530, Amit Kapila wrote: I think it will be difficult to prove by using any compression algorithm, that it compresses in most of the scenario's. In many cases it can so happen that the WAL will also not be reduced and tps can also

Re: [HACKERS] ECPG FETCH readahead

2013-10-13 Thread Boszormenyi Zoltan
2013-10-11 00:16 keltezéssel, Alvaro Herrera írta: Boszormenyi Zoltan escribió: 2013-09-10 03:04 keltezéssel, Peter Eisentraut írta: You need to update the dblink regression tests. Done. Dude, this is an humongous patch. You *know* that the patch is available in pieces at

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Andres Freund
On 2013-10-12 18:35:00 -0700, Peter Geoghegan wrote: Not so sure about these. - M32R (no userspace CAS afaics) I don't think M32R will hurt us/anybody much. - 32bit/v9 sparc (doesn't have proper atomics, old) Sparc v9 is from 1995, so I think not supporting it anymore is fair. It's afaics

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Andres Freund
On 2013-10-13 11:34:42 +0200, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: I think we should remove support for the following architectures: - superH This one was contributed just a year or two ago, if memory serves, which suggests that somebody out there cares about it.

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Andres Freund
On 2013-10-13 14:08:59 +0200, Andres Freund wrote: On 2013-10-13 11:34:42 +0200, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: I think we should remove support for the following architectures: - superH This one was contributed just a year or two ago, if memory serves,

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Tom Lane
Andres Freund and...@2ndquadrant.com writes: That's a fair point. But all of them will use gcc, right? I've previously thought we'd need 4.4 because there's an incompatibility between 4.3 and 4.4 but I think it won't touch us, so 4.2 which added atomics for mips seems fine. Given there's no

Re: [HACKERS] Triggers on foreign tables

2013-10-13 Thread Ronan Dunklau
Le samedi 12 octobre 2013 07:30:35 Kohei KaiGai a écrit : 2013/10/10 Ronan Dunklau rdunk...@gmail.com: Sorry, I'm uncertain the point above. Are you saying FDW driver may be able to handle well a case when a remote tuple to be updated is different from a remote tuple being fetched on the

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Andres Freund
On 2013-10-13 16:56:12 +0200, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: That's a fair point. But all of them will use gcc, right? I've previously thought we'd need 4.4 because there's an incompatibility between 4.3 and 4.4 but I think it won't touch us, so 4.2 which added

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Tom Lane
Andres Freund and...@2ndquadrant.com writes: The question about platforms that simply cannot provide such atomics like PA-RISC, which afaics is the only one, remains tho. I am not sure we really want to provide codepaths that are only going to be tested there. PA-RISC is a dead architecture.

Re: [HACKERS] removing old ports and architectures

2013-10-13 Thread Andres Freund
On 2013-10-13 20:39:21 +0200, Tom Lane wrote: Andres Freund and...@2ndquadrant.com writes: The question about platforms that simply cannot provide such atomics like PA-RISC, which afaics is the only one, remains tho. I am not sure we really want to provide codepaths that are only going to

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-13 Thread Dimitri Fontaine
MauMau maumau...@gmail.com writes: I understand this problem occurs only when the user configured the application server to use distributed transactions, the application server crashed between prepare and commit/rollback, and the user doesn't recover the application server. So only improper

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-13 Thread Dimitri Fontaine
Magnus Hagander mag...@hagander.net writes: Frankly, I think we'd help 1000 times more users of we enabled a few wal writers by default and jumped the wal level. Mainly so they could run one off base backup. That's used by orders of magnitude more users than XA. +1, or += default

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-13 Thread Andres Freund
On 2013-10-12 09:04:55 +0200, Magnus Hagander wrote: Frankly, I think we'd help 1000 times more users of we enabled a few wal writers by default and jumped the wal level. Mainly so they could run one off base backup. That's used by orders of magnitude more users than XA. Yes, I've thought

Re: [HACKERS] INSERT...ON DUPLICATE KEY LOCK FOR UPDATE

2013-10-13 Thread Peter Geoghegan
On Wed, Oct 9, 2013 at 1:11 PM, Peter Geoghegan p...@heroku.com wrote: Unfortunately, I have a very busy schedule in the month ahead, including travelling to Ireland and Japan, so I don't think I'm going to get the opportunity to work on this too much. I'll try and produce a V4 that formally