Corrected: Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2012-03-12 Thread Etsuro Fujita
(2012/03/12 13:04), Etsuro Fujita wrote: (2012/03/09 23:48), Tom Lane wrote: Etsuro Fujitafujita.ets...@lab.ntt.co.jp writes: 2. IMHO RelOptInfo.fdw_private seems confusing. How about renaming it to e.g., RelOptInfo.fdw_state? Why is that better? It seems just as open to confusion with

Re: [HACKERS] Collect frequency statistics for arrays

2012-03-12 Thread Alexander Korotkov
On Thu, Mar 8, 2012 at 4:51 AM, Tom Lane t...@sss.pgh.pa.us wrote: Alexander Korotkov aekorot...@gmail.com writes: True. If (max count - min count + 1) is small, enumerating of frequencies is both more compact and more precise representation. Simultaneously, if (max count - min count + 1)

Re: [HACKERS] elegant and effective way for running jobs inside a database

2012-03-12 Thread Simon Riggs
On Sat, Mar 10, 2012 at 2:59 PM, Andrew Dunstan and...@dunslane.net wrote: The devil is in the details, though, pace Mies van der Rohe. In particular, it's the tight integration piece I'm worried about. What is the postmaster supposed to do if the daemon start fails? What if it gets a flood

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2012-03-12 Thread Albe Laurenz
Tom Lane wrote: Shigeru Hanada shigeru.han...@gmail.com writes: Thanks for the review. Agreed to write own depraser for pgsql_fdw which handles nodes which can be pushed down. Every SQL-based FDW which constructs SQL statement for each local query would need such module inside. Yeah.

Re: [HACKERS] poll: CHECK TRIGGER?

2012-03-12 Thread Pavel Stehule
2012/3/11 Petr Jelinek pjmo...@pjmodos.net: On 03/10/2012 04:36 PM, Pavel Stehule wrote: and there some cleaned version Reran my tests and adjusted docs a bit, tbh I considered the previous versions way more useful but even in this form it's nice and useful functionality. remove two

[HACKERS] NOT NULL violation error handling in file_fdw

2012-03-12 Thread Etsuro Fujita
According to the following documentation on IterateForeignScan() in 50.2. Foreign Data Wrapper Callback Routines, I have created a patch to support the error handling in file_fdw. Please find attached a patch. Note that PostgreSQL's executor doesn't care whether the rows returned violate

Re: [HACKERS] Bug: walsender and high CPU usage

2012-03-12 Thread Heikki Linnakangas
On 09.03.2012 13:40, Fujii Masao wrote: I found the bug which causes walsender to enter into busy loop when replication connection is terminated. Walsender consumes lots of CPU resource (%sys), and this situation lasts until it has detected the termination of replication connection and exited.

Re: [HACKERS] Incorrect behaviour when using a GiST index on points

2012-03-12 Thread Alexander Korotkov
I believe that attached version of patch can be backpatched. It fixes this problem without altering of index building procedure. It just makes checks in internal pages softener enough to compensate effect of gist_box_same implementation. -- With best regards, Alexander Korotkov. ***

Re: [HACKERS] Bug: walsender and high CPU usage

2012-03-12 Thread Fujii Masao
On Mon, Mar 12, 2012 at 7:58 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 09.03.2012 13:40, Fujii Masao wrote: I found the bug which causes walsender to enter into busy loop when replication connection is terminated. Walsender consumes lots of CPU resource (%sys), and

Re: [HACKERS] Bug: walsender and high CPU usage

2012-03-12 Thread Fujii Masao
On Mon, Mar 12, 2012 at 10:27 PM, Fujii Masao masao.fu...@gmail.com wrote: On Mon, Mar 12, 2012 at 7:58 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 09.03.2012 13:40, Fujii Masao wrote: I found the bug which causes walsender to enter into busy loop when replication

[HACKERS] elegant and effective way for running jobs inside a database

