On 01/03/2015 12:28 AM, Josh Berkus wrote:
On 01/02/2015 01:57 AM, Heikki Linnakangas wrote:
wal_keep_segments does not affect the calculation of CheckPointSegments.
If you set wal_keep_segments high enough, checkpoint_wal_size will be
exceeded. The other alternative would be to force a
On 2014-12-31 16:32:19 +0100, Andres Freund wrote:
On 2014-12-05 16:18:02 +0900, Fujii Masao wrote:
On Fri, Dec 5, 2014 at 9:28 AM, Andres Freund and...@2ndquadrant.com
wrote:
So I think we just need to make pg_basebackup create to .ready
files.
s/.ready/.done? If yes, +1.
That
On 01/03/2015 02:43 AM, Peter Geoghegan wrote:
On Thu, Jan 1, 2015 at 11:17 PM, Peter Geoghegan p...@heroku.com wrote:
I've been working on fixing the bugs that Jeff Janes found [1] with
approach #2 to value locking [2]. Approach #1 was unaffected.
Unfortunately, exclusion constraints (which
On 12/17/2014 10:35 AM, Simon Riggs wrote:
On 16 December 2014 at 21:17, Simon Riggs si...@2ndquadrant.com wrote:
This patch is a WIP version of doing that, but only currently attempts
With the patch, XLogSendLogical uses the same logic to calculate SendRqstPtr
that XLogSendPhysical does.
On 01/03/2015 12:00 PM, Peter Geoghegan wrote:
Two concurrent exclusion constraints inserters can easily insert at
exactly the same time, and then wait on each other's xact, and then
deadlock. That can't happen with B-Tree inserts because the checking
and insertion happen at the same time, when
On Sat, Jan 3, 2015 at 1:29 AM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
Please explain in words of one syllable how the deadlock arises. Then,
please find a way to fix it.
I believe that the deadlock arises because there is no choke point.
Exclusion constraint insertions always insert
On Tue, Dec 30, 2014 at 4:30 AM, FabrÃzio de Royes Mello
fabriziome...@gmail.com wrote:
On Sun, Dec 28, 2014 at 12:31 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
Hi all,
While reviewing another patch, I have noticed that
recovery_min_apply_delay can have a negative value. And the
On Sat, Jan 3, 2015 at 1:52 AM, Bruce Momjian br...@momjian.us wrote:
I suggest we at least document that this feature as mostly useful for
I/O reduction, and maybe say CPU usage and performance might be
negatively impacted.
FWIW, that's mentioned in the documentation included in the patch..
--
On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote:
Folks,
There was a slash missing, which I've added. Where is the default
directory on Windows, or is there one?
Applied, thanks.
And - from a quick check, it looks like it's actually using /etc on
Windows as well. Which
Hi all,
Shouldn't we update the copyright notices to 2015 for PGDG like in
7e04792? I mean those things mainly:
Portions Copyright (c) 1996-2014, PostgreSQL Global Development Group
Regards,
--
Michael
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
On Sat, Jan 3, 2015 at 2:41 AM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
A-ha, I see. And this can happen without INSERT ON CONFLICT, too? In that
case, one of the transactions is bound to error and roll back anyway, but
you get a deadlock error instead of the constraint violation
On Sat, Jan 03, 2015 at 03:03:45PM -0500, Tom Lane wrote:
David Fetter da...@fetter.org writes:
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The old and the new documentation are both wrong. The directory libpq
consults is `pg_config --sysconfdir`, which is packager-selected
On Fri, Jan 02, 2015 at 03:55:23PM -0600, Jim Nasby wrote:
On 12/31/14, 3:05 PM, Noah Misch wrote:
On Wed, Dec 31, 2014 at 05:33:43PM +, Andrew Gierth wrote:
Noah == Noah Mischn...@leadboat.com writes:
Noah Suppose one node orchestrated all sorting and aggregation.
Well, that has
On 2015-01-03 16:03:36 +0100, Andres Freund wrote:
On 2014-12-31 16:32:19 +0100, Andres Freund wrote:
On 2014-12-05 16:18:02 +0900, Fujii Masao wrote:
On Fri, Dec 5, 2014 at 9:28 AM, Andres Freund and...@2ndquadrant.com
wrote:
So I think we just need to make pg_basebackup create to
Michael Paquier michael.paqu...@gmail.com writes:
On Tue, Dec 30, 2014 at 4:30 AM, FabrÃzio de Royes Mello
fabriziome...@gmail.com wrote:
Shouldn't we simply leave if recovery_min_apply_delay is lower 0, and not
only equal to 0?
Trivial patch for master and REL9_4_STABLE attached as long as
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote:
On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote:
There was a slash missing, which I've added. Where is the default
directory on Windows, or is
On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote:
On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote:
Folks,
There was a slash missing, which I've added. Where is the default
directory on Windows, or is there one?
Applied, thanks.
Thank you.
And
David Fetter da...@fetter.org writes:
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The old and the new documentation are both wrong. The directory libpq
consults is `pg_config --sysconfdir`, which is packager-selected but rarely
matches /etc itself. parseServiceInfo() has the
On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote:
On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote:
There was a slash missing, which I've added. Where is the default
directory on Windows, or is there one?
Applied, thanks.
The old and the new
On Sat, Jan 3, 2015 at 9:03 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David Fetter da...@fetter.org writes:
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The old and the new documentation are both wrong. The directory libpq
consults is `pg_config --sysconfdir`, which is
On 01/03/2015 04:41 PM, Magnus Hagander wrote:
We could do worse than to say it's in the directory printed by
pg_config --sysconfdir.
Yeah. But let's make sure we include usually /etc or something like
that.
But it's not usually /etc. Certainly it's not in the PGDG RPM builds
On Sat, Jan 3, 2015 at 10:52 PM, Andrew Dunstan and...@dunslane.net wrote:
On 01/03/2015 04:41 PM, Magnus Hagander wrote:
We could do worse than to say it's in the directory printed by
pg_config --sysconfdir.
Yeah. But let's make sure we include usually /etc or something like
Magnus Hagander mag...@hagander.net writes:
On Sat, Jan 3, 2015 at 10:52 PM, Andrew Dunstan and...@dunslane.net wrote:
On 01/03/2015 04:41 PM, Magnus Hagander wrote:
Yeah. But let's make sure we include usually /etc or something like
that.
But it's not usually /etc. Certainly it's not in the
On 2014-12-09 14:41:46 -0300, Alvaro Herrera wrote:
So I've been updating my very old patch to allow logical and physical
column reordering. Here's a WIP first cut for examination.
Do you have a updated patch that has ripened further?
The first thing where this matters is tuple descriptor
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The directory libpq consults is `pg_config --sysconfdir`
I was wrong there. `pg_config --sysconfig` uses get_etc_path(), which adjusts
to post-installation moves of the installation tree. parseServiceInfo() uses
the build-time
On 2014-12-22 14:14:31 -0500, Robert Haas wrote:
On Fri, Dec 19, 2014 at 8:59 AM, Robert Haas robertmh...@gmail.com wrote:
And here is a new version.
Here is another new version, with lots of bugs fixed.
A couple remarks:
* Shouldn't this provide more infrastructure to deal with the fact
On 2014-10-21 19:06:41 -0500, Jim Nasby wrote:
On 10/13/14, 8:28 PM, Tom Lane wrote:
Jim Nasby jim.na...@bluetreble.com writes:
CacheInvalidateHeapTuple currently does the following tests first; would
there be a performance improvement to testing the system relation case
first? We're almost
On 2014-12-18 16:05:23 -0600, Jim Nasby wrote:
On 12/18/14, 3:02 PM, Alvaro Herrera wrote:
Andres Freund wrote:
On 2014-12-18 16:41:04 -0300, Alvaro Herrera wrote:
+ if (scan_all)
+ appendStringInfo(buf, _(waited for %d buffer
pins\n),
+
Noah Misch n...@leadboat.com writes:
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The directory libpq consults is `pg_config --sysconfdir`
I was wrong there. `pg_config --sysconfig` uses get_etc_path(), which adjusts
to post-installation moves of the installation tree.
Andres Freund wrote:
On 2014-12-09 14:41:46 -0300, Alvaro Herrera wrote:
So I've been updating my very old patch to allow logical and physical
column reordering. Here's a WIP first cut for examination.
Do you have a updated patch that has ripened further?
Not yet. Phil was kind enough
On 2014-12-31 18:35:38 +0530, Amit Kapila wrote:
+ termoption-j replaceable
class=parameterjobs/replaceable/option/term
+ termoption--jobs=replaceable
class=parameternjobs/replaceable/option/term
+ listitem
+ para
+Number of concurrent connections to perform
On Sat, Jan 3, 2015 at 12:42 PM, Peter Geoghegan p...@heroku.com wrote:
There are probably additional factors that make the situation more
complicated than it is for the ON CONFLICT patch, but it's clear to me
that the mutual dependency that can be involved with two ordinary
exclusion
On Sat, Jan 03, 2015 at 07:56:06PM -0500, Tom Lane wrote:
Noah Misch n...@leadboat.com writes:
On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote:
The directory libpq consults is `pg_config --sysconfdir`
I was wrong there. `pg_config --sysconfig` uses get_etc_path(), which
33 matches
Mail list logo