Re: [HACKERS] avoiding tuple copying in btree index builds

On Wed, Jun 4, 2014 at 2:08 AM, Robert Haas robertmh...@gmail.com wrote: On Sun, Jun 1, 2014 at 3:26 AM, Amit Kapila amit.kapil...@gmail.com wrote: I also think it's possible to have similar optimization for hash index incase it has to spool the tuple for sorting. In function

Re: [HACKERS] cancelling statement due to user request error occurs but the transaction has committed.

On Fri, Jun 6, 2014 at 2:11 PM, Naoya Anzai anzai-na...@mxu.nes.nec.co.jp wrote: Hi All, When log_duration is true ( or log_min_duration_statement=0 ), If a transaction has internally been commited receives a SIGINT signal then a query cancellation error is output. For example, 1. A query

Re: [HACKERS] Proposing pg_hibernate

On Fri, Jun 6, 2014 at 5:31 PM, Gurjeet Singh gurj...@singh.im wrote: On Thu, Jun 5, 2014 at 11:32 PM, Amit Kapila amit.kapil...@gmail.com wrote: Buffer saver process itself can crash while saving or restoring buffers. True. That may lead to partial list of buffers being saved. And the

[HACKERS] Allowing NOT IN to use ANTI joins

Currently pull_up_sublinks_qual_recurse only changes the plan for NOT EXISTS queries and leaves NOT IN alone. The reason for this is because the values returned by a subquery in the IN clause could have NULLs. A simple example of this (without a subquery) is: select 1 where 3 not in (1, 2,

Re: [HACKERS] Scaling shared buffer eviction

Amit Kapila amit.kapil...@gmail.com wrote: I have improved the patch  by making following changes: a. Improved the bgwriter logic to log for xl_running_xacts info and     removed the hibernate logic as bgwriter will now work only when     there is scarcity of buffer's in free list. Basic idea

Re: [HACKERS] Securing make check (CVE-2014-0067)

On Sun, Mar 23, 2014 at 07:04:20PM -0400, Noah Misch wrote: On Thu, Mar 06, 2014 at 11:52:22PM -0500, Noah Misch wrote: On Thu, Mar 06, 2014 at 12:44:34PM -0500, Tom Lane wrote: I'm inclined to suggest that we should put the socket under $CWD by default, but provide some way for the user

[HACKERS] configure does not check for bison or flex

I am installing postgresql from source on 64 bit Ubuntu 14.04 and when I run the ./configure script, it is successful, but when I run make it fails with an error: ERROR: `flex' is missing on your system. It is needed to create the file `bootscanner.c'. You can either get flex from a GNU

Re: [HACKERS] configure does not check for bison or flex

Eric L wrote I am installing postgresql from source on 64 bit Ubuntu 14.04 and when I run the ./configure script, it is successful, but when I run make it fails with an error: ERROR: `flex' is missing on your system. It is needed to create the file `bootscanner.c'. You can either get flex

[HACKERS] MinGW/Cygwin build snags

First, when I tried to add an Assert() call to a file in src/port, a MinGW-w64 build failed like this: Creating library file: libpostgres.a ../../src/port/libpgport_srv.a(fls_srv.o): In function `fls': /home/nm/src/pg/mingw-postgresql/src/port/fls.c:63: undefined reference to

Re: [HACKERS] MinGW/Cygwin build snags

Noah Misch n...@leadboat.com writes: First, when I tried to add an Assert() call to a file in src/port, a MinGW-w64 build failed like this: Creating library file: libpostgres.a ../../src/port/libpgport_srv.a(fls_srv.o): In function `fls': /home/nm/src/pg/mingw-postgresql/src/port/fls.c:63:

[HACKERS] NUMA packaging and patch

I ran into a situation where a machine with 4 NUMA memory nodes and 40 cores had performance problems due to NUMA.  The problems were worst right after they rebooted the OS and warmed the cache by running a script of queries to read all tables.  These were all run on a single connection.  As it

Re: [HACKERS] MinGW/Cygwin build snags

On Sun, Jun 08, 2014 at 06:04:46PM -0400, Tom Lane wrote: Noah Misch n...@leadboat.com writes: Since src/makefiles/Makefile.win32 does not set BUILDING_DLL for src/port, PGDLLIMPORT is set improperly for code to be linked directly into the backend. Makefile.win32 does set BUILDING_DLL

Re: [HACKERS] backup_label revisited

On Wed, Jun 04, 2014 at 06:17:29PM +0100, Greg Stark wrote: On Mon, Jun 2, 2014 at 2:10 PM, Fujii Masao masao.fu...@gmail.com wrote: What about the case where we restore the backup to another server and start the recovery? In this case, ISTM inode can be the same. No? Hm, I was about to

Re: [HACKERS] updated emacs configuration

On Wed, Aug 07, 2013 at 07:57:53AM -0400, Peter Eisentraut wrote: On 7/2/13 8:42 PM, Peter Eisentraut wrote: Updated files with changes: - adjusted fill-column to 78, per Noah - added c-file-style, per Andrew - support both postgresql and postgres directory names - use defun instead

Re: [HACKERS] wrapping in extended mode doesn't work well with default pager

On Fri, May 23, 2014 at 10:10:23AM -0400, Alvaro Herrera wrote: Sergey Muraviov wrote: I found some new bugs and fix them. And I had to make many changes. This version fixes some bugs I had noticed in expanded mode too. For instance, the original looked like this (five lines plus

Re: [HACKERS] Scaling shared buffer eviction

On Sun, Jun 8, 2014 at 7:21 PM, Kevin Grittner kgri...@ymail.com wrote: Amit Kapila amit.kapil...@gmail.com wrote: I have improved the patch by making following changes: a. Improved the bgwriter logic to log for xl_running_xacts info and removed the hibernate logic as bgwriter will now

[HACKERS] RETURNING PRIMARY KEY syntax extension

Hi, The JDBC API provides the getGeneratedKeys() method as a way of retrieving primary key values without the need to explicitly specify the primary key column(s). This is a widely-used feature, however the implementation has significant performance drawbacks. Currently this feature is

Re: [HACKERS] RETURNING PRIMARY KEY syntax extension

Ian Barwick wrote Hi, The JDBC API provides the getGeneratedKeys() method as a way of retrieving primary key values without the need to explicitly specify the primary key column(s). This is a widely-used feature, however the implementation has significant performance drawbacks.