2012-03-12 Thread Artur Litwinowicz
Dear Developers, I am looking for elegant and effective way for running jobs inside a database or cluster - for now I can not find that solution. OK if You say use cron or pgAgent I say I know that solutions, but the are not effective and elegant. Compilation of pgAgent is a pain (especially

[HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Will Leinweber
I created an index on an hstore function, fetchval(hstore, text), however when I use the - infix operator which resolves to the very same function, this index is not used. It should be used. I have included an example: Table with hstore index: de10keipt01939= \d log_data

[HACKERS] Requesting Ideas fro project proposal.

2012-03-12 Thread Ali Ahmed
I am looking for some project suggestions to make proposals for an OS course at Columbia university (4-6weeks length single person), working with Scribe ( kernel based application record and replay) focusing on DBMS ( I would like to focus on postgres) . I have some ideas on the line of explore

Re: [HACKERS] Requesting Ideas fro project proposal.

2012-03-12 Thread Ali Ahmed
Sorry ,here is the link the scribe project in reference it's a kernel based record and replay system. https://github.com/nviennot/linux-2.6-scribe On Wed, Mar 7, 2012 at 5:25 PM, Ali Ahmed ahmal...@gmail.com wrote: I am looking for some project suggestions to make proposals for an OS course

Re: [HACKERS] wal_buffers, redux

2012-03-12 Thread Robert Haas
On Sun, Mar 11, 2012 at 11:51 PM, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Mar 11, 2012 at 12:55 PM, Robert Haas robertmh...@gmail.com wrote: I've finally been able to run some more tests of the effect of adjusting wal_buffers to values higher than 16MB.  I ran the test on the 16 core

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Kohei KaiGai
2012/3/9 Robert Haas robertmh...@gmail.com: On Tue, Mar 6, 2012 at 9:14 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: [ new patch ] Are we absolutely certain that we want the semantics of sepgsql_setcon() to be transactional?  Because if we made them non-transactional, this would be a whole

Re: [HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Tom Lane
Will Leinweber w...@heroku.com writes: I created an index on an hstore function, fetchval(hstore, text), however when I use the - infix operator which resolves to the very same function, this index is not used. It should be used. Don't hold your breath. Create an index on the expression you

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Kohei KaiGai
2012/3/11 Yeb Havinga yebhavi...@gmail.com: On 2012-03-10 10:39, I  wrote: I can probably write some docs tomorrow. Attached is v5 of the patch, with is exactly equal to v4 but with added documentation. Thanks for your dedicated volunteer. I'm under checking of the updates at

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Robert Haas
On Sat, Mar 10, 2012 at 4:35 PM, Yeb Havinga yebhavi...@gmail.com wrote: The semantics are muddled because the client labels are mixed with labels from trusted procedures. The stack you described upthread may also exhibit surprising behaviour. If a trusted procedure is called, it's label is

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 10:58 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: It is a practical reason. In case when httpd open the connection to PG and set a suitable security label according to the given credential prior to launch of user application, then keep this connection for upcoming

Re: [HACKERS] psql COPY vs. ON_ERROR_ROLLBACK, multi-command strings

2012-03-12 Thread Alvaro Herrera
Excerpts from Noah Misch's message of jue mar 08 12:11:37 -0300 2012: On Wed, Mar 07, 2012 at 04:57:12PM -0500, Robert Haas wrote: As a side note, the documentation for PQexec() is misleading about what will happen if COPY is present in a multi-command string. It says: Note however

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Kohei KaiGai
2012/3/12 Robert Haas robertmh...@gmail.com: On Mon, Mar 12, 2012 at 10:58 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: It is a practical reason. In case when httpd open the connection to PG and set a suitable security label according to the given credential prior to launch of user

[HACKERS] Partitioning triggers doc patch

2012-03-12 Thread Kevin Grittner
Attached is a doc patch based on a suggestion by Rural Hunter to address something he found confusing while setting up partitioning. Original thread is here: http://archives.postgresql.org/pgsql-admin/2012-03/msg00066.php -Kevin *** a/doc/src/sgml/ddl.sgml --- b/doc/src/sgml/ddl.sgml

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 11:13 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: 2012/3/12 Robert Haas robertmh...@gmail.com: On Mon, Mar 12, 2012 at 10:58 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: It is a practical reason. In case when httpd open the connection to PG and set a suitable security

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Kohei KaiGai
2012/3/12 Robert Haas robertmh...@gmail.com: On Mon, Mar 12, 2012 at 11:13 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: 2012/3/12 Robert Haas robertmh...@gmail.com: On Mon, Mar 12, 2012 at 10:58 AM, Kohei KaiGai kai...@kaigai.gr.jp wrote: It is a practical reason. In case when httpd open the

Re: [HACKERS] wal_buffers, redux

2012-03-12 Thread Jeff Janes
On Sat, Mar 10, 2012 at 7:55 PM, Robert Haas robertmh...@gmail.com wrote: I've finally been able to run some more tests of the effect of adjusting wal_buffers to values higher than 16MB.  I ran the test on the 16 core (x 4 hw threads/core) IBM POWER7 machine, with my usual configuration

Re: [HACKERS] [COMMITTERS] pgfiledump - pg_filedump: Updates for latest Postgres 9.2 sources.

2012-03-12 Thread Alvaro Herrera
Excerpts from tgl's message of lun mar 12 12:08:33 -0400 2012: Log Message: --- Updates for latest Postgres 9.2 sources. We no longer need pg_crc.c, and hence not a source tree, yay. FWIW I had some fun last week compiling this to 9.1 sources because I was using a VPATH build. I had

Re: Scaling XLog insertion (was Re: [HACKERS] Moving more work outside WALInsertLock)

2012-03-12 Thread Jeff Janes
On Fri, Mar 9, 2012 at 2:45 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Thanks! BTW, I haven't forgotten about the recovery bugs Jeff found earlier. I'm planning to do a longer run with his test script - I only run it for about 1000 iterations - to see if I can

Re: [HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Daniel Farina
On Mon, Mar 12, 2012 at 7:52 AM, Tom Lane t...@sss.pgh.pa.us wrote: Will Leinweber w...@heroku.com writes: I created an index on an hstore function, fetchval(hstore, text), however when I use the - infix operator which resolves to the very same function, this index is not used. It should be

[HACKERS] pg_filedump improvements

2012-03-12 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Also, what do you think about adding the ability to dump pg_filenode.map files? Do you think it belongs in pg_filedump, or should we look at doing that elsewhere? Not sure. It does already contain the ability to dump pg_control, but that

Re: [HACKERS] foreign key locks, 2nd attempt

2012-03-12 Thread Robert Haas
On Sun, Feb 26, 2012 at 9:47 PM, Robert Haas robertmh...@gmail.com wrote: Regarding performance, the good thing about this patch is that if you have an operation that used to block, it might now not block.  So maybe multixact-related operation is a bit slower than before, but if it allows you

Re: [HACKERS] Partitioning triggers doc patch

2012-03-12 Thread Jaime Casanova
On Mon, Mar 12, 2012 at 10:41 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Attached is a doc patch based on a suggestion by Rural Hunter to address something he found confusing while setting up partitioning. Original thread is here:

Re: [HACKERS] Partitioning triggers doc patch

2012-03-12 Thread Kevin Grittner
Jaime Casanova ja...@2ndquadrant.com wrote: On Mon, Mar 12, 2012 at 10:41 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Attached is a doc patch based on a suggestion by Rural Hunter to address something he found confusing while setting up partitioning. Original thread is here:

Re: [HACKERS] [v9.2] Add GUC sepgsql.client_label

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 12:30 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote: Suppose that the connection starts out in context connection_pooler_t.  Based on the identity of the user, we transition to foo_t, bar_t, or baz_t.  If it's possible, by any method, for one of those contexts to get back

Re: [HACKERS] foreign key locks, 2nd attempt

2012-03-12 Thread Simon Riggs
On Mon, Mar 12, 2012 at 5:28 PM, Robert Haas robertmh...@gmail.com wrote: In other words, we'd entirely avoid needing to make mxacts crash-safe, and we'd avoid most of the extra SLRU lookups that the current implementation requires; they'd only be needed when (and for as long as) the locked

Re: [HACKERS] wal_buffers, redux

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 12:32 PM, Jeff Janes jeff.ja...@gmail.com wrote: On Nate Boley's machine, the difference was ~100% increase rather than ~10%. Oh, right. I had forgotten how dramatic the changes were in those test runs. I guess I should be happy that the absolute numbers on this

Re: [HACKERS] Partitioning triggers doc patch

2012-03-12 Thread Jaime Casanova
On Mon, Mar 12, 2012 at 12:39 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Do we really want to get into all that in the middle of step-by-step instructions for the simple case? is there any other place we can add a more detailed explanation? so from your text after saying usually

Re: [HACKERS] foreign key locks, 2nd attempt

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 1:50 PM, Simon Riggs si...@2ndquadrant.com wrote: On Mon, Mar 12, 2012 at 5:28 PM, Robert Haas robertmh...@gmail.com wrote: In other words, we'd entirely avoid needing to make mxacts crash-safe, and we'd avoid most of the extra SLRU lookups that the current

Re: [HACKERS] Partitioning triggers doc patch

2012-03-12 Thread Kevin Grittner
Jaime Casanova ja...@2ndquadrant.com wrote: is there any other place we can add a more detailed explanation? so from your text after saying usually there is no reason for you can add a parentesis saying more info in link Sure, I'll look around for a good spot. -Kevin -- Sent via

Re: [HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Tom Lane
Daniel Farina dan...@heroku.com writes: On Mon, Mar 12, 2012 at 7:52 AM, Tom Lane t...@sss.pgh.pa.us wrote: Will Leinweber w...@heroku.com writes: I created an index on an hstore function, fetchval(hstore, text), however when I use the - infix operator which resolves to the very same function,

Re: [HACKERS] foreign key locks, 2nd attempt

2012-03-12 Thread Simon Riggs
On Mon, Mar 12, 2012 at 6:14 PM, Robert Haas robertmh...@gmail.com wrote: Considering that nobody's done any work to resolve the uncertainty about whether the worst-case performance characteristics of this patch are acceptable, and considering further that it was undergoing massive code churn

Re: Scaling XLog insertion (was Re: [HACKERS] Moving more work outside WALInsertLock)

2012-03-12 Thread Heikki Linnakangas
On 09.03.2012 12:04, Heikki Linnakangas wrote: I've been doing some performance testing with this, using a simple C function that just inserts a dummy WAL record of given size. I'm not totally satisfied. Although the patch helps with scalability at 3-4 concurrent backends doing WAL insertions,

Re: [HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Daniel Farina
On Mon, Mar 12, 2012 at 12:22 PM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel Farina dan...@heroku.com writes: On Mon, Mar 12, 2012 at 7:52 AM, Tom Lane t...@sss.pgh.pa.us wrote: Will Leinweber w...@heroku.com writes: I created an index on an hstore function, fetchval(hstore, text), however

Re: [HACKERS] wal_buffers, redux

2012-03-12 Thread Jeff Janes
On Mon, Mar 12, 2012 at 10:55 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, Mar 12, 2012 at 12:32 PM, Jeff Janes jeff.ja...@gmail.com wrote: On Nate Boley's machine, the difference was ~100% increase rather than ~10%. Oh, right.  I had forgotten how dramatic the changes were in those

[HACKERS] GitHub mirror is not updating

2012-03-12 Thread Marti Raudsepp
Hi list, I don't know who's maintaining the PostgreSQL GitHub mirror, but it hasn't been updated for 6 days now: https://github.com/postgres/postgres Just letting you know. Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] GitHub mirror is not updating

2012-03-12 Thread Magnus Hagander
On Mon, Mar 12, 2012 at 21:53, Marti Raudsepp ma...@juffo.org wrote: Hi list, I don't know who's maintaining the PostgreSQL GitHub mirror, but it hasn't been updated for 6 days now: https://github.com/postgres/postgres Just letting you know. Thanks for letting us know. I think it's because

Re: [HACKERS] pg_upgrade --logfile option documentation

2012-03-12 Thread Bruce Momjian
On Thu, Mar 08, 2012 at 08:33:48PM -0500, Bruce Momjian wrote: OK, it seems people do care about keeping log files from multiple runs so I went with Tom's idea and have: - pg_upgrade run on Thu Mar 8 19:30:12 2012

Re: [HACKERS] pg_upgrade and umask

2012-03-12 Thread Bruce Momjian
On Fri, Mar 09, 2012 at 11:33:36AM -0500, Bruce Momjian wrote: On Fri, Mar 09, 2012 at 10:41:53AM -0500, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: The problem is that these files are being created often by shell redirects, e.g. pg_dump -f out 2 log_file. There is no clean

Re: [HACKERS] xlog location arithmetic

2012-03-12 Thread Bruce Momjian
On Fri, Mar 09, 2012 at 03:04:23PM -0500, Tom Lane wrote: The main actual simplification would be in getting rid of the hole at the end of each 4GB worth of WAL, cf this bit in xlog_internal.h: /* * We break each logical log file (xlogid value) into segment files of the * size indicated

Re: [HACKERS] foreign key locks, 2nd attempt

2012-03-12 Thread Noah Misch
On Mon, Mar 12, 2012 at 01:28:11PM -0400, Robert Haas wrote: I spent some time thinking about this over the weekend, and I have an observation, and an idea. Here's the observation: I believe that locking a tuple whose xmin is uncommitted is always a noop, because if it's ever possible for a

[HACKERS] pg_upgrade and statistics

2012-03-12 Thread Daniel Farina
As noted by the manual, pg_statistic is ported in any way when performing pg_upgrade. I have been investigating what it would take to (even via just a connected SQL superuser client running UPDATE or INSERT against pg_statistic) get at least some baseline statistics into the database as quickly

Re: [HACKERS] wal_buffers, redux

2012-03-12 Thread Robert Haas
On Mon, Mar 12, 2012 at 4:45 PM, Jeff Janes jeff.ja...@gmail.com wrote: Do you think the difference is in the CPU architecture, or the IO subsystem? That is an excellent question.  I tried looking at vmstat output, but a funny thing kept happening: periodically, the iowait column would show

Re: [HACKERS] xlog location arithmetic

2012-03-12 Thread Fujii Masao
On Sat, Mar 10, 2012 at 3:23 AM, Robert Haas robertmh...@gmail.com wrote: On Fri, Mar 9, 2012 at 12:38 PM, Magnus Hagander mag...@hagander.net wrote: On Fri, Mar 9, 2012 at 18:18, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Fri, Mar 9, 2012 at 15:37, Tom

Re: [HACKERS] Measuring relation free space

2012-03-12 Thread Noah Misch
On Fri, Mar 09, 2012 at 02:18:02AM -0500, Jaime Casanova wrote: On Wed, Feb 22, 2012 at 12:27 AM, Noah Misch n...@leadboat.com wrote: On Tue, Feb 14, 2012 at 02:04:26AM -0500, Jaime Casanova wrote: 1) pgstattuple-gin_spgist.patch This first patch adds gin and spgist support to

[HACKERS] SPGiST versus hot standby - question about conflict resolution rules

2012-03-12 Thread Tom Lane
There is one more (known) stop-ship problem in SPGiST, which I'd kind of like to get out of the way now before I let my knowledge of that code get swapped out again. This is that SPGiST is unsafe for use by hot standby slaves. The problem comes from redirect tuples, which are short-lifespan

Re: [HACKERS] xlog location arithmetic

2012-03-12 Thread Fujii Masao
On Sat, Mar 10, 2012 at 5:04 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Fri, Mar 9, 2012 at 2:34 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Mar 9, 2012 at 2:26 PM, Tom Lane t...@sss.pgh.pa.us wrote: Hm.  I think thousands is an overestimate,

Re: [HACKERS] xlog location arithmetic

2012-03-12 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: On Sat, Mar 10, 2012 at 5:04 AM, Tom Lane t...@sss.pgh.pa.us wrote: The main actual simplification would be in getting rid of the hole at the end of each 4GB worth of WAL, cf this bit in xlog_internal.h: If we can't get rid of that and have a

Re: [HACKERS] pg_upgrade and statistics

2012-03-12 Thread Bruce Momjian
On Mon, Mar 12, 2012 at 06:38:30PM -0700, Daniel Farina wrote: You probably are going to ask: why not just run ANALYZE and be done with it? The reasons are: * ANALYZE can take a sufficiently long time on large databases that the downtime of switching versions is not attractive * If

Re: [HACKERS] Measuring relation free space

2012-03-12 Thread Jaime Casanova
On Mon, Mar 12, 2012 at 9:41 PM, Noah Misch n...@leadboat.com wrote: I created a CF entry for this and marked it Ready for Committer. i wasn't sure if create an entry this late was a good idea or not... but now i feel better because is less probable that it will fall out on the cracks, thanks

Re: [HACKERS] query planner does not canonicalize infix operators

2012-03-12 Thread Peter Eisentraut
On mån, 2012-03-12 at 13:04 -0700, Daniel Farina wrote: On the more constructive side, if I were to till the fields to change this aspect of the optimizer, is there any interest in rectifying the operator-function confusion? I once proposed to do that [1], but there was not much enthusiasm

Re: [HACKERS] xlog location arithmetic

2012-03-12 Thread Fujii Masao
On Tue, Mar 13, 2012 at 12:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: Fujii Masao masao.fu...@gmail.com writes: On Sat, Mar 10, 2012 at 5:04 AM, Tom Lane t...@sss.pgh.pa.us wrote: The main actual simplification would be in getting rid of the hole at the end of each 4GB worth of WAL, cf this bit

Re: [HACKERS] initdb and fsync

2012-03-12 Thread Jeff Davis
initdb-fsync-20120312.patch.gz Description: GNU Zip compressed data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] pg_upgrade and statistics

2012-03-12 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Copying the statistics from the old server is on the pg_upgrade TODO list. I have avoided it because it will add an additional requirement that will make pg_upgrade more fragile in case of major version changes. Does anyone have a sense of how often we

Re: Scaling XLog insertion (was Re: [HACKERS] Moving more work outside WALInsertLock)

2012-03-12 Thread Fujii Masao
On Tue, Mar 13, 2012 at 1:59 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Fri, Mar 9, 2012 at 2:45 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Thanks! BTW, I haven't forgotten about the recovery bugs Jeff found earlier. I'm planning to do a longer run with his test