Re: [HACKERS] Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby

On Sun, Nov 1, 2015 at 11:09 PM, Michael Paquier wrote: > On Mon, Nov 2, 2015 at 2:58 PM, Jeff Janes wrote: >> Simple patch, applies and makes cleanly, does what it says and says what it >> does. >> >> If a transaction holding locks aborts on an otherwise idle server, perhaps >> it will take a

Re: [HACKERS] Request: pg_cancel_backend variant that handles 'idle in transaction' sessions

2015-11-02 5:23 GMT+01:00 Amit Kapila : > On Sun, Nov 1, 2015 at 11:34 PM, Tom Lane wrote: > > > > Magnus Hagander writes: > > > On Sat, Oct 31, 2015 at 5:50 AM, Amit Kapila > > > wrote: > > >> Why pg_cancel_backend(pid) is not sufficient for the above use case? > > >> Basically you want to rol

[HACKERS] Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

Hi, Michael! Thanks for your reply! I knew that postgresql windows service is made by "pg_ctl register -N serviceName -D dataPath". And command from service, like "D:\Program Files (x86)\PostgreSQL\9.4\bin\pg_ctl.exe" runservice -N "postgres-9.4" -D "D:\Program Files (x86)\PostgreSQL\9.4\data", c

Re: [HACKERS] Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby

On Mon, Nov 2, 2015 at 2:58 PM, Jeff Janes wrote: > Simple patch, applies and makes cleanly, does what it says and says what it > does. > > If a transaction holding locks aborts on an otherwise idle server, perhaps it > will take a very long time for a log-shipping standby to realize this. But

Re: [HACKERS] Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

On Mon, Nov 2, 2015 at 2:54 PM, YuanyuanLiu wrote: > Nowadays, I always got problem about postgresql windows service. > I find, postgresql usually use the following command to register windows > services: > /"D:\Program Files (x86)\PostgreSQL\9.4\bin\pg_ctl.exe" runservice -N > "postgresql-9.4"

Re: [HACKERS] remove wal_level archive

On Mon, Nov 2, 2015 at 2:21 PM, Craig Ringer wrote: > On 1 September 2015 at 10:39, Peter Eisentraut wrote: >> So we've had several rounds of discussions about simplifying replication >> configuration in general and the wal_level setting in particular. [0][1] >> >> [snip] >> >> Bike-shedding: In

[HACKERS] Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby

The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:not tested Simple patch, applies and makes cleanly, does what it says and says w

[HACKERS] Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service

Hi, Hackers! Nowadays, I always got problem about postgresql windows service. I find, postgresql usually use the following command to register windows services: /"D:\Program Files (x86)\PostgreSQL\9.4\bin\pg_ctl.exe" runservice -N "postgresql-9.4" -D "D:\Program Files (x86)\PostgreSQL\9.4\data"

Re: [HACKERS] remove wal_level archive

On 1 September 2015 at 10:39, Peter Eisentraut wrote: > So we've had several rounds of discussions about simplifying replication > configuration in general and the wal_level setting in particular. [0][1] > > [snip] > > Bike-shedding: In this patch, I removed "archive" and kept > "hot_standby", be

Re: [HACKERS] Request: pg_cancel_backend variant that handles 'idle in transaction' sessions

On Sun, Nov 1, 2015 at 11:34 PM, Tom Lane wrote: > > Magnus Hagander writes: > > On Sat, Oct 31, 2015 at 5:50 AM, Amit Kapila > > wrote: > >> Why pg_cancel_backend(pid) is not sufficient for the above use case? > >> Basically you want to rollback current transaction, I think that can be > >> ach

Re: [HACKERS] eXtensible Transaction Manager API

On 31 October 2015 at 17:22, konstantin knizhnik wrote: > Waiting for your feedback For anyone wondering about performance impact, there are some graphs on page 23 of the PDF presentation. I didn't see anything else, and the graphs don't seem to cover comparison of Pg with the XTM transaction ma

Re: [HACKERS] POC: Cache data in GetSnapshotData()

On Sun, Nov 1, 2015 at 8:46 PM, Jim Nasby wrote: > On 5/25/15 10:04 PM, Amit Kapila wrote: > >> On Tue, May 26, 2015 at 12:10 AM, Andres Freund > > wrote: >> > >> > On 2015-05-20 19:56:39 +0530, Amit Kapila wrote: >> > > I have done some tests with this patch to see

Re: [HACKERS] Patent warning about the Greenplum source code

On Sun, Nov 1, 2015 at 12:12:48PM -0800, Josh Berkus wrote: > Do let me point out that *code* isn't patented. *techniques* are. So > those techniques are patented whether or not you read the code. It's > just that if you read the code, copy the technique directly, and put it > in Postgres, that

Re: [HACKERS] September 2015 Commitfest

Jim Nasby writes: > On 10/31/15 11:19 AM, Nathan Wagner wrote: >> I think it would be very useful to just be able to tell the system "fire >> this up for me so I can test it". I don't think it needs to handle >> every possible testing scenario, just making it easier to leave up the >> test postma

Re: [HACKERS] September 2015 Commitfest

On 10/31/15 11:19 AM, Nathan Wagner wrote: >You could imagine putting something into the standard makefiles >that did some subset of this, but I think it would be too rigid >to be useful. I think it would be very useful to just be able to tell the system "fire this up for me so I can test it".

