[HACKERS] Why can't I use pgxs to build a plpgsql plugin?

2012-04-08 Thread Guillaume Lelarge
Hi, I recently wrote a plpgsql plugin. I wanted to enable the use of pgxs, to make it easier to compile the plugin, but I eventually found that I can't do that because the plpgsql.h file is not available in the include directory. I'm wondering if we shouldn't put the header files of plpgsql

Re: [HACKERS] Last gasp

2012-04-08 Thread Boszormenyi Zoltan
2012-04-05 20:55 keltezéssel, Michael Meskes írta: On Thu, Apr 05, 2012 at 02:23:03PM -0400, Tom Lane wrote: I think the ECPG fetch patch is about ready to go. Normally Michael Meskes handles all ECPG patches, but I'm not sure what his schedule is like. I'm not sure what the politics are of

Re: [HACKERS] [PATCH] lock_timeout and common SIGALRM framework

2012-04-08 Thread Boszormenyi Zoltan
2012-04-06 14:47 keltezéssel, Cousin Marc írta: On 05/04/12 08:02, Boszormenyi Zoltan wrote: 2012-04-04 21:30 keltezéssel, Alvaro Herrera írta: I think this patch is doing two things: first touching infrastructure stuff and then adding lock_timeout on top of that. Would it work to split the

Re: [HACKERS] ECPG FETCH readahead

2012-04-08 Thread Michael Meskes
On Sat, Apr 07, 2012 at 11:50:42AM -0400, Noah Misch wrote: Both. The second patch appeared after my first review, based on a comment in that review. I looked at it during my re-review before marking the overall project Ready for Committer. Thanks. I do call your attention to a question I

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-08 Thread Dave Cramer
Hi Atri, Is there some JDBC API that supports this in newer versions of the API ? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Sat, Apr 7, 2012 at 7:07 AM, Atri Sharma atri.j...@gmail.com wrote: Hi All, I submitted a GSoc application yesterday. Please review it

Re: [HACKERS] patch: improve SLRU replacement algorithm

2012-04-08 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On reflection, it seems to me that the right fix here is to make SlruSelectLRUPage() to avoid selecting a page on which an I/O is already in progress. This patch seems reasonably sane to me. It's not intuitively obvious that we should ignore I/O-busy

Re: [HACKERS] ECPG FETCH readahead

2012-04-08 Thread Boszormenyi Zoltan
2012-04-08 16:25 keltezéssel, Michael Meskes írta: On Sat, Apr 07, 2012 at 11:50:42AM -0400, Noah Misch wrote: Both. The second patch appeared after my first review, based on a comment in that review. I looked at it during my re-review before marking the overall project Ready for Committer.

Re: [HACKERS] [PATCH] lock_timeout and common SIGALRM framework

2012-04-08 Thread Boszormenyi Zoltan
2012-04-08 11:24 keltezéssel, Boszormenyi Zoltan írta: 2012-04-06 14:47 keltezéssel, Cousin Marc írta: On 05/04/12 08:02, Boszormenyi Zoltan wrote: 2012-04-04 21:30 keltezéssel, Alvaro Herrera írta: I think this patch is doing two things: first touching infrastructure stuff and then adding

Re: [HACKERS] Last gasp

2012-04-08 Thread Andrew Dunstan
On 04/07/2012 11:03 PM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net writes: On 04/07/2012 06:33 PM, Peter Geoghegan wrote: I hope that that policy will not be applied without some degree of discrimination. If we are to have time based releases, then I assume it won't, it will be

Re: [HACKERS] ECPG FETCH readahead

2012-04-08 Thread Michael Meskes
On Sun, Apr 08, 2012 at 06:35:33PM +0200, Boszormenyi Zoltan wrote: Do you want me to change this or will you do it? I am on holiday and will be back to work on wednesday. I don't think waiting till later this week is a real problem. The possibility to test different readahead window sizes

[HACKERS] Is there any way to disable compiler optimization and enable debug?

2012-04-08 Thread clover white
HI, I would like to debug PG because I have a problem when I run initdb, and I have question about the configure file. when I used the command below to config PG, it was only built with debugging symbols (-g) and O2 compiler optimization which would lead to execute order not match the source

Re: [HACKERS] Is there any way to disable compiler optimization and enable debug?

2012-04-08 Thread Andrew Dunstan
On 04/08/2012 01:42 PM, clover white wrote: HI, I would like to debug PG because I have a problem when I run initdb, and I have question about the configure file. when I used the command below to config PG, it was only built with debugging symbols (-g) and O2 compiler optimization which

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

