Re: [HACKERS] PostgreSQL Auditing

2016-02-01 Thread Noah Misch
On Tue, Feb 02, 2016 at 01:05:46AM +, Curtis Ruck wrote: > So Auditing, it seems that some people want auditing (myself, David Steele, > 2nd quadrant, and probably others). I personally love postgresql, but > until it can meet my annoying compliance requirements, I can't leverage it > fully

Re: [HACKERS] PostgreSQL Audit Extension

2016-02-01 Thread Robert Haas
On Sun, Jan 31, 2016 at 5:19 PM, Alvaro Herrera wrote: > Joshua D. Drake wrote: >> On 01/31/2016 05:07 AM, Alvaro Herrera wrote: >> >David Steele wrote: >> >>The attached patch implements audit logging for PostgreSQL as an >> >>extension. I believe I have addressed the

Re: [HACKERS] Template for commit messages

2016-02-01 Thread Noah Misch
On Mon, Feb 01, 2016 at 01:55:23PM +0200, Heikki Linnakangas wrote: > On 01/02/16 13:36, Andres Freund wrote: > >On 2016-01-28 06:03:02 -0500, Bruce Momjian wrote: > >>Reported-by: > >>Bug: > >>Author: > >>Reviewed-by: > >>Tested-by: > >>Backpatch-through: > > > >I

Re: [HACKERS] proposal: PL/Pythonu - function ereport

2016-02-01 Thread Catalin Iacob
On Mon, Feb 1, 2016 at 5:37 PM, Pavel Stehule wrote: > Dne 29. 1. 2016 18:09 napsal uživatel "Catalin Iacob" > : >> Looking at the output above, I don't see who would rely on calling >> plpy.error with multiple arguments and getting the tuple so

Re: [HACKERS] Support for N synchronous standby servers - take 2

2016-02-01 Thread Fujii Masao
On Mon, Feb 1, 2016 at 5:36 PM, Masahiko Sawada wrote: > On Sun, Jan 31, 2016 at 8:58 PM, Michael Paquier > wrote: >> On Sun, Jan 31, 2016 at 5:28 PM, Masahiko Sawada >> wrote: >>> On Sun, Jan 31, 2016 at 5:18 PM, Michael

Re: [HACKERS] WAL Re-Writes

2016-02-01 Thread Jim Nasby
On 1/31/16 3:26 PM, Jan Wieck wrote: On 01/27/2016 08:30 AM, Amit Kapila wrote: operation. Now why OS couldn't find the corresponding block in memory is that, while closing the WAL file, we use POSIX_FADV_DONTNEED if wal_level is less than 'archive' which lead to this problem. So with this

Re: [HACKERS] Way to check whether a particular block is on the shared_buffer?

2016-02-01 Thread Jim Nasby
On 1/31/16 7:38 PM, Kouhei Kaigai wrote: > I'm under investigation of SSD-to-GPU direct feature on top of > the custom-scan interface. It intends to load a bunch of data > blocks on NVMe-SSD to GPU RAM using P2P DMA, prior to the data > loading onto CPU/RAM, to preprocess the data to be filtered

Re: [HACKERS] statistics for shared catalogs not updated when autovacuum is off

2016-02-01 Thread Jim Nasby
On 1/30/16 5:05 PM, Peter Eisentraut wrote: When autovacuum is off, the statistics in pg_stat_sys_tables for shared catalogs (e.g., pg_authid, pg_database) never update. So seq_scan doesn't update when you read the table, last_analyze doesn't update when you run analyze, etc. But when you shut

Re: [HACKERS] Template for commit messages

2016-02-01 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 FWIW, I read the git logs quite a bit, especially after a release to gather some stats, and I *love* the commits that have some nice standard, easy to read fields (Alvaro for one does a great job at this). I don't think we need to mandate

Re: [HACKERS] Trigger.sgml

2016-02-01 Thread Jim Nasby
On 1/28/16 8:02 PM, Tatsuo Ishii wrote: I am working as a volunteer to translate docs to Japanese. I have been having hard time to parse the following sentence in doc/src/sgml/trigger.sgml. The possibility of surprising

Re: [HACKERS] silent data loss with ext4 / all current versions

2016-02-01 Thread Alvaro Herrera
Michael Paquier wrote: > On Mon, Jan 25, 2016 at 6:50 PM, Tomas Vondra > wrote: > > Seems OK to me. Thanks for the time and improvements! > > Thanks. Perhaps a committer could have a look then? I have switched > the patch as such in the CF app. Seeing the

Re: [HACKERS] Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system

2016-02-01 Thread Tomas Vondra
Hi, On 12/22/2015 03:49 PM, Noah Misch wrote: On Mon, Feb 18, 2013 at 06:19:12PM -0300, Alvaro Herrera wrote: I have pushed it now. Further testing, of course, is always welcome. While investigating stats.sql buildfarm failures, mostly on animals axolotl and shearwater, I found that this

<    1   2