Re: [HACKERS] 8.5 vs. 9.0

2010-01-22 Thread Andreas Joseph Krogh
On Friday 22. January 2010 01.22.09 Tom Lane wrote: Larry Rosenman l...@lerctr.org writes: On Thu, January 21, 2010 5:53 pm, Andreas Joseph Krogh wrote: Care to shed some light on what features (yes, we users care about features) warrant this major version-bump? Is there a link somewhere?

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Leonardo F
So my proposal would be: do the test seq_scan vs sort/index_scan only for regular btree index, and integrate that test in the planner. Keep in mind that this patch was after the deadline for 9.0, so there is probably not a huge rush to get this done. That's true; I'll try to get the

[HACKERS] Standby server lagging behind

2010-01-22 Thread Huda Booley (h...@careerjunction.co.za)
Hi We are running postgres8.3.9 and have enabled log shipping replication. Our standby server is about 1000 files BEHIND - everything I've read indicates that the standby server should be very close behind the live server - at the rate we're going it will take 8 hours to apply all the logs to

Re: [HACKERS] Streaming Replication on win32

2010-01-22 Thread Dimitri Fontaine
Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Joe Conway wrote: OK, so now I see why we want this fixed for dblink and walreceiver, but doesn't this approach leave every other WIN32 libpq client out in the cold? Is there nothing that can be done for the general case, or is it

Re: [HACKERS] Streaming Replication on win32

2010-01-22 Thread Marko Kreen
On 1/22/10, Dimitri Fontaine dfonta...@hi-media.com wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: Joe Conway wrote: OK, so now I see why we want this fixed for dblink and walreceiver, but doesn't this approach leave every other WIN32 libpq client out in the

[HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Simon Riggs
It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin gains control again. It seems simple to attach

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Pavel Stehule
2010/1/22 Simon Riggs si...@2ndquadrant.com: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Simon Riggs
On Fri, 2010-01-22 at 11:41 +0100, Pavel Stehule wrote: 2010/1/22 Simon Riggs si...@2ndquadrant.com: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement

Re: [HACKERS] Streaming Replication on win32

2010-01-22 Thread Heikki Linnakangas
Marko Kreen wrote: On 1/22/10, Dimitri Fontaine dfonta...@hi-media.com wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: The problem only applies to libpq calls from the backend. Client apps are not affected, only backend modules. If there's any other modules out

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Heikki Linnakangas
Simon Riggs wrote: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin gains control again.

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Simon Riggs
On Fri, 2010-01-22 at 13:39 +0200, Heikki Linnakangas wrote: Simon Riggs wrote: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the

Re: [HACKERS] quoting psql varible as identifier

2010-01-22 Thread Pavel Stehule
Hello here is new variant. Add scan_state flag valid and enhance protection against execution broken statement. Regards Pavel Stehule 2010/1/22 Pavel Stehule pavel.steh...@gmail.com: 2010/1/22 Robert Haas robertmh...@gmail.com: On Thu, Jan 21, 2010 at 2:25 PM, Pavel Stehule

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Tim Bunce
On Thu, Jan 21, 2010 at 07:55:09PM -0500, Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Jim Nasby wrote: Why does warn; in plperl log as NOTICE in Postgres? Where would you like the warning to go? This has been this way for nearly 5 years, it's not new

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Peter Eisentraut
On tor, 2010-01-21 at 18:05 -0500, Andrew Dunstan wrote: Well, we used to have the idea of a feature freeze ... is that going to apply at the end of the commitfest? Feature freeze was used to discourage the submission of very big patches shortly before beta. The commit fest process has IMO

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Peter Eisentraut
On tor, 2010-01-21 at 19:45 -0500, Robert Haas wrote: Well, that does seem to be endorsing a sort of two-tiered system. In those words, yes, it's a multi-tiered system. The aim of the commit fests is to make the lower tier more effective, but not necessarily to bring the upper tier to a near

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 8:40 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2010-01-21 at 18:05 -0500, Andrew Dunstan wrote: Well, we used to have the idea of a feature freeze ... is that going to apply at the end of the commitfest? Feature freeze was used to discourage the submission of

Re: [HACKERS] Fix auto-prepare #2

2010-01-22 Thread Michael Meskes
Takahiro-san, Good. I think the patch is ready to commit. Thanks for reviewing it. I just committed the patch. A comment for committer (Michael?) : I was cofused by the AddStmtToCache's 2nd argument char *stmtID because it doesn't have a const. Should it be const char * ? If the argument

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Greg Stark
On Thu, Jan 21, 2010 at 4:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: You're poking into a data structure you shouldn't be poking into: /* Plans are opaque structs for standard users of SPI */ typedef struct _SPI_plan *SPIPlanPtr; I hardly think that keeping yourself at arm's length from the

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Alexey Klyukin
On Jan 22, 2010, at 2:55 AM, Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Jim Nasby wrote: Why does warn; in plperl log as NOTICE in Postgres? Where would you like the warning to go? This has been this way for nearly 5 years,

Re: [HACKERS] primary key error message

2010-01-22 Thread Simon Riggs
On Thu, 2010-01-21 at 23:22 +0200, Peter Eisentraut wrote: On tor, 2010-01-21 at 15:51 -0500, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Jan 21, 2010 at 3:30 PM, Peter Eisentraut pete...@gmx.net wrote: Here is a small patch that changes the error message

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Andrew Dunstan
Robert Haas wrote: On Fri, Jan 22, 2010 at 8:40 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2010-01-21 at 18:05 -0500, Andrew Dunstan wrote: Well, we used to have the idea of a feature freeze ... is that going to apply at the end of the commitfest? Feature freeze was

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Devrim GÜNDÜZ
On Fri, 2010-01-22 at 09:10 -0500, Robert Haas wrote: I'm not sure whether you're stating a position that's been agreed to by -core or some other group, or just expressing your own opinion, but I think feature freeze should be the beginning of the last CommitFest, not the end. Was is

Re: [HACKERS] primary key error message

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 9:22 AM, Simon Riggs si...@2ndquadrant.com wrote: On Thu, 2010-01-21 at 23:22 +0200, Peter Eisentraut wrote: On tor, 2010-01-21 at 15:51 -0500, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Jan 21, 2010 at 3:30 PM, Peter Eisentraut pete...@gmx.net

Re: [HACKERS] Standby server lagging behind

2010-01-22 Thread Kevin Grittner
Huda Booley (h...@careerjunction.co.za) h...@careerjunction.co.za wrote: These get copied to the standby so its all there, just not being applied fast enough. If the files are there and are not applying fast enough, it's probably because on the source machine you can have multiple

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 9:13 AM, Alexey Klyukin al...@waki.ru wrote: I think elog(WARNING) is less surprising for the end-user, unless there's an objection strong enough to include it into the documentation :) I think the main possible objection would what Simon just wrote on the other thread

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Why does warn; in plperl log as NOTICE in Postgres? *shrug* I don't have a strong opinion about it, and it's pretty easy to change, if there's a consensus we should. I have certainly found over the years that perl warnings from some modules

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Robert Haas
2010/1/22 Devrim GÜNDÜZ dev...@gunduz.org: On Fri, 2010-01-22 at 09:10 -0500, Robert Haas wrote: I'm not sure whether you're stating a position that's been agreed to by -core or some other group, or just expressing your own opinion, but I think feature freeze should be the beginning of the

Re: [HACKERS] primary key error message

2010-01-22 Thread Peter Eisentraut
On fre, 2010-01-22 at 14:22 +, Simon Riggs wrote: Stable software isn't just software that doesn't break, it requires IIABDFI as well. Yeah, I don't buy that. That would mean that you can never do maintenance, refactoring, or polishing. You basically just wait for the system to die a

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 As far as I can see, there is absolutely zero reason to care about whether the product is called Postgres or PostgreSQL. Sorry, but names matter.

Re: [HACKERS] ECPG patch 4.1, out-of-scope cursor support in native mode

2010-01-22 Thread Michael Meskes
diff -dcrpN pgsql.orig/src/interfaces/ecpg/test/expected/compat_informix-struct.c pgsql.4.1/src/interfaces/ecpg/test/expected/compat_informix-struct.c ... + /* Test DECLARE ... SELECT ... INTO with struct type */ + + ECPGset_var( 0, ( myvar ), __LINE__);\ + ECPGset_var( 1, (

Re: [HACKERS] primary key error message

2010-01-22 Thread Simon Riggs
On Fri, 2010-01-22 at 16:50 +0200, Peter Eisentraut wrote: On fre, 2010-01-22 at 14:22 +, Simon Riggs wrote: Stable software isn't just software that doesn't break, it requires IIABDFI as well. Yeah, I don't buy that. That would mean that you can never do maintenance, refactoring, or

Re: [HACKERS] primary key error message

2010-01-22 Thread Peter Eisentraut
On fre, 2010-01-22 at 15:10 +, Simon Riggs wrote: I merely ask that you consider the non-zero cost of such changes as well as the benefit. Not all change is worthwhile, even if the change can be made quickly and with little effect on the stability of the software. Right, that's why I

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Mark Mielke
On 01/22/2010 09:52 AM, Greg Sabino Mullane wrote: Well, this *was* posted to -hackers and not -advocacy, but advocacy, mind share, and many other non-hacking-on-the-base-code things matter too. And frankly, our name is one of our *top* problems. Perhaps you've never had to explain to

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Brendan Jurd
2010/1/23 Mark Mielke m...@mark.mielke.cc: Calling it PostgreSQL, makes it very clear to the uninformed masses where the product fits in a product map. Tell an executive of a company Postgres, and they would ask what is it? Tell them PostgreSQL, and they'll say is that like Oracle? The second

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Alexey Klyukin
On Jan 22, 2010, at 4:38 PM, Robert Haas wrote: On Fri, Jan 22, 2010 at 9:13 AM, Alexey Klyukin al...@waki.ru wrote: I think elog(WARNING) is less surprising for the end-user, unless there's an objection strong enough to include it into the documentation :) I think the main possible

Re: [HACKERS] plpythonu DO support (inline call handler)

2010-01-22 Thread Peter Eisentraut
On tis, 2009-11-17 at 18:48 +0200, Valtonen, Hannu wrote: The attached patch adds support for DO clause in plpythonu. It was heavily inspired by the plperl and plpgsql inline handler code. committed -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] Standby server lagging behind

2010-01-22 Thread Greg Stark
On Fri, Jan 22, 2010 at 2:37 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: I think I have some recall of improvements to that in the 8.4 release, so an upgrade might help. There was a standalone program which you can call from your recovery script to prefetch the blocks needed to

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Aidan Van Dyk
* Brendan Jurd dire...@gmail.com [100122 10:29]: Holy query language, Batman! Do you mean to tell me that the uninformed masses you interact with have an understanding of what SQL means? I am skeptical of this claim, but if true, you must have access to the most spectacularly informed

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: I'm not sure whether you're stating a position that's been agreed to by -core or some other group, or just expressing your own opinion, but I think feature freeze should be the beginning of the last CommitFest, not the end. I think traditionally we

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Simon Riggs
On Fri, 2010-01-22 at 10:56 -0500, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type,

[HACKERS] restructuring alter table privilege checks (was: remove redundant ownership checks)

2010-01-22 Thread Robert Haas
On Thu, Dec 17, 2009 at 10:09 PM, Stephen Frost sfr...@snowman.net wrote: * Tom Lane (t...@sss.pgh.pa.us) wrote: KaiGai Kohei kai...@ak.jp.nec.com writes: [ patch to remove EnableDisableRule's permissions check ] I don't particularly like this patch, mainly because I disagree with randomly

Re: commit fests (was Re: [HACKERS] primary key error message)

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 11:19 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: I'm not sure whether you're stating a position that's been agreed to by -core or some other group, or just expressing your own opinion, but I think feature freeze should be the

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: Anyway, there already was another way of doing this, so it shall be done that way instead. The beauty of a pluggable architecture is that one does not need approval to implement customer solutions. If you're talking about a bundle that you're shipping

Re: [HACKERS] warn in plperl logs as... NOTICE??

2010-01-22 Thread Andrew Dunstan
Alexey Klyukin wrote: On Jan 22, 2010, at 4:38 PM, Robert Haas wrote: On Fri, Jan 22, 2010 at 9:13 AM, Alexey Klyukin al...@waki.ru wrote: I think elog(WARNING) is less surprising for the end-user, unless there's an objection strong enough to include it into the documentation :)

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Leonardo F
So, if I'm not mistaken: hash indexes - can't be used in CLUSTER gin indexes - can't be used in CLUSTER that leaves: btree - ok expression btree - I have to find a way to compute the expression for each tuple: hints? gist - how can I get something comparable by tuplesort? Or should I rule it

Re: [HACKERS] restructuring alter table privilege checks (was: remove redundant ownership checks)

2010-01-22 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: * Tom Lane (t...@sss.pgh.pa.us) wrote: I don't particularly like this patch, mainly because I disagree with randomly removing permissions checks without any sort of plan about where they ought to go. [ a plan for rearranging ALTER TABLE's checks ]

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Simon Riggs
On Fri, 2010-01-22 at 11:33 -0500, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: Anyway, there already was another way of doing this, so it shall be done that way instead. The beauty of a pluggable architecture is that one does not need approval to implement customer solutions.

[HACKERS] psql tab completion recently broken?

2010-01-22 Thread Kevin Grittner
I just updated my source code and it no longer seems to work to type the following, and I'm pretty sure I was using it with a checkout from less than 24 hours ago: select * from pg_lo[Tab] -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] psql tab completion recently broken?

2010-01-22 Thread Kevin Grittner
Kevin Grittner kevin.gritt...@wicourts.gov wrote: I just updated my source code and it no longer seems to work to type the following, and I'm pretty sure I was using it with a checkout from less than 24 hours ago: Never mind. My mistake. -Kevin -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Access to dynamic SQL in PL/pgSQL

2010-01-22 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: So a dynamic query hook. When called, the hook would give access to the query text actually executed. Existing plugins wouldn't know about the hook, so would never call it, so the language run time would bypass that hook altogether. Newer versions of

Re: [HACKERS] ECPG patch 4.1, out-of-scope cursor support in native mode

2010-01-22 Thread Boszormenyi Zoltan
Michael Meskes írta: diff -dcrpN pgsql.orig/src/interfaces/ecpg/test/expected/compat_informix-struct.c pgsql.4.1/src/interfaces/ecpg/test/expected/compat_informix-struct.c ... +/* Test DECLARE ... SELECT ... INTO with struct type */ + +ECPGset_var( 0, ( myvar ), __LINE__);\ +

Re: [HACKERS] [COMMITTERS] pgsql: Replace ALTER TABLE ...

2010-01-22 Thread Devrim GÜNDÜZ
On Fri, 2010-01-22 at 16:40 +, Robert Haas wrote: Log Message: --- Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism. I think this broke doc builds: openjade -wall -wno-unused-param -wno-empty -wfully-tagged -D . -D . -c

Re: [HACKERS] [COMMITTERS] pgsql: Replace ALTER TABLE ...

2010-01-22 Thread Robert Haas
2010/1/22 Devrim GÜNDÜZ dev...@gunduz.org: On Fri, 2010-01-22 at 16:40 +, Robert Haas wrote: Log Message: --- Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism. I think this broke doc builds: Dang, how'd that happen? I could have sworn I tested

Re: [HACKERS] [COMMITTERS] pgsql: Replace ALTER TABLE ...

2010-01-22 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: 2010/1/22 Devrim GÜNDÜZ dev...@gunduz.org: I think this broke doc builds: Dang, how'd that happen? I could have sworn I tested this. Some versions of docbook are pickier than others --- maybe yours didn't complain? regards,

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Tom Lane
Leonardo F m_li...@yahoo.it writes: gist - how can I get something comparable by tuplesort? Or should I rule it out from the seq scan + sort path? Rule it out. Note you should be looking at pg_am.amcanorder, not hardwiring knowledge of particular index types.

Re: [HACKERS] [COMMITTERS] pgsql: Replace ALTER TABLE ...

2010-01-22 Thread Robert Haas
2010/1/22 Tom Lane t...@sss.pgh.pa.us: Robert Haas robertmh...@gmail.com writes: 2010/1/22 Devrim GÜNDÜZ dev...@gunduz.org: I think this broke doc builds: Dang, how'd that happen?  I could have sworn I tested this. Some versions of docbook are pickier than others --- maybe yours didn't

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Leonardo F
Note you should be looking at pg_am.amcanorder, not hardwiring knowledge of particular index types. Ok. Would it make sense to use FormIndexDatum to get the index value to be used by tuplesort? I'm having trouble avoiding the call to _bt_mkscankey_nodata to get the scanKeys... that

Re: [HACKERS] attoptions

2010-01-22 Thread Robert Haas
On Thu, Jan 21, 2010 at 10:24 AM, Alex Hunsaker bada...@gmail.com wrote: On Thu, Jan 21, 2010 at 07:30, Robert Haas robertmh...@gmail.com wrote: On Thu, Jan 21, 2010 at 12:57 AM, Alex Hunsaker bada...@gmail.com wrote: Seems to me a comment about the above might be nice.  Something like /*

Re: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-01-22 Thread Tom Lane
Leonardo F m_li...@yahoo.it writes: Would it make sense to use FormIndexDatum to get the index value to be used by tuplesort? That would probably work. You might want to look at the code associated with the recently-added exclusion constraint feature; that also has a need to reproduce index

[HACKERS] Review: listagg aggregate

2010-01-22 Thread David E . Wheeler
Pavel, My review of your listagg patch. Submission Review - * The diff is a context diff and applies cleanly to HEAD (with just two hunks offset by 2 lines each). * There is documentation, though I'm not sure it needs to be mentioned in the string functions documentation. No

Re: [HACKERS] quoting psql varible as identifier

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 7:19 AM, Pavel Stehule pavel.steh...@gmail.com wrote: here is new variant. Add scan_state flag valid and enhance protection against execution broken statement. This doesn't make sense to me. You've changed the way \set is handled - in a way that doesn't seem

Re: [HACKERS] Git out of sync vs. CVS

2010-01-22 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: So add me to the list of people who think that if these are going to be recurring, we should look at moving from cvs to git as soon as 9.0 is released. The gating factor is not release schedule; it is the still-unaddressed tasks that must be

Re: [HACKERS] review: More frame options in window functions

2010-01-22 Thread Robert Haas
On Tue, Jan 19, 2010 at 3:02 PM, Hitoshi Harada umi.tan...@gmail.com wrote: 2010/1/19 Hitoshi Harada umi.tan...@gmail.com: Yeah, that's my point, too. The planner has to distinguish four from sort pathkeys and to teach the executor the simple information which column should be used to

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Tom Lane
KaiGai Kohei kai...@ak.jp.nec.com writes: The attached patch is a revised version. I'm inclined to wonder whether this patch doesn't prove that we've reached the end of the line for the current representation of blobs in pg_dump archives. The alternative that I'm thinking about is to treat each

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Now the argument against that is that it won't scale terribly well to situations with very large numbers of blobs. However, I'm not convinced that the current approach of cramming them all into one TOC entry scales so well either. If your large objects

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: We've heard of people with many tens of thousands of tables, and pg_dump speed didn't seem to be a huge bottleneck for them (at least not in recent versions). So I'm feeling we should not dismiss the idea

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Do you have the opportunity to try an experiment on hardware similar to what you're running that on? Create a database with 7 million tables and see what the dump/restore times are like, and whether pg_dump/pg_restore appear to be CPU-bound or

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Tom Lane t...@sss.pgh.pa.us wrote: Do you have the opportunity to try an experiment on hardware similar to what you're running that on? Create a database with 7 million tables and see what the dump/restore times are like, and whether

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Empty is fine. I'll get started. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] pg_listener entries deleted under heavy NOTIFY load only on Windows

2010-01-22 Thread Radu Ilie
On a Windows server under heavy load of NOTIFY events, entries in pg_listener table for some events are deleted. It is like UNLISTEN was called. PostgreSQL version: 8.3.9. Operating System: Windows XP. PostgreSQL believes that if it fails to notify a listener (by signaling the respective

Re: [HACKERS] commit fests

2010-01-22 Thread Dimitri Fontaine
Robert Haas robertmh...@gmail.com writes: I think feature freeze should be the beginning of the last CommitFest, not the end. So you still want 3 CF per cycle rather than 4? http://archives.postgresql.org/pgsql-hackers/2009-12/msg02355.php 3 CF and a FixFest… -1 from me, if there's an open

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread Kevin Grittner
Kevin Grittner kevin.gritt...@wicourts.gov wrote: I'll get started. After a couple false starts, the creation of the millions of tables is underway. At the rate it's going, it won't finish for 8.2 hours, so I'll have to come in and test the dump tomorrow morning. -Kevin -- Sent via

Re: [HACKERS] commit fests

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 5:15 PM, Dimitri Fontaine dfonta...@hi-media.com wrote: Robert Haas robertmh...@gmail.com writes: I think feature freeze should be the beginning of the last CommitFest, not the end. So you still want 3 CF per cycle rather than 4?  

[HACKERS] Sugerencia de opcion

2010-01-22 Thread Informatica-Cooperativa Cnel. Oviedo
Buenos Dias todos, Soy un usuario de postgres de Paraguay, consulto sobre la posibilidad de inclucion en la futura version la siguiente sentencia(Uso de alias en la condicion HAVING ): SELECT id, sum(salario) as SumaSalario FROM salarios GROUP BY id HAVING SumaSalario500;

Re: [HACKERS] commit fests

2010-01-22 Thread Peter Eisentraut
On fre, 2010-01-22 at 18:05 -0500, Robert Haas wrote: and start talking about how we can create an environment where patch authors can get their work committed reasonably quickly (assuming it's good, of course) and released within some reasonable time frame after that (like, say, within a

Re: [HACKERS] commit fests

2010-01-22 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On fre, 2010-01-22 at 18:05 -0500, Robert Haas wrote: Any ideas? The lower bound on the release cycle is about 12 months right now because we intend to support old versions for 5 years, and 5 or 6 branches at once is about the most anyone can handle.

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Mark Mielke
On 01/22/2010 10:57 AM, Aidan Van Dyk wrote: * Brendan Jurddire...@gmail.com [100122 10:29]: Holy query language, Batman! Do you mean to tell me that the uninformed masses you interact with have an understanding of what SQL means? I am skeptical of this claim, but if true, you must have

Re: [HACKERS] commit fests

2010-01-22 Thread Andrew Dunstan
Tom Lane wrote: Another problem is that it's very debatable whether users (as opposed to developers) want a fast release cycle. Some of that reluctance to update might dissipate if we had a better upgrade-in-place story, but by no means all of it. People don't want to have to retest their

Re: [HACKERS] commit fests

2010-01-22 Thread Robert Haas
On Fri, Jan 22, 2010 at 7:50 PM, Tom Lane t...@sss.pgh.pa.us wrote: Peter Eisentraut pete...@gmx.net writes: On fre, 2010-01-22 at 18:05 -0500, Robert Haas wrote: Any ideas? The lower bound on the release cycle is about 12 months right now because we intend to support old versions for 5

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread David E. Wheeler
On Jan 22, 2010, at 4:54 PM, Mark Mielke wrote: MS SQL, MySQL, SQLite - do they have advocacy problems due to the SQL in their name? I think it is the opposite. SQL in the name almost grants legitimacy to them as products. Dropping the SQL has the potential to increase confusion. What is a

Re: [HACKERS] Miscellaneous changes to plperl [PATCH]

2010-01-22 Thread Alex Hunsaker
On Thu, Jan 14, 2010 at 09:07, Tim Bunce tim.bu...@pobox.com wrote: - Allow (ineffective) use of 'require' in plperl    If the required module is not already loaded then it dies.    So use strict; now works in plperl. [ BTW I think this is awesome! ] Id vote for use warnings; as well. -

[HACKERS] Improving the accuracy of estimate_num_groups()

2010-01-22 Thread Tom Lane
I was just poking at the test case provided by Allen Johnson in bug #5294. The essence of the complaint is that the planner is choosing a sort-and-GroupAggregate plan when a HashAggregate-and-then-sort plan would be faster, because the aggregation steps are roughly the same speed either way while

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Tom Lane
David E. Wheeler da...@kineticode.com writes: On Jan 22, 2010, at 4:54 PM, Mark Mielke wrote: MS SQL, MySQL, SQLite - do they have advocacy problems due to the SQL in their name? I think it is the opposite. SQL in the name almost grants legitimacy to them as products. Dropping the SQL has

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Andrew Chernow
Tom Lane wrote: David E. Wheeler da...@kineticode.com writes: On Jan 22, 2010, at 4:54 PM, Mark Mielke wrote: MS SQL, MySQL, SQLite - do they have advocacy problems due to the SQL in their name? I think it is the opposite. SQL in the name almost grants legitimacy to them as products.

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Pavel Stehule
2010/1/23 Andrew Chernow a...@esilo.com: Tom Lane wrote: David E. Wheeler da...@kineticode.com writes: On Jan 22, 2010, at 4:54 PM, Mark Mielke wrote: MS SQL, MySQL, SQLite - do they have advocacy problems due to the SQL in their name? I think it is the opposite. SQL in the name almost

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Grzegorz Jaskiewicz
think also how people use SQL word , when calling ms sql server. They would just say 'sql server' , and to some I had to explain that the little greedy company didn't actually invented sql, hence it should be called ms sql server... so, -1 for dropping SQL word from me. ... and maybe the

Re: [HACKERS] restructuring alter table privilege checks (was: remove redundant ownership checks)

2010-01-22 Thread KaiGai Kohei
(2010/01/23 1:27), Robert Haas wrote: So, what if we treat these two cases separately? The part-B checks - on the other operations involved in ALTER TABLE - are by definition idiosyncratic. What type of object we're checking and what permission we're checking for is inextricably bound up with

Re: [HACKERS] Largeobject Access Controls (r2460)

2010-01-22 Thread KaiGai Kohei
(2010/01/23 5:12), Tom Lane wrote: KaiGai Koheikai...@ak.jp.nec.com writes: The attached patch is a revised version. I'm inclined to wonder whether this patch doesn't prove that we've reached the end of the line for the current representation of blobs in pg_dump archives. The alternative

Re: [HACKERS] review: More frame options in window functions

2010-01-22 Thread Hitoshi Harada
2010/1/23 Robert Haas robertmh...@gmail.com: On Tue, Jan 19, 2010 at 3:02 PM, Hitoshi Harada umi.tan...@gmail.com wrote: 2010/1/19 Hitoshi Harada umi.tan...@gmail.com: Yeah, that's my point, too. The planner has to distinguish four from sort pathkeys and to teach the executor the simple