Re: [HACKERS] [PATCH]Tablesample Submission

2013-05-22 Thread Simon Riggs
On 17 May 2013 21:46, Jaime Casanova ja...@2ndquadrant.com wrote: On Sun, Nov 4, 2012 at 10:22 PM, Qi Huang huangq...@outlook.com wrote: Dear hackers Sorry for not replying the patch review. I didn't see the review until recently as my mail box is full of Postgres mails and I didn't

[HACKERS] Running pgindent

2013-05-22 Thread Bruce Momjian
Do we want to run pgindent soon? -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] Add more regression tests for CREATE OPERATOR

2013-05-22 Thread Robins Tharakan
Hi, Please find attached a patch to take code-coverage of CREATE OPERATOR (src/backend/commands/operatorcmds.c) from 56% to 91%. Any and all feedback is welcome. -- Robins Tharakan regress_createoperator.patch Description: Binary data -- Sent via pgsql-hackers mailing list

[HACKERS] WAL segments (names) not in a sequence

2013-05-22 Thread Amit Langote
A PostgreSQL user recently reported on pgsql-admin about an issue: when he changed wal_level from 'minimal' to 'hot_standby', the WAL segment sequence rewound, that is, it started using old names. A snippet of his ls -lrt pg_xlog: -rw--- 1 postgres postgres 16777216 May 21 12:13

Re: [HACKERS] MVCC catalog access

2013-05-22 Thread Robert Haas
On Tue, May 21, 2013 at 10:18 PM, Robert Haas robertmh...@gmail.com wrote: [ MVCC catalog access seems to be pretty cheap ] In discussions today, Tom Lane suggested testing the time to start up a backend and run a simple query such as SELECT 2+2 in the absence of a relcache file. I did this and

Re: [HACKERS] Running pgindent

2013-05-22 Thread Robert Haas
On Wed, May 22, 2013 at 1:52 PM, Bruce Momjian br...@momjian.us wrote: Do we want to run pgindent soon? +1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] MVCC catalog access

2013-05-22 Thread Andres Freund
On 2013-05-22 22:51:13 -0400, Robert Haas wrote: In discussions today, Tom Lane suggested testing the time to start up a backend and run a simple query such as SELECT 2+2 in the absence of a relcache file. I did this and can't measure any overhead as a result of MVCC catalog access. I tried

Re: [HACKERS] Heap truncation without AccessExclusiveLock (9.4)

2013-05-22 Thread Robert Haas
On Mon, May 20, 2013 at 10:19 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: It shouldn't be difficult to restrict the set of backends that have to be signaled to those that have the relation open. You could have a special kind of catchup signal that means catch yourself up, but don't

Re: [HACKERS] MVCC catalog access

2013-05-22 Thread Robert Haas
On Wed, May 22, 2013 at 11:02 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-05-22 22:51:13 -0400, Robert Haas wrote: In discussions today, Tom Lane suggested testing the time to start up a backend and run a simple query such as SELECT 2+2 in the absence of a relcache file. I did

Re: [HACKERS] MVCC catalog access

2013-05-22 Thread Andres Freund
On 2013-05-22 23:05:40 -0400, Robert Haas wrote: On Wed, May 22, 2013 at 11:02 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-05-22 22:51:13 -0400, Robert Haas wrote: In discussions today, Tom Lane suggested testing the time to start up a backend and run a simple query such as