Re: [HACKERS] COPY (INSERT/UPDATE/DELETE .. RETURNING ..)

On Sun, Nov 1, 2015 at 2:49 AM, Marko Tiikkaja wrote: > I can't add this to November's commit fest, but I'm posting this anyway in > case someone is thinking about implementing this feature. Note: this one has been added to CF: https://commitfest.postgresql.org/7/414/ -- Michael -- Sent via pg

Re: [HACKERS] WIP: Fix parallel workers connection bug in pg_dump (Bug #13727)

On 10/25/15 10:55 PM, Zeus Kronion wrote: Parallel workers were failing to connect to the database when running pg_dump with a connection string. The first of the following two commands runs without errors, while the second one fails: pg_dump "postgres://my-user:my-passw...@my.hostname.com:5432/m

Re: [HACKERS] fortnight interval support

On Sun, Nov 01, 2015 at 01:06:39PM -0500, Tom Lane wrote: > David Fetter writes: > > On Tue, Oct 27, 2015 at 07:30:13PM +, Nathan Wagner wrote: > >> On Wed, Oct 28, 2015 at 08:17:25AM +1300, Gavin Flower wrote: > >> What, it's a "fortnight", not a "quinzaine". > >> > >> You have no idea how h

Re: [HACKERS] Patent warning about the Greenplum source code

On 10/31/2015 11:47 PM, Bruce Momjian wrote: > On Sun, Nov 1, 2015 at 01:27:13AM -0500, Bruce Momjian wrote: >> On Fri, Oct 30, 2015 at 04:47:35AM -0400, Bruce Momjian wrote: >>> Therefore, I caution people from viewing the Greenplum source code as >>> you might see patented ideas that could be la

Re: [HACKERS] fortnight interval support

David Fetter writes: > On Tue, Oct 27, 2015 at 07:30:13PM +, Nathan Wagner wrote: >> On Wed, Oct 28, 2015 at 08:17:25AM +1300, Gavin Flower wrote: >> What, it's a "fortnight", not a "quinzaine". >> >> You have no idea how hard it was to resist updating the patch... > Well, if you won't do it

Re: [HACKERS] Request: pg_cancel_backend variant that handles 'idle in transaction' sessions

Magnus Hagander writes: > On Sat, Oct 31, 2015 at 5:50 AM, Amit Kapila > wrote: >> Why pg_cancel_backend(pid) is not sufficient for the above use case? >> Basically you want to rollback current transaction, I think that can be >> achieved by pg_cancel_backend. > Not when the session is idle in t

Re: [HACKERS] Request: pg_cancel_backend variant that handles 'idle in transaction' sessions

On Sat, Oct 31, 2015 at 5:50 AM, Amit Kapila wrote: > On Sat, Oct 31, 2015 at 2:50 AM, Merlin Moncure > wrote: > > > > Idle hanging transactions from poorly written applications are the > > bane of my existence. Several months back one of them took down one > > of hour production websites for s

Re: [HACKERS] fortnight interval support

On Tue, Oct 27, 2015 at 07:30:13PM +, Nathan Wagner wrote: > On Wed, Oct 28, 2015 at 08:17:25AM +1300, Gavin Flower wrote: > > You trying to get PostgreSQL banned in France??? :-) > > > > When I was learning French many years ago, I was told that the French > > consider their fortnight to be

Re: [HACKERS] POC: Cache data in GetSnapshotData()

On 5/25/15 10:04 PM, Amit Kapila wrote: On Tue, May 26, 2015 at 12:10 AM, Andres Freund mailto:and...@anarazel.de>> wrote: > > On 2015-05-20 19:56:39 +0530, Amit Kapila wrote: > > I have done some tests with this patch to see the benefit with > > and it seems to me this patch helps in reducin

[HACKERS] [patch] to build docs on Mac OS X El Capitan with MacPorts

The attached patch was required to get the docs to build on Mac OS X 10.11.1 (15B42) with MacPorts 2.3.4. After changing docbook.m4 ‘autoreconf’ has to be run. This patch does not include the new version of ‘configure' As explained in the devel documentation (J.2.6) the docs could be made to b

Re: [HACKERS] September 2015 Commitfest

On 11/1/15 11:36 AM, Michael Paquier wrote: On Sun, Nov 1, 2015 at 1:53 AM, Marko Tiikkaja wrote: Are we doing these in an Australian time zone now? It was quite unpleasant to find that the 2015-11 is "in progress" already and two of my patches will not be in there. AFAIR the submission deadl

Re: [HACKERS] Proposal: Trigonometric functions in degrees

On 27 October 2015 at 08:24, Dean Rasheed wrote: > I think it's still feasible to have sind(30) = 0.5 exactly and keep > monotonicity > Here's a patch along those lines. It turned out to be fairly straightforward. It's still basically a thin wrapper on top of the math library trig functions,

Re: [HACKERS] September 2015 Commitfest

On Sun, Nov 1, 2015 at 1:53 AM, Marko Tiikkaja wrote: > On 10/31/15 12:42 AM, Michael Paquier wrote: >> >> So, seeing nothing happening I have done the above, opened 2015-11 CF >> and closed the current one. > > > Are we doing these in an Australian time zone now? It was quite unpleasant > to fin