Re: [HACKERS] [pgsql-cluster-hackers] 3rd Cluster Hackers Summit, May 15th in Ottawa

2012-02-26 Thread Simon Riggs
On Sun, Feb 12, 2012 at 8:33 PM, Joshua Berkus j...@agliodbs.com wrote: = Project Reports: 5 minutes from each project   * Hot Standby/Binary Replication   * pgPoolII   * PostgresXC   * Your Project Here I'd like some time to discuss my new project: Bi-Directional Replication for Core. I

Re: [HACKERS] ISO8601 nitpicking

2012-02-26 Thread Peter Eisentraut
On fre, 2012-02-24 at 10:40 -0800, Daniel Farina wrote: On Fri, Feb 24, 2012 at 4:45 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2012-02-23 at 23:41 -0800, Daniel Farina wrote: As it turns out, evidence would suggests that the ISO output in Postgres isn't, unless there's an ISO

Re: [HACKERS] leakproof

2012-02-26 Thread Peter Eisentraut
On fre, 2012-02-24 at 23:00 -0500, Noah Misch wrote: I also liked Kevin's suggestion of DISCREET That would probably create too much confusion with discrete. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Triggers with DO functionality

2012-02-26 Thread Peter Eisentraut
On fre, 2012-02-24 at 13:55 -0600, Kevin Grittner wrote: By default, a trigger function runs as the table owner, ie it's implicitly SEC DEF to the table owner. Really? That's certainly what I would *want*, but it's not what I've seen. Yes, you're right, that was my recollection as

[HACKERS] check constraint validation takes access exclusive locks

2012-02-26 Thread Pavel Stehule
Hello I rechecked Depesz's article - http://www.depesz.com/2011/07/01/waiting-for-9-2-not-valid-checks/ The behave of current HEAD is different than behave described in article. alter table a validate constraint a_a_check needs a access exclusive locks and blocks table modification - I tested

Re: [HACKERS] Command Triggers, patch v11

2012-02-26 Thread Dimitri Fontaine
Thanks for your further testing! Thom Brown t...@linux.com writes: Further testing reveals a problem with FTS configurations when using the example function provided in the docs: Could you send me your tests so that I add them to the proper regression test? I've been lazy on one or two object

[HACKERS] WARNING: concurrent insert in progress within table resource

2012-02-26 Thread Pavel Stehule
Hello I tested creating some larger indexes There was a warning: postgres=# CREATE INDEX idx_resource_name ON resource (name, tid); WARNING: concurrent insert in progress within table resource I am sure so there was only one active session - so this warning is strange. postgres=# select

Re: [HACKERS] Runtime SHAREDIR for testing CREATE EXTENSION

2012-02-26 Thread Peter Eisentraut
On lör, 2012-02-25 at 14:21 +0100, Christoph Berg wrote: Well, I'm trying to invoke the extension's make check target at extension build time. I do have a temporary installation I own somehwere in my $HOME, but that is still trying to find extensions in

Re: [HACKERS] leakproof

2012-02-26 Thread Peter Eisentraut
On ons, 2012-02-22 at 10:56 -0500, Andrew Dunstan wrote: The trouble with leakproof is that it doesn't point to what it is that's not leaking, which is information rather than memory, as many might imagine (and I did) without further hints. I'm not sure any single English word would be as

Re: [HACKERS] How to know a table has been modified?

2012-02-26 Thread Kevin Grittner
Tatsuo Ishii wrote: For TRIGGER, I cannot thinking of any way. Any idea will be welcome. It would require creating cooperating triggers in the database and having a listener, but you might consider the triggered_change_notifications() trigger function included in 9.2. It works at least as

Re: [HACKERS] COPY with hints, rebirth

2012-02-26 Thread Heikki Linnakangas
On 24.02.2012 22:55, Simon Riggs wrote: A long time ago, in a galaxy far away, we discussed ways to speed up data loads/COPY. http://archives.postgresql.org/pgsql-hackers/2007-01/msg00470.php In particular, the idea that we could mark tuples as committed while we are still loading them, to

