Re: [HACKERS] clog_redo causing very long recovery time

2011-05-06 Thread Joe Conway
On 05/05/2011 09:00 PM, Tom Lane wrote: Joe Conway m...@joeconway.com writes: Right -- I think another similar problem exists in GetNewMultiXactId where ExtendMultiXactOffset could succeed and write an XLOG entry and then ExtendMultiXactMember could fail before advancing nextMXact. The

Re: [HACKERS] GSoC 2011: Fast GiST index build

2011-05-06 Thread Teodor Sigaev
As I understood it's because we can't move root to another page. Actually not. Path to node could change completely, For example, for page on second level path is 0-234 (where 0 is a root page, 234 is a page on second level). After root split path will be 0-new_page-234. If algorithm could

[HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Josh Berkus
Hackers, I've run into a couple of occasions lately where I really wanted pgstattuple on a production server in order to check table/index bloat. However, in the production environment at a large site installing a contrib module can involve a process which takes days or weeks. Is there some

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Magnus Hagander
On Fri, May 6, 2011 at 00:34, Josh Berkus josh.ber...@pgexperts.com wrote: Hackers, I've run into a couple of occasions lately where I really wanted pgstattuple on a production server in order to check table/index bloat.  However, in the production environment at a large site installing a

Re: [HACKERS] GSoC 2011: Fast GiST index build

2011-05-06 Thread Alexander Korotkov
2011/5/6 Teodor Sigaev teo...@sigaev.ru As I understood it's because we can't move root to another page. Actually not. Path to node could change completely, For example, for page on second level path is 0-234 (where 0 is a root page, 234 is a page on second level). After root split path

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-05-06 Thread Heikki Linnakangas
On 30.04.2011 01:04, Kevin Grittner wrote: TRUNCATE TABLE and DROP TABLE should generate a rw-conflict *in* to the enclosing transaction (if it is serializable) from all transactions holding predicate locks on the table or its indexes. Note that this could cause a transactions which is running

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-05-06 Thread Kevin Grittner
Heikki Linnakangas wrote: On 30.04.2011 01:04, Kevin Grittner wrote: TRUNCATE TABLE and DROP TABLE should generate a rw-conflict *in* to the enclosing transaction (if it is serializable) from all transactions holding predicate locks on the table or its indexes. Note that this could cause a

Re: [HACKERS] Process wakeups when idle and power consumption

2011-05-06 Thread Peter Geoghegan
On 5 May 2011 21:05, Tom Lane t...@sss.pgh.pa.us wrote: The major problem I'm aware of for getting rid of periodic wakeups is the need for child processes to notice when the postmaster has died unexpectedly.  Your patch appears to degrade the archiver's response time for that really

Re: [HACKERS] Backpatching of Teach the regular expression functions to do case-insensitive matching

2011-05-06 Thread Andres Freund
On Friday, May 06, 2011 04:30:01 AM Robert Haas wrote: On Thu, May 5, 2011 at 5:21 AM, Andres Freund and...@anarazel.de wrote: In my opinion this is actually a bug in 9.0. As its a (imo) low impact fix thats constrained to two files it seems sensible to backpatch it now that the solution

Re: [HACKERS] Process wakeups when idle and power consumption

2011-05-06 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: On 5 May 2011 21:05, Tom Lane t...@sss.pgh.pa.us wrote: The major problem I'm aware of for getting rid of periodic wakeups is the need for child processes to notice when the postmaster has died unexpectedly. Could you please expand upon this? Why

[HACKERS] Buildfarm client 4.5 released

2011-05-06 Thread Andrew Dunstan
I have just released version 4.5 of the buildfarm client. Notable features and improvements include: * Suppport for building docs * Support running optional steps * Make SCM module totally generic so it can be used for things other than PostgreSQL core. * Run isolation checks.

Re: [HACKERS] Process wakeups when idle and power consumption

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 8:16 AM, Peter Geoghegan pe...@2ndquadrant.com wrote: Could you please expand upon this? Why is it of any consequence if the archiver notices that the postmaster is dead after 60 seconds rather than after 1? So control in the archiver is going to stay in its event loop

Re: [HACKERS] Process wakeups when idle and power consumption

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 10:13 AM, Robert Haas robertmh...@gmail.com wrote: On Fri, May 6, 2011 at 8:16 AM, Peter Geoghegan pe...@2ndquadrant.com wrote: Could you please expand upon this? Why is it of any consequence if the archiver notices that the postmaster is dead after 60 seconds rather

Re: [HACKERS] Visibility map and hint bits

2011-05-06 Thread Merlin Moncure
On Thu, May 5, 2011 at 2:20 PM, Merlin Moncure mmonc...@gmail.com wrote: On Thu, May 5, 2011 at 2:00 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Merlin Moncure mmonc...@gmail.com wrote: a small cache that remembers the commit/cancel status of recently seen transactions. How is

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Euler Taveira de Oliveira
Em 06-05-2011 05:06, Magnus Hagander escreveu: On Fri, May 6, 2011 at 00:34, Josh Berkusjosh.ber...@pgexperts.com wrote: Hackers, I've run into a couple of occasions lately where I really wanted pgstattuple on a production server in order to check table/index bloat. However, in the

[HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011-05-06 Thread Krešimir Križanović
First, I want to apologize if this is a topic for one of the other mailing lists (or completely inappropriate for PostgreSQL mailing lists), but I looked them over, and this one seemed most appropriate. I am working on a project based on TelegraphCQ 2.1

Re: [HACKERS] Debug contrib/cube code

2011-05-06 Thread Euler Taveira de Oliveira
Em 06-05-2011 02:14, Nick Raj escreveu: I am using postgresql-8.4.6. I want to debug the contrib/cube code. Can we able to debug that cube code? Because there is no .configure file to enable debug. Is there is any way to change make file to enable debug? What do you want to debug? AFAICS you

Re: [HACKERS] increasing collapse_limits?

2011-05-06 Thread Jan Urbański
On 01/05/11 21:16, Joshua Berkus wrote: Speaking of which, what happened to replacing GEQO with Simulated Annealing? Where did that project go? It stayed on github (https://github.com/wulczer/saio) and stagnated a bit after I got my degree. It's on the top of my list of things to pick up

Re: [HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011-05-06 Thread Christopher Browne
2011/5/6 Krešimir Križanović kresimir.krizano...@fer.hr: I don't know what to do with this backend interface. I would like to get a postmaster running and to connect to a data base with psql. However, when i try to start psql, it says that there is no postmaster running. I would not assume

Re: [HACKERS] Re: Why is RegisterPredicateLockingXid called while holding XidGenLock?

2011-05-06 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane wrote: Yeah, I was thinking that it'd be better to pull it out of GetNewTransactionId and put it in a higher level. As long as it is always called when an xid is assigned. Since this function appears to be on the only path to

Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-06 Thread Mitsuru IWASAKI
Hi, I revised the patch against HEAD, it's available at: http://people.freebsd.org/~iwasaki/postgres/buffer-cache-hibernation-postgresql-20110506.patch Implemented hibernation file validations: - comparison with pg_control At shutdown: pg_control state should be DB_SHUTDOWNED. At startup

Re: [HACKERS] Re: Why is RegisterPredicateLockingXid called while holding XidGenLock?

2011-05-06 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: After some thought I did this instead: Thanks! I can see why that's better. -Kevin -- 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] Why not install pgstattuple by default?

2011-05-06 Thread Magnus Hagander
On Fri, May 6, 2011 at 18:22, Euler Taveira de Oliveira eu...@timbira.com wrote: Em 06-05-2011 05:06, Magnus Hagander escreveu: On Fri, May 6, 2011 at 00:34, Josh Berkusjosh.ber...@pgexperts.com  wrote: Hackers, I've run into a couple of occasions lately where I really wanted pgstattuple

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Christopher Browne
On Fri, May 6, 2011 at 1:32 PM, Magnus Hagander mag...@hagander.net wrote: On Fri, May 6, 2011 at 18:22, Euler Taveira de Oliveira eu...@timbira.com wrote: Em 06-05-2011 05:06, Magnus Hagander escreveu: On Fri, May 6, 2011 at 00:34, Josh Berkusjosh.ber...@pgexperts.com  wrote: Hackers,

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Andrew Dunstan
On 05/06/2011 01:55 PM, Christopher Browne wrote: Once we got AIX running a buildfarm node, that led to getting *ALL* of contrib working there, and I'm pretty sure that similar happened with other platforms at around the same time (I'm thinking this was 7.4, but it might have been 8.0) FYI,

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Euler Taveira de Oliveira
Em 06-05-2011 14:55, Christopher Browne escreveu: The improvement would come from drawing contrib a bit closer to core, and encouraging packagers (dpkg, rpm, ports) to fold contrib into base rather than separating it. I'm sure that would get some pushback, though. I'm in favor of find out

Re: [HACKERS] [CORE] list of members for CA nonprofit

2011-05-06 Thread Josh Berkus
On a not unrelated point, I still haven't seen any mention of this deal in pgsql-hackers, and I really think that presenting it to them as a fait accompli would be a Seriously Bad Idea. I wanted a list of initial board members before I presented it. -- Josh Berkus PostgreSQL Experts Inc.

Re: [HACKERS] [CORE] list of members for CA nonprofit

2011-05-06 Thread Josh Berkus
On 5/6/11 11:29 AM, Josh Berkus wrote: On a not unrelated point, I still haven't seen any mention of this deal in pgsql-hackers, and I really think that presenting it to them as a fait accompli would be a Seriously Bad Idea. I wanted a list of initial board members before I presented it.

Re: [HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011-05-06 Thread Greg Smith
Krešimir Križanović wrote: However, where I compile and run the project, in the Eclipse console I get: POSTGRES backend interactive interface $Revision: 1.115 $ $Date: 2006/02/06 01:19:46 $ I don’t know what to do with this backend interface. I would like to get a postmaster running and

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Greg Smith
Christopher Browne wrote: I'm getting paper cuts quite a bit these days over the differences between what different packaging systems decide to install. The one *I* get notably bit on, of late, is that I have written code that expects to have pg_config to do some degree of self-discovery, only

[HACKERS] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Josh Berkus
Hackers, Community members: As some of you already know, several important community assets are held in the personal name of Marc Fournier for historical reasons. These assets include several DNS domains (including postgresql.org), our SSL key, and a Canadian trademark, and possibly a server as

[HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Gilberto Castillo Martínez
Josh, This would imply improvement in the terms of the U.S. embargo on Cuba. What would be real beneficial to all regional communities. -- Saludos, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Etecsa. Miramar, La Habana.Cuba. --- This message was processed by Kaspersky Mail

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Christopher Browne
On Fri, May 6, 2011 at 2:32 PM, Greg Smith g...@2ndquadrant.com wrote: Christopher Browne wrote: I'm getting paper cuts quite a bit these days over the differences between what different packaging systems decide to install.  The one *I* get notably bit on, of late, is that I have written code

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Andrew Dunstan
On 05/06/2011 03:14 PM, Christopher Browne wrote: On Fri, May 6, 2011 at 2:32 PM, Greg Smithg...@2ndquadrant.com wrote: Christopher Browne wrote: I'm getting paper cuts quite a bit these days over the differences between what different packaging systems decide to install. The one *I* get

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Magnus Hagander
On Fri, May 6, 2011 at 21:19, Andrew Dunstan and...@dunslane.net wrote: On 05/06/2011 03:14 PM, Christopher Browne wrote: On Fri, May 6, 2011 at 2:32 PM, Greg Smithg...@2ndquadrant.com  wrote: Christopher Browne wrote: I'm getting paper cuts quite a bit these days over the differences

[HACKERS] pg_upgrade's bindir options could be optional

2011-05-06 Thread Peter Eisentraut
Just a thought: To make things a bit easier, the bindir options of pg_upgrade (-b/-B, --old-bindir/--new-bindir) could be made optional, I think. The new bindir should normally be the one that pg_upgrade itself is in. And the old bindir could be found out by looking at the postmaster.opts file

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Christopher Browne
On Fri, May 6, 2011 at 3:01 PM, Gilberto Castillo Martínez gilberto.casti...@etecsa.cu wrote: Josh, This would imply improvement in the terms of the U.S. embargo on Cuba. What would be real beneficial to all regional communities. I wouldn't get overly optimistic about that - the purpose of

Re: [HACKERS] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 2:41 PM, Josh Berkus j...@agliodbs.com wrote: We have, however, come up with a potential plan to change this.  Marc has agreed to transfer the community assets to a new Canadian nonprofit which we set up for the purpose.  The PostgreSQL Core Team supports this solution,

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Andrew Dunstan
On 05/06/2011 03:30 PM, Christopher Browne wrote: If the corporation became *really active* in extra senses (e.g. - handling donations, operating events), that would add some Canadian activity that doesn't exist today, but it's not clear that it would necessarily get really active that way.

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Tom Lane
Christopher Browne cbbro...@gmail.com writes: On Fri, May 6, 2011 at 3:01 PM, Gilberto Castillo Martínez gilberto.casti...@etecsa.cu wrote: This would imply improvement in the terms of the U.S. embargo on Cuba. I wouldn't get overly optimistic about that - the purpose of this is a bit less

[HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Cédric Villemain
2011/5/6 Josh Berkus j...@agliodbs.com: Hackers, Community members: As some of you already know, several important community assets are held in the personal name of Marc Fournier for historical reasons.  These assets include several DNS domains (including postgresql.org), our SSL key, and a

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Fri, May 6, 2011 at 21:19, Andrew Dunstan and...@dunslane.net wrote: On 05/06/2011 03:14 PM, Christopher Browne wrote: If there's a server package and a client package, it likely only fits with the server package.  On a host where only the client

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Andrew Dunstan
On 05/06/2011 04:06 PM, Tom Lane wrote: Magnus Hagandermag...@hagander.net writes: On Fri, May 6, 2011 at 21:19, Andrew Dunstanand...@dunslane.net wrote: On 05/06/2011 03:14 PM, Christopher Browne wrote: If there's a server package and a client package, it likely only fits with the server

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Alvaro Herrera
Excerpts from Darren Duncan's message of mié may 04 15:33:33 -0300 2011: I see VARIANT/ANYTYPE as the most general case of supporting union types, which, say, could have more specific examples of allow any number or date here but nothing else. If VARIANT is supported, unions in general

Re: [HACKERS] pg_upgrade's bindir options could be optional

2011-05-06 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: Just a thought: To make things a bit easier, the bindir options of pg_upgrade (-b/-B, --old-bindir/--new-bindir) could be made optional, I think. The new bindir should normally be the one that pg_upgrade itself is in. And the old bindir could be found

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Andrew Dunstan
On 05/06/2011 04:08 PM, Alvaro Herrera wrote: Excerpts from Darren Duncan's message of mié may 04 15:33:33 -0300 2011: I see VARIANT/ANYTYPE as the most general case of supporting union types, which, say, could have more specific examples of allow any number or date here but nothing else.

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Darren Duncan's message of mié may 04 15:33:33 -0300 2011: I see VARIANT/ANYTYPE as the most general case of supporting union types, which, say, could have more specific examples of allow any number or date here but nothing

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Merlin Moncure
On Fri, May 6, 2011 at 3:18 PM, Andrew Dunstan and...@dunslane.net wrote: On 05/06/2011 04:08 PM, Alvaro Herrera wrote: Excerpts from Darren Duncan's message of mié may 04 15:33:33 -0300 2011: I see VARIANT/ANYTYPE as the most general case of supporting union types, which, say, could have

Re: [HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011-05-06 Thread Krešimir Križanović
Thanks for the help, that is the problem I think. However, I didn’t manage to test it yet. When I compile the project in Eclipse, I get postgres executable, but not the postmaster. I found somewhere on the net that postmaster and postgres are actually the same program, and when Install

Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-06 Thread Greg Smith
On 05/05/2011 05:06 AM, Mitsuru IWASAKI wrote: In summary, PgFincore's target is File System Buffer Cache, Buffer Cache Hibernation's target is DB Buffer Cache(shared buffers). Right. The thing to realize is that shared_buffers is becoming a smaller fraction of the total RAM used by the

Re: [HACKERS] Prefered Types

2011-05-06 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié may 04 17:14:25 -0300 2011: Robert Haas robertmh...@gmail.com writes: It's not clear to me whether in any of this there is a solution to the problem of int2 being a second-class citizen. I've always felt that the basic problem int2 has got is that

[HACKERS] crash-safe visibility map, take five

2011-05-06 Thread Robert Haas
On Wed, Mar 30, 2011 at 8:52 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Another question: To address the problem in http://archives.postgresql.org/pgsql-hackers/2010-02/msg02097.php , should we just clear the vm before the log of insert/update/delete? This may reduce

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Tom Lane
Christopher Browne cbbro...@gmail.com writes: But people are evidently still setting packaging policies based on how things were back in 7.3, even though that perhaps isn't necessary anymore. FWIW, once you get past the client versus server distinction, I think most subpackaging decisions are

Re: [HACKERS] Prefered Types

2011-05-06 Thread Robert Haas
2011/5/4 Tom Lane t...@sss.pgh.pa.us: Perhaps it would be adequate to allow automatic resolution of an overloading conflict only when one of the available alternatives dominates all others, ie, none of the argument positions requires a longer distance cast than is used in that position by any

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Darren Duncan
Thanks for picking up on my mentioning union types; I wasn't sure if anyone did. Merlin Moncure wrote: On Fri, May 6, 2011 at 3:18 PM, Andrew Dunstan and...@dunslane.net wrote: On 05/06/2011 04:08 PM, Alvaro Herrera wrote: Excerpts from Darren Duncan's message of mié may 04 15:33:33 -0300

Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 5:31 PM, Greg Smith g...@2ndquadrant.com wrote: On 05/05/2011 05:06 AM, Mitsuru IWASAKI wrote: In summary, PgFincore's target is File System Buffer Cache, Buffer Cache Hibernation's target is DB Buffer Cache(shared buffers). Right.  The thing to realize is that

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Josh Berkus
All, We might get somewhere by trying to identify a small set of particularly popular contrib modules that don't add any extra dependencies, and then recommending to packagers that those ones get bundled into the main server package. Yeah, I wasn't thinking of including all of contrib.

Re: [HACKERS] Prefered Types

2011-05-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: 2011/5/4 Tom Lane t...@sss.pgh.pa.us: Perhaps it would be adequate to allow automatic resolution of an overloading conflict only when one of the available alternatives dominates all others, ie, none of the argument positions requires a longer distance

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 5:58 PM, Josh Berkus j...@agliodbs.com wrote: Yeah, I wasn't thinking of including all of contrib.  There's a lot of reasons not to do that. Slightly off-topic, but I really think we would benefit from trying to divide up contrib. Right now it's a mixture of (a)

Re: [HACKERS] VARIANT / ANYTYPE datatype

2011-05-06 Thread Darren Duncan
To follow-up, an additional feature that would be useful and resembles union types is the variant where you could declare a union type first and then separately other types could declare they are a member of the union. I'm talking about loosely what mixins or type-roles or interfaces etc are

Re: [HACKERS] Prefered Types

2011-05-06 Thread Robert Haas
2011/5/6 Tom Lane t...@sss.pgh.pa.us: Robert Haas robertmh...@gmail.com writes: 2011/5/4 Tom Lane t...@sss.pgh.pa.us: Perhaps it would be adequate to allow automatic resolution of an overloading conflict only when one of the available alternatives dominates all others, ie, none of the

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Greg Smith
On 05/06/2011 05:58 PM, Josh Berkus wrote: Yeah, I wasn't thinking of including all of contrib. There's a lot of reasons not to do that. I was asking about pgstattuple in particular, since it's: (a) small (b) has no external dependancies (c) adds no stability risk or performance overhead (d) is

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Fri, May 6, 2011 at 5:58 PM, Josh Berkus j...@agliodbs.com wrote: Yeah, I wasn't thinking of including all of contrib.  There's a lot of reasons not to do that. Slightly off-topic, but I really think we would benefit from trying to divide up

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Josh Berkus
On 5/6/11 3:19 PM, Robert Haas wrote: Slightly off-topic, but I really think we would benefit from trying to divide up contrib. I don't agree, unless by divide up you mean move several things to extensions. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Josh Berkus
These are the only ones I'd care about moving into a more likely place. The rest of the contrib modules are the sort where if you need them, you realize that early and get them installed. These are different by virtue of their need popping up most often during emergencies. The fact that I

[HACKERS] Fix incorrect description at SECURITY LABEL documentation

2011-05-06 Thread Kohei KaiGai
I found a few misdescriptions at SECURITY LABEL documentation. It might come from the COMMENT ON page. The attached patch will fix them. Thanks, -- KaiGai Kohei kai...@kaigai.gr.jp pgsql-fix-security-label-doc.patch Description: Binary data -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011-05-06 Thread Josh Berkus
Kresimir, Concerning TelegraphCQ, my aim is to add geospatial capabilities, to actually merge it with PostGIS. Its a part of my PhD Thesis. Hmmm. Given that the TCQ code was never production quality in the first place (i.e. crashed every 60 minutes), this seems like kind of a futile

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Greg Stark
On Fri, May 6, 2011 at 11:32 PM, Greg Smith g...@2ndquadrant.com wrote: I use pgstattuple, pageinspect, pg_freespacemap, and pg_buffercache regularly enough that I wish they were more common.  Throw in pgrowlocks and you've got the whole group Robert put into the debug set.  It makes me sad

Re: [HACKERS] pg_upgrade's bindir options could be optional

2011-05-06 Thread Alvaro Herrera
Excerpts from Tom Lane's message of vie may 06 17:11:35 -0300 2011: As an example, the proposed defaults would be not only wrong, but disastrous in the perfectly-reasonable situation where the user has moved the old installation aside and then installed the new executables in the same place

Re: [HACKERS] [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

2011-05-06 Thread Alvaro Herrera
Excerpts from Josh Berkus's message of vie may 06 15:41:02 -0300 2011: We have, however, come up with a potential plan to change this. Marc has agreed to transfer the community assets to a new Canadian nonprofit which we set up for the purpose. The PostgreSQL Core Team supports this

Re: [HACKERS] patch for new feature: Buffer Cache Hibernation

2011-05-06 Thread Mitsuru IWASAKI
Hi, thanks for your comments! I'm glad to discuss about this topic. * pgfadv_WILLNEED * pgfadv_WILLNEED_snapshot The former ask to load each segment of a relation *but* the kernel can decide to not do that or load only part of each segment. (so it is not as brutal as cat file /dev/null

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 6:47 PM, Tom Lane t...@sss.pgh.pa.us wrote: As a packager, what I'd really want to see from a division into recommended and not-so-recommended packages is that they get installed into different subdirectories by make install.  Then I could just point RPM at those

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Fri, May 6, 2011 at 6:47 PM, Tom Lane t...@sss.pgh.pa.us wrote: As a packager, what I'd really want to see from a division into recommended and not-so-recommended packages is that they get installed into different subdirectories by make install.

Re: [HACKERS] Fix incorrect description at SECURITY LABEL documentation

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 6:55 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote: I found a few misdescriptions at SECURITY LABEL documentation. It might come from the COMMENT ON page. The attached patch will fix them. Good catch. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [HACKERS] Why not install pgstattuple by default?

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 9:17 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Fri, May 6, 2011 at 6:47 PM, Tom Lane t...@sss.pgh.pa.us wrote: As a packager, what I'd really want to see from a division into recommended and not-so-recommended packages is that

Re: [HACKERS] patch: fix race in SSI's CheckTargetForConflictsIn

2011-05-06 Thread Robert Haas
On Thu, May 5, 2011 at 1:43 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Dan Ports d...@csail.mit.edu wrote: While running some benchmarks to test SSI performance, I found a race condition that's capable of causing a segfault. A patch is attached. The bug is in

Re: [HACKERS] kill -KILL: What happens?

2011-05-06 Thread Robert Haas
On Sat, Jan 15, 2011 at 10:44 AM, Florian Pflug f...@phlo.org wrote: On Jan14, 2011, at 17:45 , Robert Haas wrote: On Fri, Jan 14, 2011 at 11:28 AM, Florian Pflug f...@phlo.org wrote: I gather that the behaviour we want is for normal backends to exit once the postmaster is gone, and for

Re: [HACKERS] (Better) support for cross compiled external modules

2011-05-06 Thread Robert Haas
On Mon, May 2, 2011 at 10:41 AM, Johann 'Myrkraverk' Oskarsson joh...@2ndquadrant.com wrote: Hi all, Is it possible to add support for cross compiled PGXS modules to the build system? That is, when PG is cross compiled, a host-triplet-pg_config is also built for use with external modules?

Re: [HACKERS] new AM, best way to obtain new block at end of index?

2011-05-06 Thread Robert Haas
On Thu, Apr 28, 2011 at 8:03 AM, Yves Weißig weis...@rbg.informatik.tu-darmstadt.de wrote: Hi list, currently I am obtaining a new block at the end of an index with: buf = ReadBuffer(rel, P_NEW); but it throws: ERROR:  unexpected data beyond EOF in block 0 of relation base/11874/156053

Re: [HACKERS] SSI non-serializable UPDATE performance

2011-05-06 Thread Robert Haas
On Fri, Apr 29, 2011 at 3:23 AM, Dan Ports d...@csail.mit.edu wrote: On Thu, Apr 28, 2011 at 06:45:54PM +0200, Robert Haas wrote: Yeah, I think Dan's notes about memory ordering would be good to include. I left it out initially because I didn't want to make things more confusing. As far as

Re: [HACKERS] a bit more precise MaxOffsetNumber

2011-05-06 Thread Robert Haas
2011/4/30 Tomas Vondra t...@fuzzy.cz: I've been digging in the sources, and I've noticed the MaxOffsetNumber is defined (in storage/off.h) like this  (BLCKSZ / sizeof(ItemIdData)) I guess it might be made a bit more precise by subtracting the header like this  (BLCKSZ -

Re: [HACKERS] Large Objects versus transactional behavior

2011-05-06 Thread Robert Haas
On Sat, Apr 30, 2011 at 2:58 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: This is related to the SIREAD lock versus ACCESS EXCLUSIVE lock thread, but seemed different enough to merit spinning off a new thread. Our shop hasn't used large objects so far because of the lack of security

Re: [HACKERS] switch UNLOGGED to LOGGED

2011-05-06 Thread Robert Haas
On Fri, Apr 22, 2011 at 4:13 AM, Leonardo Francalanci m_li...@yahoo.it wrote: Maybe you should change  xl_act_commit to have a separate list of rels to drop the init fork for  (instead of mixing those with the list of files to drop as a  whole). I tried to follow your suggestion, thank you

Re: [HACKERS] switch UNLOGGED to LOGGED

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 10:25 PM, Robert Haas robertmh...@gmail.com wrote: ERROR:  constraints on permanent tables may reference only permanent tables HINT:  constraint %s Argh, hit send too soon. HINT: constraint %s references table %s -- Robert Haas EnterpriseDB: http://www.enterprisedb.com

Re: [HACKERS] GSoC 2011 - New phpPgAdmin Plugin Architecture

2011-05-06 Thread Robert Haas
On Tue, Apr 26, 2011 at 12:39 PM, Leonardo Sápiras sapi...@faccat.br wrote:  A copy of my proposal can be found at [http://fit.faccat.br/~leonardo/gsoc_proposal.html]. But I will put a copy of this in another place. So, what would be better? Put on the PostgreSQL Wiki

Re: [HACKERS] Backpatching of Teach the regular expression functions to do case-insensitive matching

2011-05-06 Thread Robert Haas
On Fri, May 6, 2011 at 9:22 AM, Andres Freund and...@anarazel.de wrote: On Friday, May 06, 2011 04:30:01 AM Robert Haas wrote: On Thu, May 5, 2011 at 5:21 AM, Andres Freund and...@anarazel.de wrote: In my opinion this is actually a bug in 9.0. As its a (imo) low impact fix thats constrained

Re: [HACKERS] patch: fix race in SSI's CheckTargetForConflictsIn

2011-05-06 Thread Dan Ports
On Fri, May 06, 2011 at 09:35:39PM -0400, Robert Haas wrote: Why does this HASH_FIND the applicable hash table entries and then HASH_REMOVE it as a separate step, instead of just HASH_REMOVE-ing it in one go? For PredicateLockHash, we need to find the lock entry first so that we can call

Re: [HACKERS] improvements to pgtune

2011-05-06 Thread Shiv
Hi Greg, So my exams are over now and am fully committed to the project in terms of time. I have started compiling a sort of personal todo for myself. I agree with your advice to start the project with small steps first. (I have a copy of the code and am trying to glean as much of it as I can) I