Re: [HACKERS] Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?

2015-07-04 Thread Fabien COELHO
Hello Robert, I've looked at the maths. I think that the load is distributed as the derivative of this function, that is (1.5 * x ** 0.5): It starts at 0 but very quicky reaches 0.5, it pass the 1.0 (average load) around 40% progress, and ends up at 1.5, that is the finishing load is 1.5 th

Re: [HACKERS] xlc atomics

2015-07-04 Thread Noah Misch
On Sun, Jul 05, 2015 at 12:54:43AM +0200, Andres Freund wrote: > On 2015-07-04 18:40:41 -0400, Noah Misch wrote: > > (1) "IBM XL C/C++ for AIX, V12.1 (5765-J02, 5725-C72)". Getting it working > > required the attached patch. > Will you apply? Having the ability to test change seems to put you in

Re: [HACKERS] xlc atomics

2015-07-04 Thread Andres Freund
On 2015-07-04 18:40:41 -0400, Noah Misch wrote: > (1) "IBM XL C/C++ for AIX, V12.1 (5765-J02, 5725-C72)". Getting it working > required the attached patch. None of my xlc configurations have an > header, and a web search turned up no evidence of one in connection with xlc > platforms. Did you l

[HACKERS] xlc atomics

2015-07-04 Thread Noah Misch
On Wed, Jun 25, 2014 at 07:14:34PM +0200, Andres Freund wrote: > * gcc, msvc work. acc, xlc, sunpro have blindly written support which > should be relatively easy to fix up. I tried this on three xlc configurations. (1) "IBM XL C/C++ for AIX, V12.1 (5765-J02, 5725-C72)". Getting it working req

Re: [HACKERS] Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?

2015-07-04 Thread Robert Haas
On Jul 4, 2015, at 11:34 AM, Fabien COELHO wrote: > In summary, the X^1.5 correction seems to work pretty well. It doesn't > completely eliminate the problem, but it makes it a lot better. > > I've looked at the maths. > > I think that the load is distributed as the derivative of this fu

Re: [HACKERS] multivariate statistics / patch v7

2015-07-04 Thread Tomas Vondra
Hello Horiguchi-san! On 07/03/2015 07:30 AM, Kyotaro HORIGUCHI wrote: Hello, I started to work on this patch. attached is v7 of the multivariate stats patch. The main improvement is major refactoring of the clausesel.c portion - splitting the awfully long spaghetti-style functions into smaller

Re: [HACKERS] PostgreSQL 9.5 Alpha 1 build fail with perl 5.22

2015-07-04 Thread Andrew Dunstan
On 07/04/2015 11:02 AM, Tom Lane wrote: Marco Atzeri writes: for what I see the hstore_plperl link has a double problem. It requires a link to hstore as it also requires a link to perl. Attached patch for solving this and a similar issue with python. +ifeq ($(PORTNAME), cygwin) +# This means w

Re: [HACKERS] Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?

2015-07-04 Thread Fabien COELHO
In summary, the X^1.5 correction seems to work pretty well. It doesn't completely eliminate the problem, but it makes it a lot better. I've looked at the maths. I think that the load is distributed as the derivative of this function, that is (1.5 * x ** 0.5): It starts at 0 but very quicky r

Re: [HACKERS] PostgreSQL 9.5 Alpha 1 build fail with perl 5.22

2015-07-04 Thread Tom Lane
Marco Atzeri writes: > for what I see the hstore_plperl link has a double problem. > It requires a link to hstore > as it also requires a link to perl. > Attached patch for solving this and a similar issue with python. > +ifeq ($(PORTNAME), cygwin) > +# This means we need an in-tree build on Wind

Re: [HACKERS] [BUGS] BUG #13126: table constraint loses its comment

2015-07-04 Thread Michael Paquier
On Fri, Jul 3, 2015 at 11:59 PM, Petr Jelinek wrote: > Well for indexes you don't really need to add the new AT command, as > IndexStmt has char *idxcomment which it will automatically uses as comment > if not NULL. While I am not huge fan of the idxcomment it doesn't seem to > be easy to remove i

Re: [HACKERS] postgresql-9.5alpha1 packaging

2015-07-04 Thread Michael Paquier
On Sat, Jul 4, 2015 at 4:40 PM, Marco Atzeri wrote: > As there are additional or moved binaries in comparison to 9.4 > > -usr/bin/pg_archivecleanup.exe > -usr/bin/pg_rewind.exe > -usr/bin/pg_test_fsync.exe > -usr/bin/pg_test_timing.exe > -usr/bin/pg_upgrade.exe > -usr/bin/pg_xlogdump.exe > -usr/bi

Re: [HACKERS] PATCH:do not set Win32 server-side socket buffer size on windows 2012

2015-07-04 Thread chenhj
2015-07-03 16:49:44,"David Rowley" wrote: I'm wondering what the original test setup was. I'm assuming psql and postgres both running on separate windows machines? I've tested the patch just connecting to a database running on localhost and I'm not getting much of a speedup. Perhaps 1%, if th

[HACKERS] C# reading result from a function

2015-07-04 Thread drunken
Hi guys, I have a problem with a sipmle function in postgresql. The func() calculates two integers to a result and returns it. The result is in the DB, but not in the Console Line in C#. So for example when i have par1 = 2 and par2 = 5 I get an DB entry with 7 in the result row, but the ConsoleLine

[HACKERS] postgresql-9.5alpha1 packaging

2015-07-04 Thread Marco Atzeri
As there are additional or moved binaries in comparison to 9.4 -usr/bin/pg_archivecleanup.exe -usr/bin/pg_rewind.exe -usr/bin/pg_test_fsync.exe -usr/bin/pg_test_timing.exe -usr/bin/pg_upgrade.exe -usr/bin/pg_xlogdump.exe -usr/bin/pgbench.exe any suggestion where to fit them ? Current split on cy

Re: [HACKERS] PostgreSQL 9.5 Alpha 1 build fail with perl 5.22

2015-07-04 Thread Marco Atzeri
On 7/3/2015 2:31 PM, Marco Atzeri wrote: On 7/3/2015 8:19 AM, Michael Paquier wrote: On Fri, Jul 3, 2015 at 2:47 PM, Marco Atzeri wrote: On 7/2/2015 5:16 PM, Dave Page wrote: -lldap hstore_plperl.o: In function `hstore_to_plperl': /pub/devel/postgresql/prova/postgresql-9.5alpha1-1.i686/sr