[HACKERS] Checkpointer vs pg_stat_bgwriter

2012-02-26 Thread Magnus Hagander
Hi! I admit to not having actually tested this since I don't have a good cluster to test it on right now, but from what I can tell the code in the new checkpointer process only sends statistics to the collector once the checkpoint is finished (checkpointer.c, line 549). The 9.1 and earlier sent

Re: [HACKERS] Command Triggers, patch v11

2012-02-26 Thread Thom Brown
On 26 February 2012 14:12, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Thanks for your further testing! Thom Brown t...@linux.com writes: Further testing reveals a problem with FTS configurations when using the example function provided in the docs: Could you send me your tests so that I

Re: [HACKERS] psql \i tab completion initialization problem on HEAD

2012-02-26 Thread Peter van Hardenberg
On Fri, Feb 24, 2012 at 9:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Actually, what I should have asked is are you running Lion?. Because with libedit on Lion, tab completion is 100% broken, as per http://archives.postgresql.org/pgsql-hackers/2011-07/msg01642.php This is just the latest

Re: [HACKERS] Speed dblink using alternate libpq tuple storage

2012-02-26 Thread Marko Kreen
On Fri, Feb 24, 2012 at 05:46:16PM +0200, Marko Kreen wrote: - rename to PQrecvRow() and additionally provide PQgetRow() I tried it and it seems to work as API - there is valid behaviour for both sync and async connections. Sync connection - PQgetRow() waits for data from network: if

Re: [HACKERS] CLOG contention, part 2

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 2:16 PM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, Feb 8, 2012 at 11:26 PM, Robert Haas robertmh...@gmail.com wrote: Given that, I obviously cannot test this at this point, Patch with minor corrections attached here for further review. All right, I will set up

Re: [HACKERS] Command Triggers, patch v11

2012-02-26 Thread Thom Brown
On 26 February 2012 19:49, Thom Brown t...@linux.com wrote: On 26 February 2012 14:12, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Thanks for your further testing! Thom Brown t...@linux.com writes: Further testing reveals a problem with FTS configurations when using the example function

Re: [HACKERS] leakproof

2012-02-26 Thread A.M.
On Feb 26, 2012, at 10:39 AM, Peter Eisentraut wrote: On ons, 2012-02-22 at 10:56 -0500, Andrew Dunstan wrote: The trouble with leakproof is that it doesn't point to what it is that's not leaking, which is information rather than memory, as many might imagine (and I did) without further

Re: [HACKERS] Misleading CREATE TABLE error

2012-02-26 Thread Robert Haas
On Fri, Feb 24, 2012 at 4:03 AM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2011-11-29 at 06:33 +0200, Peter Eisentraut wrote: I'm not trying to inherit a relation, I'm trying to base a table on it.  As it happens, cows is a foreign table, which *is* a table, just not a regular

Re: [HACKERS] leakproof

2012-02-26 Thread Robert Haas
On Sun, Feb 26, 2012 at 6:44 PM, A.M. age...@themactionfaction.com wrote: If you are willing to go full length, then the computer science term is referential transparency, no? http://en.wikipedia.org/wiki/Referential_transparency_(computer_science) So a function could be described as

Re: [HACKERS] leakproof

2012-02-26 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sun, Feb 26, 2012 at 6:44 PM, A.M. age...@themactionfaction.com wrote: http://en.wikipedia.org/wiki/Referential_transparency_(computer_science) So a function could be described as REFERENTIALLY TRANSPARENT. Hmm, I think that's very close to what

Re: [HACKERS] leakproof

2012-02-26 Thread Andrew Dunstan
On 02/26/2012 08:23 PM, Tom Lane wrote: Robert Haasrobertmh...@gmail.com writes: On Sun, Feb 26, 2012 at 6:44 PM, A.M.age...@themactionfaction.com wrote: http://en.wikipedia.org/wiki/Referential_transparency_(computer_science) So a function could be described as REFERENTIALLY TRANSPARENT.

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

