[HACKERS] Introduction

2011-04-27 Thread Shiv
Dear pgsql-hackers, My name is Sivasankar Ramasubramanian (you can call me Shiv). I am one of the students taking part in this years Google Summer of Code program. I am Indian but I study and live in Singapore (at the National University of Singapore). On the program I hope to learn as much

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

2011-04-27 Thread Alexander Korotkov
On Tue, Apr 26, 2011 at 1:10 PM, Alexander Korotkov aekorot...@gmail.comwrote: Since algorithm is focused to reduce I/O, we should expect best acceleration in the case when index doesn't fitting to memory. Size of buffers is comparable to size of whole index. It means that if we can hold

Re: [HACKERS] Proposal - asynchronous functions

2011-04-27 Thread Markus Wanner
On 04/26/2011 11:17 PM, Robert Haas wrote: IIRC, we kind of got stuck on the prerequisite wamalloc patch, and that sunk the whole thing. :-( Right, that prerequisite was the largest stumbling block. As I certainly mentioned back then, it should be possible to get rid of the imessages

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

2011-04-27 Thread Heikki Linnakangas
On 27.04.2011 09:51, Alexander Korotkov wrote: On Tue, Apr 26, 2011 at 1:10 PM, Alexander Korotkovaekorot...@gmail.comwrote: Since algorithm is focused to reduce I/O, we should expect best acceleration in the case when index doesn't fitting to memory. Size of buffers is comparable to size of

Re: [HACKERS] Memory leak in FDW

2011-04-27 Thread Heikki Linnakangas
On 26.04.2011 21:30, Tom Lane wrote: Heikki Linnakangasheikki.linnakan...@enterprisedb.com writes: The trivial fix is to reset the per-tuple memory context between iterations. Have you tested this with SRFs? ForeignNext seems like quite the wrong place for resetting exprcontext in any case

[HACKERS] Predicate locking

2011-04-27 Thread Vlad Arkhipov
I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they will be implemented in Postgres core. Is there something like predicate locking on the TODO list

Re: [HACKERS] Predicate locking

2011-04-27 Thread Nicolas Barbier
2011/4/27 Vlad Arkhipov arhi...@dc.baikal.ru: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they will be implemented in Postgres core. Is there

Re: [HACKERS] Predicate locking

2011-04-27 Thread Vlad Arkhipov
27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipovarhi...@dc.baikal.ru: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they will be

Re: [HACKERS] Predicate locking

2011-04-27 Thread Heikki Linnakangas
On 27.04.2011 12:24, Vlad Arkhipov wrote: 27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipovarhi...@dc.baikal.ru: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR

Re: [HACKERS] alpha5

2011-04-27 Thread Heikki Linnakangas
On 26.04.2011 17:36, Alvaro Herrera wrote: Excerpts from Alvaro Herrera's message of sáb abr 09 01:55:45 -0300 2011: Excerpts from Peter Eisentraut's message of lun mar 28 17:00:01 -0300 2011: On mån, 2011-03-28 at 09:35 -0400, Robert Haas wrote: Actually those are all my fault. Sorry, I'm

Re: [HACKERS] maximum digits for NUMERIC

2011-04-27 Thread Daniele Varrazzo
On Wed, Apr 27, 2011 at 4:47 AM, Bruce Momjian br...@momjian.us wrote: Alvaro Herrera wrote: Excerpts from Bruce Momjian's message of mar abr 26 12:58:19 -0300 2011: Wow, I am so glad someone documented this.  I often do factorial(4000) which generates 12673 digits when teaching classes,

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 12:50 AM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: All or almost all the warnings seen on Windows/Mingw of the type warning: unknown conversion type character 'm' in format come from checking of three functions: errmsg, elog and errdetail. I therefore propose

Re: [HACKERS] fixing INT64_FORMAT warnings on Mingw

2011-04-27 Thread Peter Eisentraut
On Wed, 2011-04-27 at 00:01 -0400, Andrew Dunstan wrote: Both %lld and %I64d can be used with mingw to print 64 bit integers. However, modern versions of gcc spit warnings with the former, and not the latter. However, since %lld works, it is chosen by our config setup since it comes first

Re: [HACKERS] Fail to search in array, produced by subquery - is it a bug?

2011-04-27 Thread Merlin Moncure
On Tue, Apr 26, 2011 at 10:29 PM, Dmitry Fefelov fo...@ac-sw.com wrote: With Postgres 8.4 query like SELECT *  FROM core.tag_links ctl  WHERE (ctl.tag_id = ANY (      SELECT array_agg(ct.id)        FROM core.tags ct        WHERE (LOWER(ct.tag) LIKE LOWER(('search tag')::text || '%') ESCAPE

Re: [HACKERS] stored procedures - use cases?

2011-04-27 Thread Merlin Moncure
On Tue, Apr 26, 2011 at 10:12 PM, Greg Stark gsst...@mit.edu wrote: On Tue, Apr 26, 2011 at 11:55 PM, Josh Berkus j...@agliodbs.com wrote: Here's where I wanted autonomous transactions just last week, and didn't have them so I had to use a python script outside the database: -- doing a CREATE

Re: [HACKERS] operator classes for index?

2011-04-27 Thread Yves Weißig
Am 26.04.2011 17:37, schrieb Tom Lane: =?ISO-8859-1?Q?Yves_Wei=DFig?= weis...@rbg.informatik.tu-darmstadt.de writes: Am 26.04.2011 14:28, schrieb Robert Haas: On Tue, Apr 26, 2011 at 5:18 AM, Yves Weißig weis...@rbg.informatik.tu-darmstadt.de wrote: CREATE OPERATOR CLASS abstime_ops

Re: [HACKERS] new AM, catalog entries

2011-04-27 Thread Yves Weißig
Am 26.04.2011 17:07, schrieb Alvaro Herrera: Excerpts from Yves Weißig's message of mar abr 26 11:32:31 -0300 2011: I keep getting: ERROR: there is no built-in function named ebibuild This error message somehow leads me to fmgr.c where the contents of an array are inspected (in line 134).

[HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Yves Weißig
Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? Greetz, Yves -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Heikki Linnakangas
On 27.04.2011 17:06, Yves Weißig wrote: Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? What kind of a Datum do you want it to be? What data type? See CStringGetDatum, or perhaps CStringGetTextDatum(). Or

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 10:06 AM, Yves Weißig wrote: Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? CStringGetDatum() The code is replete with examples, cheers andrew -- Sent via pgsql-hackers mailing list

Re: [HACKERS] fixing INT64_FORMAT warnings on Mingw

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 09:00 AM, Peter Eisentraut wrote: On Wed, 2011-04-27 at 00:01 -0400, Andrew Dunstan wrote: Both %lld and %I64d can be used with mingw to print 64 bit integers. However, modern versions of gcc spit warnings with the former, and not the latter. However, since %lld works, it is

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: On 04/27/2011 12:50 AM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: All or almost all the warnings seen on Windows/Mingw of the type warning: unknown conversion type character 'm' in format come from checking of three functions:

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 10:29 AM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: On 04/27/2011 12:50 AM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: All or almost all the warnings seen on Windows/Mingw of the type warning: unknown conversion type character 'm' in format

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Kevin Grittner
Andrew Dunstan and...@dunslane.net wrote: What I'd like to know is why it doesn't complain elsewhere. It appears to be allowed as an extension on some compliers. http://sourceware.org/ml/newlib/2006/msg00079.html -Kevin -- Sent via pgsql-hackers mailing list

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: What I'd like to know is why it doesn't complain elsewhere. That question is backwards ... The one non-Linux non-Windows machine I have is FBSD. Its gcc (4.2.1) doesn't expand %m but doesn't complain about it either. It's libc, not gcc, that's

Re: [HACKERS] alpha5

2011-04-27 Thread Alvaro Herrera
Excerpts from Heikki Linnakangas's message of mié abr 27 07:47:32 -0300 2011: On 26.04.2011 17:36, Alvaro Herrera wrote: I suggest having them be created in doc/src/sgml all target. This gets them in make docs and make world AFAICT. This is a trivial patch (attached). The only problem

Re: [HACKERS] Alignment padding bytes in arrays vs the planner

2011-04-27 Thread Tom Lane
Greg Stark gsst...@mit.edu writes: On Wed, Apr 27, 2011 at 12:23 AM, Tom Lane t...@sss.pgh.pa.us wrote: Any ideas about better answers? Here's a crazy idea. We could use string equality of the out function's representation instead. If an output function doesn't consistently output the same

Re: [HACKERS] Alignment padding bytes in arrays vs the planner

2011-04-27 Thread Tom Lane
Noah Misch n...@leadboat.com writes: On Tue, Apr 26, 2011 at 07:23:12PM -0400, Tom Lane wrote: [input functions aren't the only problematic source of uninitialized datum bytes] FWIW, when I was running the test suite under valgrind, these were the functions that left uninitialized bytes in

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 11:02 AM, Tom Lane wrote: So the question to ask is not why gcc doesn't complain about %m elsewhere, but why it does complain in your Windows installation. I'm guessing that the mingw people hacked it. If you're lucky, they might have hacked in an extra switch to control the

timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

2011-04-27 Thread Peter Eisentraut
On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: The line I marked in pg_basebackup.c might be an actual problem: It goes through a whole lot to figure out the timeline and then doesn't do anything with it. This hasn't been addressed yet. It doesn't manifest itself as an actual

Re: [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable

2011-04-27 Thread Peter Eisentraut
On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: As you might have heard, GCC 4.6 was released the other day. It generates a bunch of new warnings with the PostgreSQL source code, most of which belong to the new warning scenario -Wunused-but-set-variable, which is included in -Wall.

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

2011-04-27 Thread Magnus Hagander
On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut pete...@gmx.net wrote: On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: The line I marked in pg_basebackup.c might be an actual problem: It goes through a whole lot to figure out the timeline and then doesn't do anything with it. This

Re: [HACKERS] SSI non-serializable UPDATE performance

2011-04-27 Thread Simon Riggs
On Mon, Apr 25, 2011 at 4:33 AM, Dan Ports d...@csail.mit.edu wrote: On Sat, Apr 23, 2011 at 08:54:31AM -0500, Kevin Grittner wrote: Even though this didn't show any difference in Dan's performance tests, it seems like reasonable insurance against creating a new bottleneck in very high

Re: [HACKERS] stored procedures - use cases?

2011-04-27 Thread Josh Berkus
These don't seem like compelling use cases at all to me. You said you had to fall back to using a python script outside the database, but what disadvantage does that have? Why is moving your application logic into the database an improvement? Since both were part of a code rollout, it

Re: [HACKERS] SSI non-serializable UPDATE performance

2011-04-27 Thread Dan Ports
On Wed, Apr 27, 2011 at 06:26:52PM +0100, Simon Riggs wrote: Reading the code, IIUC, we check for RW conflicts after each write but only if the writer is running a serializable transaction. Am I correct in thinking that there is zero impact of SSI if nobody is running a serializable

Re: [HACKERS] SSI non-serializable UPDATE performance

2011-04-27 Thread Kevin Grittner
Simon Riggs si...@2ndquadrant.com wrote: Reading the code, IIUC, we check for RW conflicts after each write but only if the writer is running a serializable transaction. Correct as far as that statement goes. There are cases where predicate lock maintenance is needed when dealing with

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

2011-04-27 Thread Peter Eisentraut
On ons, 2011-04-27 at 19:17 +0200, Magnus Hagander wrote: On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut pete...@gmx.net wrote: On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: The line I marked in pg_basebackup.c might be an actual problem: It goes through a whole lot to figure

Re: [HACKERS] Typed-tables patch broke pg_upgrade

2011-04-27 Thread Peter Eisentraut
Here is the patch to fix that, as discussed. diff --git i/src/bin/pg_dump/pg_dump.c w/src/bin/pg_dump/pg_dump.c index c2f6180..afc7fd7 100644 --- i/src/bin/pg_dump/pg_dump.c +++ w/src/bin/pg_dump/pg_dump.c @@ -12004,7 +12004,11 @@ dumpTableSchema(Archive *fout, TableInfo *tbinfo) UNLOGGED

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

2011-04-27 Thread Magnus Hagander
On Wed, Apr 27, 2011 at 20:21, Peter Eisentraut pete...@gmx.net wrote: On ons, 2011-04-27 at 19:17 +0200, Magnus Hagander wrote: On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut pete...@gmx.net wrote: On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: The line I marked in

Re: [HACKERS] pg_upgrade automatic testing

2011-04-27 Thread Peter Eisentraut
On tor, 2011-04-07 at 23:02 +0300, Peter Eisentraut wrote: Seeing that 9.1-to-9.1 pg_upgrade has apparently been broken for months, it would probably be good to have some kind of automatic testing for it. Attached is something I hacked together that at least exposes the current problems,

Re: [HACKERS] alpha5

2011-04-27 Thread Peter Eisentraut
On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: This is a trivial patch (attached). The only problem with it is that make all would fail if lynx is not installed. Well, that will probably not be acceptable. I rather think the action item here is to set up a buildfarm-ish job that

Re: [HACKERS] Typed-tables patch broke pg_upgrade

2011-04-27 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: Here is the patch to fix that, as discussed. Looks sane --- I assume you tested it against the originally complained-of scenario? http://archives.postgresql.org/message-id/201103111328.p2bdsfd10...@momjian.us If so, please apply soon --- we need to wrap

Re: [HACKERS] alpha5

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 02:40 PM, Peter Eisentraut wrote: On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: This is a trivial patch (attached). The only problem with it is that make all would fail if lynx is not installed. Well, that will probably not be acceptable. I rather think the action

[HACKERS] PostgreSQL Core Team

2011-04-27 Thread Dave Page
I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the native Windows port, quickly becoming a committer

Re: [HACKERS] alpha5

2011-04-27 Thread Alvaro Herrera
Excerpts from Peter Eisentraut's message of mié abr 27 15:40:22 -0300 2011: On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: This is a trivial patch (attached). The only problem with it is that make all would fail if lynx is not installed. Well, that will probably not be

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

2011-04-27 Thread Raymond O'Donnell
On 27/04/2011 19:48, Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the native

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread David Fetter
Kudos! Cheers, David. On Wed, Apr 27, 2011 at 07:48:48PM +0100, Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the

Re: [HACKERS] XML with invalid chars

2011-04-27 Thread Andrew Dunstan
On 04/26/2011 05:11 PM, Noah Misch wrote: On Mon, Apr 25, 2011 at 07:25:02PM -0400, Andrew Dunstan wrote: I came across this today, while helping a customer. The following will happily create a piece of XML with an embedded ^A: select xmlelement(name foo, null, E'abc\x01def'); Now, a ^A

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Thom Brown
On 27 April 2011 19:48, Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

2011-04-27 Thread Alvaro Herrera
Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: Should be. Moa is definitely Sun Studio: -bash-3.00$ /opt/sunstudio12.1/bin/cc -V cc: Sun C 5.10 SunOS_i386 2009/06/03 usage: cc [ options] files. Use 'cc -flags' for details And Huia is GCC: -bash-3.00$

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

2011-04-27 Thread Dave Page
On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: Should be. Moa is definitely Sun Studio: -bash-3.00$ /opt/sunstudio12.1/bin/cc -V cc: Sun C 5.10 SunOS_i386 2009/06/03 usage: cc [ options]

Re: [HACKERS] Typed-tables patch broke pg_upgrade

2011-04-27 Thread Noah Misch
On Wed, Apr 27, 2011 at 09:30:41PM +0300, Peter Eisentraut wrote: Here is the patch to fix that, as discussed. Looks correct. Thanks. -- 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] Alpha4 release blockers (was Re: wrapping up this CommitFest)

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 03:15 PM, Dave Page wrote: On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: Should be. Moa is definitely Sun Studio: -bash-3.00$ /opt/sunstudio12.1/bin/cc -V cc: Sun C 5.10

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

2011-04-27 Thread Alvaro Herrera
Excerpts from Dave Page's message of mié abr 27 16:15:33 -0300 2011: On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: BTW I just swapped the compiler details for those two animals in the buildfarm database. I thought Andrew did that already? He hadn't

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

2011-04-27 Thread Michael Glaesemann
On Apr 27, 2011, at 14:48, Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Congratulations, Magnus! Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Jaime Casanova
On Wed, Apr 27, 2011 at 1:48 PM, Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Congratulations! -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación

[HACKERS] make world fails

2011-04-27 Thread Kevin Grittner
I just did my usual: make maintainer-clean \ ./configure --prefix=/usr/local/pgsql-serializable \ --enable-debug \ --enable-cassert \ --enable-depend \ --with-libxml \ --with-python \ make world Which ended

Re: [HACKERS] stored procedures - use cases?

2011-04-27 Thread Greg Stark
On Wed, Apr 27, 2011 at 6:48 PM, Josh Berkus j...@agliodbs.com wrote: If you pursue your argument a little further, Greg, why do we have functions at all?  We could do it all in the application. Autonomous transactions have value on their own. But it's not so that you can run create index

[HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-04-27 Thread Kevin Grittner
Composing my rather long-winded response to Simon got me thinking -- which just led me to realize there is probably a need to fix another thing related to SSI. For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE

Re: [HACKERS] [COMMITTERS] pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64

2011-04-27 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Tom Lane's message of lun abr 25 17:22:41 -0300 2011: Fix pg_size_pretty() to avoid overflow for inputs close to INT64_MAX. Apparently this change is causing Moa's SunStudio compiler to fail an assertion. [ scratches head... ]

Re: [HACKERS] make world fails

2011-04-27 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: I just did my usual: make maintainer-clean \ ./configure --prefix=/usr/local/pgsql-serializable \ --enable-debug \ --enable-cassert \ --enable-depend \ --with-libxml \

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Merlin Moncure
On Wed, Apr 27, 2011 at 1:48 PM, Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-04-27 Thread Heikki Linnakangas
On 27.04.2011 22:59, Kevin Grittner wrote: For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE lock might need to block until all SIREAD locks on the relation have been released. Picture, for example, what might

Re: [HACKERS] make world fails

2011-04-27 Thread Alvaro Herrera
Excerpts from Kevin Grittner's message of mié abr 27 16:39:01 -0300 2011: I just did my usual: make maintainer-clean \ ./configure --prefix=/usr/local/pgsql-serializable \ --enable-debug \ --enable-cassert \ --enable-depend \

Re: [HACKERS] make world fails

2011-04-27 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: I just did my usual: make maintainer-clean \ ./configure --prefix=/usr/local/pgsql-serializable \ --enable-debug \ --enable-cassert \ --enable-depend \

Re: [HACKERS] [COMMITTERS] pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64

2011-04-27 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié abr 27 17:10:37 -0300 2011: Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Tom Lane's message of lun abr 25 17:22:41 -0300 2011: Fix pg_size_pretty() to avoid overflow for inputs close to INT64_MAX. Apparently this change is causing

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Yves Weißig
Am 27.04.2011 16:11, schrieb Heikki Linnakangas: On 27.04.2011 17:06, Yves Weißig wrote: Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? What kind of a Datum do you want it to be? What data type? See

Re: [HACKERS] make world fails

2011-04-27 Thread Dave Page
On Wed, Apr 27, 2011 at 9:29 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: I just did my usual: make maintainer-clean \   ./configure --prefix=/usr/local/pgsql-serializable \                

Re: [HACKERS] Introduction

2011-04-27 Thread Daniel Farina
On Tue, Apr 26, 2011 at 11:20 PM, Shiv rama.the...@gmail.com wrote: Dear pgsql-hackers,  My name is Sivasankar Ramasubramanian (you can call me Shiv). That's an awesome nickname. My project is aimed towards extending and hopefully improving upon pgtune. If any of you have some ideas or

[HACKERS] new AM, build returns error

2011-04-27 Thread Yves Weißig
Hi, my new AM starts working..., calling something like CREATE INDEX idx ON films USING ebi (did) returns now: ERROR: unexpected EBI relation size: 3, should be 4294967295 The second argument looks for me like max uint32... there might be somehting wrong here I think? Is there somehting

Re: [HACKERS] make world fails

2011-04-27 Thread Alvaro Herrera
Excerpts from Alvaro Herrera's message of mié abr 27 17:28:32 -0300 2011: I think you need to install some Docbook XSL package or other. In my system (Debian) I have a catalog.xml file from the docbook-xsl package which has these two lines in it: rewriteURI

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-04-27 Thread Kevin Grittner
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 27.04.2011 22:59, Kevin Grittner wrote: For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE lock might need to block until all SIREAD locks on the

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Cédric Villemain
2011/4/27 Dave Page dp...@postgresql.org: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the

Re: [HACKERS] XML with invalid chars

2011-04-27 Thread Noah Misch
On Wed, Apr 27, 2011 at 03:05:30PM -0400, Andrew Dunstan wrote: On 04/26/2011 05:11 PM, Noah Misch wrote: On Mon, Apr 25, 2011 at 07:25:02PM -0400, Andrew Dunstan wrote: I came across this today, while helping a customer. The following will happily create a piece of XML with an embedded ^A:

Re: [HACKERS] make world fails

2011-04-27 Thread Peter Eisentraut
On ons, 2011-04-27 at 17:54 -0300, Alvaro Herrera wrote: Excerpts from Alvaro Herrera's message of mié abr 27 17:28:32 -0300 2011: I think you need to install some Docbook XSL package or other. In my system (Debian) I have a catalog.xml file from the docbook-xsl package which has these

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-04-27 Thread Dan Ports
On Wed, Apr 27, 2011 at 02:59:19PM -0500, Kevin Grittner wrote: For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE lock might need to block until all SIREAD locks on the relation have been released. Picture,

Re: [HACKERS] pg_upgrade automatic testing

2011-04-27 Thread Noah Misch
On Wed, Apr 27, 2011 at 09:32:16PM +0300, Peter Eisentraut wrote: On tor, 2011-04-07 at 23:02 +0300, Peter Eisentraut wrote: Seeing that 9.1-to-9.1 pg_upgrade has apparently been broken for months, it would probably be good to have some kind of automatic testing for it. Attached is

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

2011-04-27 Thread Kevin Grittner
Dan Ports d...@csail.mit.edu wrote: On Wed, Apr 27, 2011 at 04:09:38PM -0500, Kevin Grittner wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Hmm, could we upgrade all predicate locks to relation-level predicate locks instead? Tied to what backend? I think Heikki was

Re: [HACKERS] stored procedures - use cases?

2011-04-27 Thread Josh Berkus
Greg, Because we want to be able to manipulate data in queries in data-type-specific ways. For example we want to do aggregations on the result of a function or index scans across a user data type, etc. I don't see how this is different from wanting to capture error output, which would face

Re: [HACKERS] [ANNOUNCE] PostgreSQL Core Team

2011-04-27 Thread nadosilok
Congratulation! Regards, Nado Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -Original Message- From: Dave Page dp...@postgresql.org Sender: pgsql-announce-owner@postgresql.orgDate: Wed, 27 Apr 2011 19:48:48 To: pgsql-announcepgsql-annou...@postgresql.org Cc: PostgreSQL

Re: [HACKERS] stored procedures - use cases?

2011-04-27 Thread David E. Wheeler
On Apr 27, 2011, at 3:28 PM, Josh Berkus wrote: Actually, you can already sort of do that using XSLT. So I don't necessary think that's a prohibitive idea, depending on implementation. After all, many of the new non-relational databases implement exactly this. The proposed JSON data type

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Jeremiah Peschka
Congratulations. Jeremiah Peschka Microsoft SQL Server MVP MCITP: Database Developer, DBA On Apr 27, 2011 11:49 AM, Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor

Re: [HACKERS] PostgreSQL Core Team

2011-04-27 Thread Hiroshi Saito
Congratulations!! (2011/04/28 3:48), Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 11:58 AM, Andrew Dunstan wrote: On 04/27/2011 11:02 AM, Tom Lane wrote: So the question to ask is not why gcc doesn't complain about %m elsewhere, but why it does complain in your Windows installation. I'm guessing that the mingw people hacked it. If you're lucky, they might

Re: [HACKERS] [ANNOUNCE] PostgreSQL Core Team

2011-04-27 Thread Sean Doherty
Magnus, congratulations! In my short two years around PostgreSQL your name has been synonymous with super intelligence and a great attitude. All the best Sean On Apr 27, 2011, at 1:48 PM, Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus

Re: [ANNOUNCE] [HACKERS] PostgreSQL Core Team

2011-04-27 Thread David Cifuentes
My Congratulations too ;)!!! Enviado desde mi iPhone El 27/04/2011, a las 18:50, Hiroshi Saito hiro...@winpg.jp escribió: Congratulations!! (2011/04/28 3:48), Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core

Re: [HACKERS] Introduction

2011-04-27 Thread Shiv
Thank you for your compliment (about the name). Its quite sad though that the word Shiv does not exist in the Indian-English lexicon. So people just think of the God and not of a knife! I do have some ideas and heuristics in mind. I wanted to give out a small hello to the community for now. I

Re: [HACKERS] improvements to pgtune

2011-04-27 Thread Greg Smith
Shiv wrote: On the program I hope to learn as much about professional software engineering principles as PostgreSQL. My project is aimed towards extending and hopefully improving upon pgtune. If any of you have some ideas or thoughts to share. I am all ears!! Well, first step on the

Re: [HACKERS] improvements to pgtune

2011-04-27 Thread Greg Smith
Daniel Farina wrote: It seems like in general it lacks a feedback mechanism to figure things out settings from workloads, instead relying on Greg Smith's sizable experience to do some arithmetic and get you off the ground in a number of common cases. To credit appropriately, the model used

Re: [HACKERS] Predicate locking

2011-04-27 Thread Vlad Arkhipov
27.04.2011 18:38, Heikki Linnakangas пишет: On 27.04.2011 12:24, Vlad Arkhipov wrote: 27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipovarhi...@dc.baikal.ru: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special

Re: [HACKERS] XML with invalid chars

2011-04-27 Thread Andrew Dunstan
On 04/27/2011 05:30 PM, Noah Misch wrote: I'm not sure what to do about the back branches and cases where data is already in databases. This is fairly ugly. Suggestions welcome. We could provide a script in (or linked from) the release notes for testing the data in all your xml columns.

Re: [HACKERS] XML with invalid chars

2011-04-27 Thread Noah Misch
On Wed, Apr 27, 2011 at 11:22:37PM -0400, Andrew Dunstan wrote: On 04/27/2011 05:30 PM, Noah Misch wrote: To make things worse, the dump/reload problems seems to depend on your version of libxml2, or something. With git master, a CentOS 5 system with 2.6.26-2.1.2.8.el5_5.1 accepts the ^A

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Tom Lane
=?ISO-8859-15?Q?Yves_Wei=DFig?= weis...@rbg.informatik.tu-darmstadt.de writes: Am 27.04.2011 16:11, schrieb Heikki Linnakangas: What kind of a Datum do you want it to be? What data type? See CStringGetDatum, or perhaps CStringGetTextDatum(). Or perhaps you want to call the input function of

Re: [HACKERS] make world fails

2011-04-27 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On ons, 2011-04-27 at 17:54 -0300, Alvaro Herrera wrote: I take it that if I have a manpages/docbook.xsl in that path, it uses that instead of trying to fetch it from sourceforge. Exactly. If you don't want to depend on net access, you can do

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: OK, having gone a long way down this hole, I think I have the answer. Using an attribute of 'gnu_printf' instead of just 'printf' on the elog.h functions clears all those warnings. The manual at

Re: [HACKERS] improvements to pgtune

2011-04-27 Thread Joshua Berkus
Every time I've gotten pulled into discussions of setting parameters based on live monitoring, it's turned into a giant black hole--absorbs a lot of energy, nothing useful escapes from it. I credit completely ignoring that idea altogether, and using the simplest possible static settings

Re: [HACKERS] Proposal - asynchronous functions

2011-04-27 Thread Sim Zacks
It sounds like there is interest in this feature, can it get added to the TODO list? -- 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] unknown conversion %m

2011-04-27 Thread Andrew Dunstan
On 04/28/2011 12:15 AM, Tom Lane wrote: I'd suggest adjusting the elog.h declarations to use gnu_printf only on Windows, and printf elsewhere, for the moment. Maybe we can migrate towards using gnu_printf on other platforms later. Yeah. In fact, if I adjust most

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: What I'm thinking of doing is to set up something like: #define PG_PRINTF_CHECK __printf__ and on Windows redefine it to __gnu_printf__, and then set all the formats to use PG_PRINTF_CHECK. Sound OK? +1 ... those __attribute__ declarations

Re: [HACKERS] unknown conversion %m

2011-04-27 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: What I'm thinking of doing is to set up something like: #define PG_PRINTF_CHECK __printf__ BTW, gcc 2.95.3 documents printf, and not __printf__. Suggest not including the underscores, since that's apparently a johnny-come-lately spelling. It's not

  1   2   >