Re: [HACKERS] join removal

2010-03-29 Thread Dimitri Fontaine
reducejoins.c ? flattenjoins.c ? filterjoins.c ? -- dim Le 28 mars 2010 à 22:12, Tom Lane t...@sss.pgh.pa.us a écrit : Robert Haas robertmh...@gmail.com writes: On Sun, Mar 28, 2010 at 2:10 PM, Tom Lane t...@sss.pgh.pa.us wrote: joinremoval.c ? Maybe, except as I mentioned in the email

Re: [HACKERS] GSoC Query

2010-03-29 Thread Greg Smith
gaurav gupta wrote: My idea is to add a functionality of Auto tuning and Auto Indexing/ Reindexing in DB languages. Ah, the classic request to start with the tuning and index wizards. Really fun to work on, always lots of interest in it. Here's the thing: projects in this area attract

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Dimitri Fontaine
Hi, Joseph Adams joeyadams3.14...@gmail.com writes: As for reinventing the wheel, I'm in the process of writing yet another JSON implementation simply because I didn't find the other ones I looked at palatable. Even this one (ANSI C, MIT Licenced)? cJSON -- An ultra-lightweight, portable,

Re: [HACKERS] More idle thoughts

2010-03-29 Thread Simon Riggs
On Sun, 2010-03-28 at 12:47 -0400, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: On Fri, 2010-03-26 at 18:59 +, Greg Stark wrote: It occurs to me we could do the same for CHECK_FOR_INTERRUPTS() by conditionally having it call a function which calls gettimeofday and

Re: [HACKERS] join removal

2010-03-29 Thread Pavel Stehule
Hello is any reason why join removal doesn't remove useless relation b? postgres=# \d a Table public.a Column | Type | Modifiers +-+--- a | integer | Indexes: a_a_idx UNIQUE, btree (a) postgres=# \d b Table public.b Column | Type |

Re: [HACKERS] five-key syscaches

2010-03-29 Thread Joachim Wieland
On Mon, Mar 29, 2010 at 12:32 AM, Robert Haas robertmh...@gmail.com wrote: Per previous discussion, PFA a patch to change the maximum number of keys for a syscache from 4 to 5. http://archives.postgresql.org/pgsql-hackers/2010-02/msg01105.php This is intended for application to 9.1, and is

Re: [HACKERS] join removal

2010-03-29 Thread Marko Tiikkaja
On 2010-03-29 11:19 +0200, Pavel Stehule wrote: postgres=# explain select a from a left join b on true; This is effectively a cross join and it would give wrong answers. Try SELECT a FROM a LEFT JOIN b ON a.a = b.b; Regards, Marko Tiikkaja -- Sent via pgsql-hackers mailing list

Re: [HACKERS] join removal

2010-03-29 Thread Pavel Stehule
2010/3/29 Marko Tiikkaja marko.tiikk...@cs.helsinki.fi: On 2010-03-29 11:19 +0200, Pavel Stehule wrote: postgres=# explain select  a from a left join b on true; you have a true. I forgot SELECT DISTINCT regards Pavel This is effectively a cross join and it would give wrong answers.  Try

[HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
We have planner method parameters for many important parts of the planner. We don't have any parameter for join removal, AFAIK. The first question I get asked is can I see the tables it removed?. This has been asked of me 3 times now this year, always first question. Same issue applies to

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Sun, Mar 28, 2010 at 4:40 PM, Josh Berkus j...@agliodbs.com wrote: We've got two locations and some individuals signed up for a test-fest this weekend. Would it be possible to do an alpha release this week? It would really help to be testing later code than Alpha4. I'm

[HACKERS] proposal - structured funcid and lineno as new fields in error message

2010-03-29 Thread Pavel Stehule
Hello can we add well structured information about function id and lineno to ErrorData? Actually we sending some info - but formated as string and only when Log_error_verbosity = PGERROR_VERBOSE. I hope, so this feature can help to some interactive GUI managers as pgAdmin, and to psql too.

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Peter Eisentraut
On sön, 2010-03-28 at 23:24 -0400, Joseph Adams wrote: Thus, here's an example of how (in my opinion) character sets and such should be handled in the JSON code: Suppose the client's encoding is UTF-16, and the server's encoding is Latin-1. When JSON is stored to the database: 1. The

Re: [HACKERS] Patch for 9.1: initdb -C option

2010-03-29 Thread Peter Eisentraut
On mån, 2010-03-29 at 00:04 -0500, David Christensen wrote: Enclosed is a patch to add a -C option to initdb to allow you to easily append configuration directives to the generated postgresql.conf file for use in programmatic generation. I like this idea, but please use small -c for

Re: [HACKERS] [BUGS] BUG #5394: invalid declspec for PG_MODULE_MAGIC

2010-03-29 Thread Takahiro Itagaki
Vladimir Barzionov snego.bar...@gmail.com wrote: Same problem was already discussed for example here http://dbaspot.com/forums/postgresql/393683-re-general-custom-c-function-palloc-broken.html Looks like the simplest way for correcting the issue is declaring additional macro (something

Re: [HACKERS] GSoC Query

2010-03-29 Thread Gokulakannan Somasundaram
Similarly using the no. of select hits on a table we can check that if maximum no. of times it is on a non-index field we can index on that field to make select faster. It's impractical to figure out where indexes should go at without simulating what the optimizer would then do with

[HACKERS] Using HStore type in TSearch

2010-03-29 Thread Łukasz Dejneka
Hi, I've asked this question in novice group and another Postgres forum, but didn't get any help. What I want to do is to use HStore data type (namely the HStore keys) in TSearch. I don't want use TSVector and the original ts_match_vq function, because I want to be able to control exact values

[HACKERS] Problems with variable cursorname in ecpg

2010-03-29 Thread Michael Meskes
Hi, I did some more testing on ecpg and found that allowing variables as cursor names seems to produce more problems than I anticipated. But then maybe it's just some missing checks to throw out error messages. Anyway, I attach a small test program that, from my understanding, should work, but

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Andrew Dunstan
Robert Haas wrote: I feel pretty strongly that the data should be stored in the database in the format in which it will be returned to the user - any conversion which is necessary should happen on the way in. I am not 100% sure to what extent we should attempt to canonicalize the input and to

[HACKERS] Known Issues Page

2010-03-29 Thread Tharakan, George (GE Healthcare)
Hi, I have been using PostGreSQL as a part of our healthcare product. As an important part of releasing a stable product it is important to also document the known issues found in a PostGRE release. I would be grateful if someone could forward me to the Known Issues Page(if any). On these lines

Re: [HACKERS] Problems with variable cursorname in ecpg

2010-03-29 Thread Boszormenyi Zoltan
Hi, Michael Meskes írta: Hi, I did some more testing on ecpg and found that allowing variables as cursor names seems to produce more problems than I anticipated. But then maybe it's just some missing checks to throw out error messages. Anyway, I attach a small test program that, from my

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 4:33 AM, Simon Riggs si...@2ndquadrant.com wrote: We have planner method parameters for many important parts of the planner. We don't have any parameter for join removal, AFAIK. The first question I get asked is can I see the tables it removed?. This has been asked of

Re: [HACKERS] five-key syscaches

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 4:21 AM, Joachim Wieland j...@mcknight.de wrote: On Mon, Mar 29, 2010 at 12:32 AM, Robert Haas robertmh...@gmail.com wrote: Per previous discussion, PFA a patch to change the maximum number of keys for a syscache from 4 to 5.

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Mar 29, 2010 at 4:33 AM, Simon Riggs si...@2ndquadrant.com wrote: So I think we need a parameter for join removal also. I had this in my original patch but Tom wanted it taken out. And I still don't want it. We are NOT going in the direction

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Alvaro Herrera
Tom Lane escribió: Robert Haas robertmh...@gmail.com writes: On Mon, Mar 29, 2010 at 4:33 AM, Simon Riggs si...@2ndquadrant.com wrote: So I think we need a parameter for join removal also. I had this in my original patch but Tom wanted it taken out. And I still don't want it. We are

Re: [HACKERS] Using HStore type in TSearch

2010-03-29 Thread Tom Lane
=?ISO-8859-2?Q?=A3ukasz_Dejneka?= l.dejn...@gmail.com writes: What I want to do is to use HStore data type (namely the HStore keys) in TSearch. I don't want use TSVector and the original ts_match_vq function, because I want to be able to control exact values that are passed to the search and

[HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Joachim Wieland
People have been talking about a parallel version of pg_dump a few times already. I have been working on some proof-of-concept code for this feature every now and then and I am planning to contribute this for 9.1. There are two main issues with a parallel version of pg_dump: The first one is

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread David Fetter
On Mon, Mar 29, 2010 at 04:46:48PM +0200, Joachim Wieland wrote: People have been talking about a parallel version of pg_dump a few times already. I have been working on some proof-of-concept code for this feature every now and then and I am planning to contribute this for 9.1. There are

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: It seems that what's really needed is some debug output to be able to find out what it did. Isn't EXPLAIN good enough? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 10:36 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Mar 29, 2010 at 4:33 AM, Simon Riggs si...@2ndquadrant.com wrote: So I think we need a parameter for join removal also. I had this in my original patch but Tom wanted it

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Jaime Casanova
On Mon, Mar 29, 2010 at 10:42 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: It seems that what's really needed is some debug output to be able to find out what it did. +1, i was preparing an env for testing this but in the while i was thinking how can i know what happens... counting

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: And for the record, I believe I find it rather amusing that you're asking me if I have the faintest idea how many there would be. Actually that was directed more at Simon. I venture to say that after yourself I might be the person who knows this code

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 11:23 AM, Jaime Casanova jcasa...@systemguards.com.ec wrote: On Mon, Mar 29, 2010 at 10:42 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: It seems that what's really needed is some debug output to be able to find out what it did. +1, i was preparing an env for

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 11:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: And for the record, I believe I find it rather amusing that you're asking me if I have the faintest idea how many there would be. Actually that was directed more at Simon. I

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 10:46 AM, Joachim Wieland j...@mcknight.de wrote: - There are ideas on how to solve the issue with the consistent snapshot but in the end you can always solve it by stopping your application(s). I actually assume that whenever people are interested in a very fast dump,

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Jaime Casanova
On Mon, Mar 29, 2010 at 11:29 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, Mar 29, 2010 at 11:23 AM, Jaime Casanova jcasa...@systemguards.com.ec wrote: On Mon, Mar 29, 2010 at 10:42 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: It seems that what's really needed is some debug

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: OK, I'll write a patch for that; and a consensus emerges that we should also have enable_joinremoval, then I will add that as well. I think the only argument for NOT having enable_joinremoval is that you can always modify the query to say SELECT *

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 11:46 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: OK, I'll write a patch for that; and a consensus emerges that we should also have enable_joinremoval, then I will add that as well.  I think the only argument for NOT having

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sun, Mar 28, 2010 at 11:24 PM, Joseph Adams joeyadams3.14...@gmail.com wrote: My reasoning for It should be built-in is:  * It would be nice to have a built-in serialization format that's available by default.  * It might be a little faster

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Greg Smith
Robert Haas wrote: The query planner is a great piece of code but it is not so transparently simple that it doesn't need debugging or instrumentation, and why did the planner do X has got to be one of our top ten most-frequently asked questions. Debugging and instrumentation are two slightly

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 12:02 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Sun, Mar 28, 2010 at 11:24 PM, Joseph Adams joeyadams3.14...@gmail.com wrote: My reasoning for It should be built-in is:  * It would be nice to have a built-in serialization

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 12:03 PM, Greg Smith g...@2ndquadrant.com wrote: Robert Haas wrote: The query planner is a great piece of code but it is not so transparently simple that it doesn't need debugging or instrumentation, and why did the planner do X has got to be one of our top ten

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Mon, Mar 29, 2010 at 12:03 PM, Greg Smith g...@2ndquadrant.com wrote: at the top of my list in this area for 9.1 is to track down the rumored patch that exports information about the rejected plans considered and get that comitted.  That always

[HACKERS] psql: edit function, show function commands patch

2010-03-29 Thread Pavel Stehule
Hello this simple patch allow to specify cursor row when some function is opened in editor. \e aaa.txt \a aaa.txt 3 ... move cursor on 3nd line of text \ef foo \ef foo 3 ... move cursor on 3nd line of function body \sf foo ... show function body \sf+ foo ... show function body - use line numbers

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 12:17 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Mon, Mar 29, 2010 at 12:03 PM, Greg Smith g...@2ndquadrant.com wrote: at the top of my list in this area for 9.1 is to track down the rumored patch that exports information about

Re: [HACKERS] proposal - structured funcid and lineno as new fields in error message

2010-03-29 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: can we add well structured information about function id and lineno to ErrorData? The idea that I was toying with was to report the function OID and line number, which might as well be two separate fields rather than messing around with anything

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Greg Smith
Tom Lane wrote: The problem with this line of thought is that it imagines you can look at worked-out alternative plans. You can't, because the planner doesn't pursue rejected alternatives that far (and you'd not want to wait long enough for it to do so...) Not on any production system,

Re: [HACKERS] proposal - structured funcid and lineno as new fields in error message

2010-03-29 Thread Pavel Stehule
2010/3/29 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: can we add well structured information about function id and lineno to ErrorData? The idea that I was toying with was to report the function OID and line number, which might as well be two separate fields

Re: [HACKERS] Using HStore type in TSearch

2010-03-29 Thread Łukasz Dejneka
2010/3/29 Tom Lane t...@sss.pgh.pa.us =?ISO-8859-2?Q?=A3ukasz_Dejneka?= l.dejn...@gmail.com writes: What I want to do is to use HStore data type (namely the HStore keys) in TSearch. I don't want use TSVector and the original ts_match_vq function, because I want to be able to control exact

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Mon, Mar 29, 2010 at 10:46 AM, Joachim Wieland j...@mcknight.de wrote: [...] - Regarding the output of pg_dump I am proposing two solutions. The first one is to introduce a new archive type directory where each table and each blob is a file in a directory, similar to the

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 11:27 -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: And for the record, I believe I find it rather amusing that you're asking me if I have the faintest idea how many there would be. Actually that was directed more at Simon. I think you should drop

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Josh Berkus
On 3/28/10 8:52 PM, Hitoshi Harada wrote: There's another choice, called BSON. http://www.mongodb.org/display/DOCS/BSON I've not researched it yet deeply, it seems reasonable to be stored in databases as it is invented for MongoDB. I wouldn't take that for granted. The MongoDB project

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 09:37 -0400, Robert Haas wrote: In many cases it's not horribly difficult to work around because you can do SELECT * FROM ... instead of your original select list, but there might be some cases with multiple levels of views where it isn't that easy. I think it would be

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 1:16 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: Robert Haas wrote: On Mon, Mar 29, 2010 at 10:46 AM, Joachim Wieland j...@mcknight.de wrote: [...] - Regarding the output of pg_dump I am proposing two solutions. The first one is to introduce a new

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 11:46 -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: OK, I'll write a patch for that; and a consensus emerges that we should also have enable_joinremoval, then I will add that as well. I think the only argument for NOT having enable_joinremoval is

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread David E. Wheeler
On Mar 29, 2010, at 9:02 AM, Tom Lane wrote: If this is going to end up being one fairly small C file implementing a spec that is not a moving target, I'd vote against depending on an external library instead, no matter how spiffy and license-compatible the external library might be. Perhaps

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Joseph Adams
On Mon, Mar 29, 2010 at 2:23 PM, David E. Wheeler da...@kineticode.com wrote: On Mar 29, 2010, at 9:02 AM, Tom Lane wrote: If this is going to end up being one fairly small C file implementing a spec that is not a moving target, I'd vote against depending on an external library instead, no

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Josh Berkus
or just use a specific recent snapshot and let people test that just in case it is not feasible doing a new alpha on short notice. Doesn't work if we want to test it on windows. And snaphsots have more compile dependancies than releases do. Also ... this isn't short notice. I requested a

Re: [HACKERS] booleans in recovery.conf

2010-03-29 Thread Simon Riggs
On Tue, 2010-03-23 at 19:43 -0400, Bruce Momjian wrote: Is there a reason that recovery.conf uses true/false, while postgresql.conf uses on/off? #recovery_target_inclusive = 'true' # 'true' or 'false' or are these settings more boolean for some reason? The code accepts

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Alex Hunsaker
On Mon, Mar 29, 2010 at 12:17, Simon Riggs si...@2ndquadrant.com wrote: You're not addressing the original point. I have been asked how would users know which tables have been removed and whether there is a way of checking that. Uhh... they wont be in the explain output... Seems simple

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: On Mon, Mar 29, 2010 at 12:17, Simon Riggs si...@2ndquadrant.com wrote: You're not addressing the original point. I have been asked how would users know which tables have been removed and whether there is a way of checking that.

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 2:52 PM, Josh Berkus j...@agliodbs.com wrote: or just use a specific recent snapshot and let people test that just in case it is not feasible doing a new alpha on short notice. Doesn't work if we want to test it on windows.  And snaphsots have more compile

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Josh Berkus
On 3/29/10 7:46 AM, Joachim Wieland wrote: I actually assume that whenever people are interested in a very fast dump, it is because they are doing some maintenance task (like migrating to a different server) that involves pg_dump. In these cases, they would stop their system anyway. Actually,

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Dimitri Fontaine
Tom Lane t...@sss.pgh.pa.us writes: If this is going to end up being one fairly small C file implementing a spec that is not a moving target, I'd vote against depending on an external library instead, no matter how spiffy and license-compatible the external library might be. My understanding

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Alex Hunsaker
On Mon, Mar 29, 2010 at 13:41, Simon Riggs si...@2ndquadrant.com wrote: Uhh... they wont be in the explain output...  Seems simple enough. That is exactly what I replied, though nobody felt that was a great answer. Maybe I missed it, but why exactly do they care? About the only reason I can

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: On Mon, Mar 29, 2010 at 12:17, Simon Riggs si...@2ndquadrant.com wrote: You're not addressing the original point. I have been asked how would users know which tables have been removed and whether

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 3:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: On Mon, Mar 29, 2010 at 12:17, Simon Riggs si...@2ndquadrant.com wrote: You're not addressing the original point. I have been

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: On 3/29/10 7:46 AM, Joachim Wieland wrote: I actually assume that whenever people are interested in a very fast dump, it is because they are doing some maintenance task (like migrating to a different server) that involves pg_dump. In these cases, they

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 15:55 -0400, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: On Mon, Mar 29, 2010 at 12:17, Simon Riggs si...@2ndquadrant.com wrote: You're not addressing the original point. I have been asked how would

Re: [HACKERS] Proposal: Add JSON support

2010-03-29 Thread Tom Lane
Dimitri Fontaine dfonta...@hi-media.com writes: Tom Lane t...@sss.pgh.pa.us writes: If this is going to end up being one fairly small C file implementing a spec that is not a moving target, I'd vote against depending on an external library instead, no matter how spiffy and license-compatible

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Simon Riggs
On Mon, 2010-03-29 at 13:54 -0600, Alex Hunsaker wrote: whatever happened to those hooks to auto create/recommend indexes? You haven't published them yet?? -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 4:11 PM, Tom Lane t...@sss.pgh.pa.us wrote: Josh Berkus j...@agliodbs.com writes: On 3/29/10 7:46 AM, Joachim Wieland wrote: I actually assume that whenever people are interested in a very fast dump, it is because they are doing some maintenance task (like migrating to

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Tom Lane
Alex Hunsaker bada...@gmail.com writes: It comes to mind you can probably do this with an plannerhook (whatever happened to those hooks to auto create/recommend indexes?) Uh, we made some hooks to let someone build an *external* module that would do such a thing. Whether anybody got anywhere

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Mon, Mar 29, 2010 at 2:52 PM, Josh Berkus j...@agliodbs.com wrote: or just use a specific recent snapshot and let people test that just in case it is not feasible doing a new alpha on short notice. Doesn't work if we want to test it on windows. And snaphsots have more

Re: [HACKERS] Parallel pg_dump for 9.1

2010-03-29 Thread Andrew Dunstan
Robert Haas wrote: It's completely possible that you could want to clone a server for dev and have more CPU and I/O bandwidth available than can be efficiently used by a non-parallel pg_dump. But certainly what Joachim is talking about will be a good start. I think there is merit to the

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 4:40 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: yeah but you also need people changing the website - and probably more important given that josh wants windows as well help from dave for doing a new windows installer :) True... well, I can't help with those

Re: [HACKERS] enable_joinremoval

2010-03-29 Thread Jaime Casanova
On Mon, Mar 29, 2010 at 3:57 PM, Robert Haas robertmh...@gmail.com wrote: On Mon, Mar 29, 2010 at 3:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: On Mon, Mar 29, 2010 at 12:17, Simon Riggs

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Peter Eisentraut
On sön, 2010-03-28 at 19:22 -0400, Robert Haas wrote: On Sun, Mar 28, 2010 at 4:40 PM, Josh Berkus j...@agliodbs.com wrote: We've got two locations and some individuals signed up for a test-fest this weekend. Would it be possible to do an alpha release this week? It would really help to be

Re: [HACKERS] GSoC

2010-03-29 Thread Robert Haas
On Mon, Mar 29, 2010 at 4:03 PM, Anindya Jyoti Roy anind...@iitk.ac.in wrote: I want to implement a image database system: This will have the following quality: 1 will store image along with the other attributes 2 the database search engine will be able to search for image also 3 it will list

Re: [HACKERS] GSoC

2010-03-29 Thread Josh Berkus
The idea crudely is the following: I want to implement a image database system: This will have the following quality: This seems fine, but I believe it's been done before. You might want to search for existing projects, and make an improvement on an existing project rather than starting

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Magnus Hagander
Last i heard from Dave on that topic is that there's no chance of that happening that quickly. He's on a plane now but I'm sure he'll confirm that when he lands. /Magnus On Mar 29, 2010 6:14 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-03-28 at 19:22 -0400, Robert Haas wrote: On

Re: [HACKERS] GSoC

2010-03-29 Thread Dann Corbit
Maybe this can be helpful: http://sourceforge.net/search/?type_of_search=softwords=fingerprint http://sourceforge.net/search/?type_of_search=softwords=image+recogniti on -Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- ow...@postgresql.org] On Behalf

Re: [HACKERS] GSoC

2010-03-29 Thread Jeff Davis
On Mon, 2010-03-29 at 19:08 -0400, Robert Haas wrote: To be really useful, this would probably need some kind of index support, maybe based on GIN. Yes. You're not going to get that done by August even if you start now and don't sleep. The extensibility mechanism is designed so that an

Re: [HACKERS] Alpha release this week?

2010-03-29 Thread Alvaro Herrera
Josh Berkus escribió: And snaphsots have more compile dependancies than releases do. As far as I know, a snapshot is identical to a release in that regard. If they are not, that's a bug and we can fix it before weekend. -- Alvaro Herrera

Re: [HACKERS] GSoC

2010-03-29 Thread Jeff Davis
On Tue, 2010-03-30 at 01:33 +0530, Anindya Jyoti Roy wrote: I have some idea of implementing am image database system, which will let you search against the image and fingerprint: The idea crudely is the following: I want to implement a image database system: This will have the

Re: [HACKERS] Parameter name standby_mode

2010-03-29 Thread Fujii Masao
On Wed, Mar 3, 2010 at 9:41 PM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Feb 24, 2010 at 2:18 PM, Fujii Masao masao.fu...@gmail.com wrote: If standby_mode is enabled, and neither primary_conninfo nor restore_command are set, the standby would get stuck. How about forbidding (i.e.,

[HACKERS] Questions about 9.0 release note

2010-03-29 Thread Takahiro Itagaki
Hi, I have some questions about 9.0 release note. I'd like to work for some of them if required. Comments welcome. * Allow per-tablespace sequential and random page cost variables (seq_page_cost/(random_page_cost)) via ALTER TABLESPACE ... SET/RESET ^^ Are

Re: [HACKERS] GSoC

2010-03-29 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Mar 30, 2010 at 01:33:59AM +0530, Anindya Jyoti Roy wrote: I have some idea of implementing am image database system, which will let you search against the image and fingerprint: As others already pointed out, this seems a huge task for a