2012-02-26 Thread Robert Haas
On Thu, Feb 23, 2012 at 11:01 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: This seems like a horrid mess that's going to be unsustainable both from a complexity and a performance standpoint.  The only reason multixacts were tolerable at all was that they had only one semantics.  

Re: [HACKERS] Runtime SHAREDIR for testing CREATE EXTENSION

2012-02-26 Thread Robert Haas
On Sun, Feb 26, 2012 at 10:36 AM, Peter Eisentraut pete...@gmx.net wrote: On lör, 2012-02-25 at 14:21 +0100, Christoph Berg wrote: Well, I'm trying to invoke the extension's make check target at extension build time. I do have a temporary installation I own somehwere in my $HOME, but that is

Re: [HACKERS] Memory usage during sorting

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 4:31 PM, Jeff Janes jeff.ja...@gmail.com wrote: I'm not sure about the conclusion, but given this discussion, I'm inclined to mark this Returned with Feedback. OK, thanks.  Does anyone have additional feed-back on how tightly we wish to manage memory usage?  Is trying

Re: [HACKERS] FDW system columns

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 3:56 PM, Thom Brown t...@linux.com wrote: If there seems to be a consensus on removing system column from foreign tables, I'd like to work on this issue.  Attached is a halfway patch, and ISTM there is no problem so far. I can say that at least PgAdmin doesn't use

Re: [HACKERS] Website stylesheet for local docs

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 7:54 AM, Magnus Hagander mag...@hagander.net wrote: I've asked for this a few times before, but it seems others aren't as keen on it as me :-) Personally, I find the docs easier to read when formatted with the new website styles that Thom put together, and I also like

Re: [HACKERS] Memory usage during sorting

2012-02-26 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: A quick Google search for external sorting algorithms suggest that the typical way of doing an external sort is to read data until you fill your in-memory buffer, quicksort it, and dump it out as a run. Repeat until end-of-data; then, merge the runs

Re: [HACKERS] pgstat documentation tables

2012-02-26 Thread Robert Haas
On Sat, Feb 25, 2012 at 9:33 AM, Magnus Hagander mag...@hagander.net wrote: On Mon, Jan 16, 2012 at 02:03, Greg Smith g...@2ndquadrant.com wrote: On 01/15/2012 12:20 PM, Tom Lane wrote: Please follow the style already used for system catalogs; ie I think there should be a summary table with

Re: [HACKERS] Re: pg_stat_statements normalisation without invasive changes to the parser (was: Next steps on pg_stat_statements normalisation)

2012-02-26 Thread Robert Haas
On Fri, Feb 24, 2012 at 9:43 AM, Peter Geoghegan pe...@2ndquadrant.com wrote: Tom's point example does not seem to be problematic to me - the cast *should* blame the 42 const token, as the cast doesn't work as a result of its representation, which is in point of fact why the core system blames

Re: [HACKERS] Initial 9.2 pgbench write results

2012-02-26 Thread Robert Haas
On Fri, Feb 24, 2012 at 5:35 AM, Simon Riggs si...@2ndquadrant.com wrote: On Thu, Feb 23, 2012 at 11:59 PM, Robert Haas robertmh...@gmail.com wrote: this doesn't feel like the right time to embark on a bunch of new engineering projects. IMHO this is exactly the right time to do full system

Re: [HACKERS] Re: pg_stat_statements normalisation without invasive changes to the parser (was: Next steps on pg_stat_statements normalisation)

2012-02-26 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: I think I agree Tom's position upthread: blaming the coercion seems to me to make more sense. But if that's what we're trying to do, then why does parse_coerce() say this? /* * Set up to point at the constant's text if the input

Re: [HACKERS] Website stylesheet for local docs

2012-02-26 Thread Magnus Hagander
On Mon, Feb 27, 2012 at 04:37, Robert Haas robertmh...@gmail.com wrote: On Sat, Feb 25, 2012 at 7:54 AM, Magnus Hagander mag...@hagander.net wrote: I've asked for this a few times before, but it seems others aren't as keen on it as me :-) Personally, I find the docs easier to read when