Re: [HACKERS] Which table stored in which file in PGDATA/base/[db-oid]

2013-06-02 Thread Soroosh Sardari
On Sat, Jun 1, 2013 at 3:57 PM, Andres Freund and...@2ndquadrant.comwrote: On 2013-06-01 13:04:55 +0200, Martijn van Oosterhout wrote: On Sat, Jun 01, 2013 at 03:27:40PM +0430, Soroosh Sardari wrote: Yes, I have some files which is not in pg_class.relfilenode of any table or index. I

Re: [HACKERS] Optimising Foreign Key checks

2013-06-02 Thread Simon Riggs
On 1 June 2013 21:27, Noah Misch n...@leadboat.com wrote: On Sat, Jun 01, 2013 at 09:41:13AM +0100, Simon Riggs wrote: FK checks can be expensive, especially when loading large volumes of data into an existing table or partition. A couple of ideas for improving performance are discussed here:

Re: [HACKERS] Deferring transaction wraparound

2013-06-02 Thread Simon Riggs
On 1 June 2013 09:22, Simon Riggs si...@2ndquadrant.com wrote: A much better idea is to hold the xmin epoch on the tuple, in addition to the xid, if there was a good place to hold this. This idea is an almost exact duplicate of Heikki Linnakangas' idea for exactly the same problem. Given

Re: [HACKERS] PostgreSQL 9.3 beta breaks some extensions make install

2013-06-02 Thread Cédric Villemain
Le mardi 28 mai 2013 14:10:14, Cédric Villemain a écrit : I just took time to inspect our contribs, USE_PGXS is not supported by all of them atm because of SHLIB_PREREQS (it used submake) I have a patch pending here to fix that. Attached patch fix SHLIB_PREREQS when building with USE_PGXS

Re: [HACKERS] PostgreSQL 9.3 beta breaks some extensions make install

2013-06-02 Thread Cédric Villemain
Le mardi 28 mai 2013 15:15:55, Cédric Villemain a écrit : Le samedi 25 mai 2013 16:41:24, Cédric Villemain a écrit : If it seems to be on the right way, I'll keep fixing EXTENSION building with VPATH. I haven't tried the patch, but let me just say that Debian (and

Re: [HACKERS] [PATCH] pg_isready (was: [WIP] pg_ping utility)

2013-06-02 Thread Fujii Masao
Sorry for the delay in responding to you. On Mon, Feb 11, 2013 at 6:03 AM, Phil Sorber p...@omniti.com wrote: On Fri, Feb 8, 2013 at 1:07 PM, Phil Sorber p...@omniti.com wrote: On Fri, Feb 8, 2013 at 12:46 PM, Fujii Masao masao.fu...@gmail.com wrote: No maybe. But I think that all the client

[HACKERS] Vacuum, Freeze and Analyze: the big picture

2013-06-02 Thread Jeff Janes
On Saturday, June 1, 2013, Robert Haas wrote: I agree with all that. I don't have any data either, but I agree that AFAICT it seems to mostly be a problem for large (terabyte-scale) databases, or ones that are dreadfully short of I/O bandwidth. AWS, I'm looking at you. It would be

Re: [HACKERS] pg_dump with postgis extension dumps rules separately

2013-06-02 Thread Dimitri Fontaine
Tom Lane t...@sss.pgh.pa.us writes: Actually, I believe the answer is just that getSchemaData() is doing things in the wrong order: Each time I have to look at the pg_dump parts I discover new things. I've been misleading Joe in telling him I though the problem must have been in extension

Re: [HACKERS] Vacuum, Freeze and Analyze: the big picture

2013-06-02 Thread Robert Haas
On Sun, Jun 2, 2013 at 2:44 PM, Jeff Janes jeff.ja...@gmail.com wrote: Do we know why anti-wraparound uses so many resources in the first place? The default settings seem to be quite conservative to me, even for a system that has only a single 5400 rpm hdd (and even more so for any real

[HACKERS] Perl 5.18 breaks pl/perl regression tests?

2013-06-02 Thread Tom Lane
Buildfarm member anchovy has been failing the pl/perl regression tests for the last 11 days. Since configure is helpful enough to print the version number of the Perl it finds, we can see that anchovy's Perl version was 5.16.3 in its last successful run, but it's been using 5.18.0 in all the

Re: [HACKERS] Perl 5.18 breaks pl/perl regression tests?

2013-06-02 Thread Michael Paquier
On Mon, Jun 3, 2013 at 11:29 AM, Tom Lane t...@sss.pgh.pa.us wrote: Can anyone else replicate this change of behavior? Yes. I could reproduce that on an Archlinux box after updating to perl 1.8.0. hamster might also fail with the same error, I just updated its perl from 1.6.3 to 1.8.0. Is