2012-04-08 Thread Tom Lane
Peter Geoghegan pe...@2ndquadrant.com writes: On 29 March 2012 21:05, Tom Lane t...@sss.pgh.pa.us wrote: Barring objections I'll go fix this, and then this patch can be considered closed except for possible future tweaking of the sticky-entry decay rule. Attached patch fixes a bug, and

Re: [HACKERS] Is there any way to disable compiler optimization and enable debug?

2012-04-08 Thread Peter Eisentraut
On sön, 2012-04-08 at 14:47 -0400, Andrew Dunstan wrote: Try: CFLAGS=-O0 ./configure --enable-debug Better yet: ./configure CFLAGS=-O0 --enable-debug -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Last gasp

2012-04-08 Thread Josh Berkus
In short, the idea of strongly calendar-driven releases looks more and more attractive to me the more times we go through this process. If your patch isn't ready on date X, then it's not getting into this release; but there'll be another bus coming along before long. Stretching out release

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

2012-04-08 Thread Peter Geoghegan
On 8 April 2012 20:51, Tom Lane t...@sss.pgh.pa.us wrote: Applied with some cosmetic adjustments. Thanks. Having taken another look at the code, I wonder if we wouldn't have been better off just fastpathing out of pgss_store in the first call (in a pair of calls made by a backend as part an

[HACKERS] bug in fast-path locking

2012-04-08 Thread Robert Haas
On Sun, Apr 8, 2012 at 12:43 PM, Boszormenyi Zoltan z...@cybertec.at wrote: Indeed, the unpatched GIT version crashes if you enter  =#lock TABLE pgbench_accounts ; the second time in session 2 after the first one failed. Also, manually spelling it out: Session 1: $ psql psql (9.2devel)

Re: [HACKERS] ECPG FETCH readahead

2012-04-08 Thread Noah Misch
On Sun, Apr 08, 2012 at 04:25:01PM +0200, Michael Meskes wrote: On Sat, Apr 07, 2012 at 11:50:42AM -0400, Noah Misch wrote: I do call your attention to a question I raised in my second review: if a program contains DECLARE foo READAHEAD 5 CURSOR FOR ... and the user runs the program with

Re: [HACKERS] WIP: Collecting statistics on CSV file data

2012-04-08 Thread Etsuro Fujita
Thanks! Best regards, Etsuro Fujita -Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Saturday, April 07, 2012 4:20 AM To: Shigeru HANADA Cc: Etsuro Fujita; pgsql-hackers@postgresql.org Subject: Re:

Re: [HACKERS] patch: improve SLRU replacement algorithm

2012-04-08 Thread Robert Haas
On Sun, Apr 8, 2012 at 12:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: However, I do have a couple of quibbles with the comments. Good points. I made some adjustments; see what you think. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via

Re: [HACKERS] Last gasp

2012-04-08 Thread Greg Smith
On 04/07/2012 04:51 PM, Robert Haas wrote: On a related note, letting CommitFests go on for three months because there's insufficient reviewer activity to get them done in one or two is, in my opinion, not much of a solution. If there's even less reviewer activity next time, are we going to let

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2012-04-08 Thread Shigeru HANADA
(2012/04/08 5:19), Thom Brown wrote: 2012/4/7 Shigeru HANADAshigeru.han...@gmail.com: I've updated pgsql_fdw so that it can collect statistics from foreign data with new FDW API. I notice that if you restart the remote server, the connection is broken, but the client doesn't notice this

Re: [HACKERS] Last gasp

2012-04-08 Thread Noah Misch
On Sat, Apr 07, 2012 at 04:51:03PM -0400, Robert Haas wrote: I think this basically just boils down to too many patches and not enough people. I was interested in Command Triggers from the beginning of this CommitFest, and I would have liked to pick it up sooner, but there were a LOT of

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2012-04-08 Thread Gerald Devotta
This is Gerald Devotta, Recruitment Specialist with Newt Global LLC, a global staffing solutions provider that has been serving the telecommunications and utility industries. I am contacting you to let you know that your resume came to my attention while I was conducting a job search for a

[HACKERS] [patch] for psql : Allow processing of multiple -f (file) options

2012-04-08 Thread Vikash3 S
Hi,Please find the patch regarding trivial changes against To Do item list for "psql : Allow processing of multiple -f (file) options ".Looking for valuable feedback.Thanks,Vikash=-=-= Notice: The information contained in this e-mail message and/or attachments to it may