Re: [HACKERS] Piggybacking vacuum I/O

2007-01-24 Thread Heikki Linnakangas
Pavan Deolasee wrote: I have just counted the number of read/write calls on the CLOG blocks. As you can see the total number of CLOG reads jumped from 545323 to 1181851 i.e. 1181851 - 545323 = 636528 CLOG block reads for 1554697 pages of stock table. Hmm. So there is some activity there.

[HACKERS] Searching some sites explaing about PosgtreSQL source codes

2007-01-24 Thread re-plore
Hi, I am now reading PostgreSQL source codes, but i am not familiar to this codes. So i am now seraching some sites which explaing about PostgreSQL source codes, or it's structure. If you know a good site explaing PostgreSQL's source codes. Please teach me. Thanks a lot of your conservation!

Re: [HACKERS] msvc failure in largeobject regression test

2007-01-24 Thread Magnus Hagander
On Tue, Jan 23, 2007 at 11:39:23AM -0800, Jeremy Drake wrote: On Tue, 23 Jan 2007, Magnus Hagander wrote: On Tue, Jan 23, 2007 at 09:31:40AM -0500, Andrew Dunstan wrote: Magnus Hagander wrote: Hi! I get failures for the largeobject regression tests on my vc++ build. I don't

Re: [HACKERS] Piggybacking vacuum I/O

2007-01-24 Thread Simon Riggs
On Wed, 2007-01-24 at 09:32 +0530, Pavan Deolasee wrote: On a typical desktop class 2 CPU Dell machine, we have seen pgbench clocking more than 1500 tps. That implies CLOG would get filled up in less than 262144/1500=174 seconds. VACUUM on accounts table takes much longer to trigger. You

Re: [HACKERS] Free space management within heap page

2007-01-24 Thread Martijn van Oosterhout
On Wed, Jan 24, 2007 at 12:45:53PM +0530, Pavan Deolasee wrote: My apologies if this has been discussed before. I went through the earlier discussions, but its still very fuzzy to me. I am not able to construct a case where a tuple is DEAD (not RECENTLY_DEAD) and still there could be a

Re: [HACKERS] Updateable cursors

2007-01-24 Thread Simon Riggs
On Wed, 2007-01-24 at 14:54 +1100, John Bartlett wrote: The reason for those 5 options is to consider different means to cover the Prepared Stmt requirement where the different stages of processing are actually in different transactions. John, Thanks for explaining. Wow! I've never come

Re: [HACKERS] Searching some sites explaing about PosgtreSQL source codes

2007-01-24 Thread Luis D. García
Hi, I'm working with Postgres Source Code too, and there's a site that could be helpfull for you as it has been for me. The site is: http://www.mcknight.de/pgsql-doxygen/cvshead/html/ Greetings... 2007/1/24, re-plore [EMAIL PROTECTED]: Hi, I am now reading PostgreSQL source codes, but i am

Re: [HACKERS] Free space management within heap page

2007-01-24 Thread Pavan Deolasee
On 1/24/07, Martijn van Oosterhout kleptog@svana.org wrote: On Wed, Jan 24, 2007 at 12:45:53PM +0530, Pavan Deolasee wrote: My apologies if this has been discussed before. I went through the earlier discussions, but its still very fuzzy to me. I am not able to construct a case where a tuple

Re: [HACKERS] Updateable cursors

2007-01-24 Thread Zeugswetter Andreas ADI SD
That is also the safe thing to do, since PostgreSQL's implementation of WITH HOLD cursors doesn't leave the rows locked. That can lead to the rows being deleted from under the cursor, for which the standard is unclear as to whether that is acceptable, or not. Um, the default use case is to

Re: [HACKERS] Free space management within heap page

2007-01-24 Thread Gregory Stark
Pavan Deolasee [EMAIL PROTECTED] writes: On 1/24/07, Martijn van Oosterhout kleptog@svana.org wrote: I thought the classical example was a transaction that updated the same tuple multiple times before committing. Then the version prior to the transaction start isn't dead yet, but all but one

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Stephen Frost
* Jim Nasby ([EMAIL PROTECTED]) wrote: On Jan 23, 2007, at 12:07 PM, Stephen Frost wrote: Hmm. While I agree with the sentiment, Unix does provide for setgid such that objects inherit a specific group on creation. Using roles we don't get that distinction so I don't think comparing it to

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: Stephen Frost [EMAIL PROTECTED] writes: * Tom Lane ([EMAIL PROTECTED]) wrote: Before discussing limitations you should first justify why we need any such concept at all. It was no part of the original TODO item and I cannot see any good use for it.

Re: [HACKERS] Free space management within heap page

2007-01-24 Thread Pavan Deolasee
On 1/24/07, Gregory Stark [EMAIL PROTECTED] wrote: Pavan Deolasee [EMAIL PROTECTED] writes: On 1/24/07, Martijn van Oosterhout kleptog@svana.org wrote: I thought the classical example was a transaction that updated the same tuple multiple times before committing. Then the version prior to

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Merlin Moncure
On 1/24/07, Stephen Frost [EMAIL PROTECTED] wrote: Sure, all the objects in a given schema should be owned by a role which all the admins of that schema are members of. I really see this as a sensible step from ACLs since ownership implies additional permissions (which can't otherwise be

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Merlin Moncure
On 1/24/07, Merlin Moncure [EMAIL PROTECTED] wrote: when you create them. Table rights almost always follow broad rules so it only natural to integrate that with schemas somehow...but admittedly it is awkward to put it into GRANT (and I've thought alot a bout. oops :( what I meant to say here

Re: [HACKERS] Updateable cursors

2007-01-24 Thread Simon Riggs
On Wed, 2007-01-24 at 14:27 +0100, Zeugswetter Andreas ADI SD wrote: That is also the safe thing to do, since PostgreSQL's implementation of WITH HOLD cursors doesn't leave the rows locked. That can lead to the rows being deleted from under the cursor, for which the standard is unclear as

Re: [HACKERS] About PostgreSQL certification

2007-01-24 Thread John Zubac
Hi Theo I find your statements about Postgres being a huge business risk pretty laughable. First of all, Postgres is based on SQL92 and SQL99 standards which means that most scripts are pretty much the same compared to MSSQL and Oracle. The only thing I have seen to learn are the postgres

Re: [HACKERS] About PostgreSQL certification

2007-01-24 Thread Theo Schlossnagle
On Jan 24, 2007, at 9:50 AM, John Zubac wrote: I find your statements about Postgres being a huge business risk pretty laughable. First of all, Postgres is based on SQL92 and SQL99 standards which means that most scripts are pretty much the same compared to MSSQL and Oracle. The only thing

Re: [HACKERS] [pgsql-patches] pg_get_domaindef

2007-01-24 Thread Andrew Dunstan
[ redirecting discussion to -hackers, where it seems more appropriate ] Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: FAST PostgreSQL wrote: Please find attached the patch with modifications are you proposing to implement the other functions in this TODO item

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Stephen Frost
* Merlin Moncure ([EMAIL PROTECTED]) wrote: On 1/24/07, Merlin Moncure [EMAIL PROTECTED] wrote: when you create them. Table rights almost always follow broad rules so it only natural to integrate that with schemas somehow...but admittedly it is awkward to put it into GRANT (and I've thought

Re: [HACKERS] STOP all user access except for admin for a few minutes?

2007-01-24 Thread org
Ha ha... thx Tino Yes, I think this is way to go, strange how my mind climbs the wrong tree sometimes :) I actually need to aquire a transaction across several dB's, check if the conditions are right, and then modify some tables, write and remove some triggers. Transactions in postgres are 2

[HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Teodor Sigaev
We (Oleg and me) are glad to present tsearch in core of pgsql patch. In basic, layout, functions, methods, types etc are the same as in current tsearch2 with a lot of improvements: - pg_ts_* tables now are in pg_catalog - parsers, dictionaries, configurations now have owner and namespace

[HACKERS] Access last inserted tuple info...

2007-01-24 Thread Luis D. García
Hi, I'm working on a modification of PostgreSQL 8.1.4 and I need to access the information stored in the last tuple inserted in a table (All this from the backend code). Could anyone please help me on this? Greetings and Thanks... -- Luis D. García M. Telf: (+58) 2418662663 Cel.: (+58)

Re: [HACKERS] STOP all user access except for admin for a few minutes?

2007-01-24 Thread Markus Schiltknecht
Hi, [EMAIL PROTECTED] wrote: Ha ha... thx Tino Yes, I think this is way to go, strange how my mind climbs the wrong tree sometimes :) I actually need to aquire a transaction across several dB's, check if the conditions are right, and then modify some tables, write and remove some triggers.

[HACKERS] Recursive Queries

2007-01-24 Thread Gregory Stark
I'm looking into recursive queries and what it would take to support them in Postgres. Is anyone else looking at this already? Aside from the Oracle-ish syntax were there other objections to the patch as posted a while back for 7.3 by Evgen Potemkin? I have some ideas myself for how to go about

Re: [HACKERS] Recursive Queries

2007-01-24 Thread Joshua D. Drake
Gregory Stark wrote: I'm looking into recursive queries and what it would take to support them in Postgres. Is anyone else looking at this already? Yes your co-employee Jonah. http://archives.postgresql.org/pgsql-hackers/2007-01/msg00989.php Sincerely, Joshua D. Drake -- === The

[HACKERS] Help with Degree Work

2007-01-24 Thread Werner Echezuria
Hello, I've suscribed to this mailing list for help, I will work on a Specialization Degree Thesis, this will be a PostgreSQL implementation of fsql, or fuzzy querys. http://www.lcc.uma.es/~ppgg/FSQL.html, this is a link to a webpage who made this in Oracle, but it's not inside of course,

Re: [HACKERS] Recursive Queries

2007-01-24 Thread Andrew Dunstan
Gregory Stark wrote: I'm looking into recursive queries and what it would take to support them in Postgres. Is anyone else looking at this already? Aside from the Oracle-ish syntax were there other objections to the patch as posted a while back for 7.3 by Evgen Potemkin? I have some ideas

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for marketing reasons, which I will counter by saying that it looks

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Merlin Moncure
On 1/24/07, Stephen Frost [EMAIL PROTECTED] wrote: err, what proposal wasn't touching the GRANT syntax at all but rather right, but the original proposal did: # %Allow GRANT/REVOKE permissions to be applied to all schema objects with one command which was more or less (with the NEW TABLES

Re: [HACKERS] weird buildfarm failures on arm/mipsel and --with-tcl

2007-01-24 Thread Stefan Kaltenbrunner
Stefan Kaltenbrunner wrote: Tom Lane wrote: Stefan Kaltenbrunner [EMAIL PROTECTED] writes: one of my new buildfarm boxes (an Debian/Etch based ARM box) is sometimes failing to stop the database during the regression tests:

Re: [HACKERS] About PostgreSQL certification

2007-01-24 Thread Joshua D. Drake
Also comparing Postgres to MYSQL is also pretty funny, since there are instances of MYSQL LOSING databases due to corruption because they do not have PITR and their transaction rollback feature did not work properly last time I checked. This is really a issue of people being close minded to

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Joshua D. Drake
Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for marketing reasons, which I will

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Tom Lane
Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. This is a fairly large patch and I would like the chance to review it before it goes in --- we'll commit tomorrow is not exactly a decent review window. Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Andrew Dunstan
Joshua D. Drake wrote: Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for

Re: [HACKERS] weird buildfarm failures on arm/mipsel and --with-tcl

2007-01-24 Thread Tom Lane
Stefan Kaltenbrunner [EMAIL PROTECTED] writes: FWIW - I removed --with-tcl from quagga's configuration about two weeks ago and it has not failed(for that reason) again. So the issue most definitly looks like plptcl related ... It sorta looks like Tcl might be installing an atexit() callback

Re: [HACKERS] Recursive Queries

2007-01-24 Thread Bruce Momjian
Andrew Dunstan wrote: Gregory Stark wrote: I'm looking into recursive queries and what it would take to support them in Postgres. Is anyone else looking at this already? Aside from the Oracle-ish syntax were there other objections to the patch as posted a while back for 7.3 by Evgen

Re: [HACKERS] Recursive Queries

2007-01-24 Thread Andrew Dunstan
Bruce Momjian wrote: Wasn't somebody else working on this? Jonah? (Maybe you EDB guys need to talk more ...) He is taking it over for Jonah. Oh, good. That was the piece of missing info. I had a case just yesterday where this feature would have saved us hours of writing client

Re: [HACKERS] Default permissisons from schemas

2007-01-24 Thread Stephen Frost
* Merlin Moncure ([EMAIL PROTECTED]) wrote: On 1/24/07, Stephen Frost [EMAIL PROTECTED] wrote: err, what proposal wasn't touching the GRANT syntax at all but rather right, but the original proposal did: # %Allow GRANT/REVOKE permissions to be applied to all schema objects with one command

Re: [HACKERS] Access last inserted tuple info...

2007-01-24 Thread David Fetter
On Wed, Jan 24, 2007 at 12:56:14PM -0400, Luis D. Garc?a wrote: Hi, I'm working on a modification of PostgreSQL 8.1.4 and I need to access the information stored in the last tuple inserted in a table (All this from the backend code). Could anyone please help me on this?

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Jeff Davis
On Wed, 2007-01-24 at 19:15 +0100, Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for

Re: [HACKERS] weird buildfarm failures on arm/mipsel and --with-tcl

2007-01-24 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner [EMAIL PROTECTED] writes: FWIW - I removed --with-tcl from quagga's configuration about two weeks ago and it has not failed(for that reason) again. So the issue most definitly looks like plptcl related ... It sorta looks like Tcl might be installing an

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread David Fetter
On Wed, Jan 24, 2007 at 01:53:54PM -0500, Andrew Dunstan wrote: Joshua D. Drake wrote: Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Jeremy Drake
On Wed, 24 Jan 2007, Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for marketing

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Joshua D. Drake
Jeremy Drake wrote: On Wed, 24 Jan 2007, Peter Eisentraut wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Neil Conway
On Wed, 2007-01-24 at 13:49 -0500, Tom Lane wrote: 2) once we put this in core we are going to be stuck with supporting its SQL API forever. Are we convinced that this API is the one we want? I don't recall even having seen any proposal or discussion. There has been some prior discussion:

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Andrew Dunstan
Jeremy Drake wrote: On Wed, 24 Jan 2007, Peter Eisentraut wrote: I still haven't heard any argument for why this would be necessary or desirable at all, other than that it looks better for marketing reasons, which I will counter by saying that it looks worse for marketing reasons because our

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Andrew Dunstan wrote: contrib is a horrible misnomer. Can we maybe bite the bullet and call it something else? plugins? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Jeff Davis wrote: On that point, why do we have /contrib? It's for plugins that are so version-dependent that they can't exist as a separate project, as I understand it. No. (I don't know a better and succinct answer, but that is not it.) -- Peter Eisentraut

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Jeremy Drake wrote: I for one am greatly looking forward to tsearch2 being in core. I was very fond of the plugin mechanism, until I signed up with a hosting provider. Yes, you have told us about your hosting provider before. Just make sure your next hosting provider does not refuse to

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Joshua D. Drake
Peter Eisentraut wrote: Jeremy Drake wrote: I for one am greatly looking forward to tsearch2 being in core. I was very fond of the plugin mechanism, until I signed up with a hosting provider. Yes, you have told us about your hosting provider before. Just make sure your next hosting

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Neil Conway wrote: But I agree that we need considerably more discussion before committing the patch. I'm personally not sold on the need for modifications to the SQL grammar, for example, as opposed to just using a set of SQL-callable functions and some new system catalogs. In particular, I

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Stefan Kaltenbrunner
Neil Conway wrote: On Wed, 2007-01-24 at 13:49 -0500, Tom Lane wrote: 2) once we put this in core we are going to be stuck with supporting its SQL API forever. Are we convinced that this API is the one we want? I don't recall even having seen any proposal or discussion. There has been some

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan wrote: contrib is a horrible misnomer. Can we maybe bite the bullet and call it something else? plugins? standard-plugins might be more informative. I think of them as being like perl's standard modules, things that are part of the

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Tom Lane
Stefan Kaltenbrunner [EMAIL PROTECTED] writes: Neil Conway wrote: Another question that would be easier to resolve before the patch is committed is naming: the patch currently uses a mix of full text and tsearch[2] as the name of the full-text search feature. If we're going to bless this as

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Stefan Kaltenbrunner
Peter Eisentraut wrote: Jeremy Drake wrote: I for one am greatly looking forward to tsearch2 being in core. I was very fond of the plugin mechanism, until I signed up with a hosting provider. Yes, you have told us about your hosting provider before. Just make sure your next hosting

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Ron Mayer
Andrew Dunstan wrote: Joshua D. Drake wrote: Where on the website can I see what plugins are included with PostgreSQL? YES! That's IMHO a more fundamental problem. The specific question about Text Search seems more like a symptom. While I don't mind Text Search in core, it seems an even

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Stefan Kaltenbrunner wrote: sure that ISP is a bit stupid(especially wrt plpgsql) - but tsearch2 in the current version is actually imposing some additional(often non-trivial) complexity for things like database restores and upgrades so I can see an ISP wanting to avoid that altogether. I

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Joshua D. Drake
Peter Eisentraut wrote: Stefan Kaltenbrunner wrote: sure that ISP is a bit stupid(especially wrt plpgsql) - but tsearch2 in the current version is actually imposing some additional(often non-trivial) complexity for things like database restores and upgrades so I can see an ISP wanting to

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
Stefan Kaltenbrunner wrote: I think one can find arguments for both variants - one of the question might even be how other databases are doing that and if the proposed syntax is resembling one of those or not. The closest I could find is Oracle Text, the full-text search for Oracle. Browsing

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Peter Eisentraut
I wrote: The closest I could find is Oracle Text, the full-text search for Oracle. Oh, and note that Oracle Text is an extension and not included in the Oracle database product proper. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Joshua D. Drake
Peter Eisentraut wrote: I wrote: The closest I could find is Oracle Text, the full-text search for Oracle. Oh, and note that Oracle Text is an extension and not included in the Oracle database product proper. Cool. Then we will have yet another reason to claim we are superior. Joshua D.

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Alvaro Herrera
Joshua D. Drake wrote: Peter Eisentraut wrote: I wrote: The closest I could find is Oracle Text, the full-text search for Oracle. Oh, and note that Oracle Text is an extension and not included in the Oracle database product proper. Cool. Then we will have yet another reason to

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Neil Conway
On Wed, 2007-01-24 at 18:38 -0300, Alvaro Herrera wrote: In any case, I agree with Andrew that it would be pretty dumb to reject a funded, already written patch. Well, there are two separate issues: should we include tsearch2 in core, and what syntax should it use? Changing the syntax would not

Re: [HACKERS] tupdesc reference is not owned by resource owner Portal

2007-01-24 Thread Tom Lane
Stefan Kaltenbrunner [EMAIL PROTECTED] writes: Tom Lane wrote: I think the proper fix is probably to establish a new eval_context when we enter an EXCEPTION block, and destroy it again on the way out. Slightly annoying, but probably small next to the other overhead of a subtransaction.

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Andrew Dunstan
Neil Conway wrote: If people had a problem with integrating tsearch2 in core they should have said so much earlier. Peter, Tom and others raised essentially identical objections when this design was initially proposed. For example:

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: IIRC Tom's main objection to the previous proposal was that it involved large grammar changes, which I understand is not now proposed. No, they're already in there --- the patch seems to have been written according to that proposal despite the

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Martijn van Oosterhout
On Wed, Jan 24, 2007 at 09:38:06PM +0100, Stefan Kaltenbrunner wrote: sure that ISP is a bit stupid(especially wrt plpgsql) - but tsearch2 in the current version is actually imposing some additional(often non-trivial) complexity for things like database restores and upgrades so I can see an

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: IIRC Tom's main objection to the previous proposal was that it involved large grammar changes, which I understand is not now proposed. No, they're already in there --- the patch seems to have been written according to that

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Jeremy Drake
On Wed, 24 Jan 2007, Martijn van Oosterhout wrote: On Wed, Jan 24, 2007 at 09:38:06PM +0100, Stefan Kaltenbrunner wrote: sure that ISP is a bit stupid(especially wrt plpgsql) - but tsearch2 in the current version is actually imposing some additional(often non-trivial) complexity for things

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-24 Thread Kenneth Marshall
On Tue, Jan 23, 2007 at 09:01:41PM -0600, Jim Nasby wrote: On Jan 22, 2007, at 6:53 PM, Kenneth Marshall wrote: The default should be approximately the OS standard read-ahead amount. Is there anything resembling a standard across the OSes we support? Better yet, is there a standard call

[HACKERS] New feature proposal

2007-01-24 Thread Sorin Schwimmer
Dear Developers, I would like to suggest the inclusion of an extension in PostgreSQL. There are instances, I found, when one needs to INSERT several times the same record in a table. The front-end application can do it easy in a loop of a sort, but on remote servers (and that's the norm these

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-24 Thread Kenneth Marshall
On Mon, Jan 22, 2007 at 05:11:03PM -0600, Jim C. Nasby wrote: On Mon, Jan 22, 2007 at 12:17:39PM -0800, Ron Mayer wrote: Gregory Stark wrote: Actually no. A while back I did experiments to see how fast reading a file sequentially was compared to reading the same file sequentially but

Re: [HACKERS] New feature proposal

2007-01-24 Thread Neil Conway
On Wed, 2007-01-24 at 08:26 -0800, Sorin Schwimmer wrote: The front-end application can do it easy in a loop of a sort, but on remote servers (and that's the norm these days) it creates unnecessary network traffic. You can avoid this easily via a stored procedure. My suggestion is to allow

Re: [HACKERS] New feature proposal

2007-01-24 Thread Gavin Sherry
On Wed, 24 Jan 2007, Sorin Schwimmer wrote: Dear Developers, I would like to suggest the inclusion of an extension in PostgreSQL. There are instances, I found, when one needs to INSERT several times the same record in a table. The front-end application can do it easy in a loop of a sort,

Re: [HACKERS] New feature proposal

2007-01-24 Thread Tom Lane
Sorin Schwimmer [EMAIL PROTECTED] writes: My suggestion is to allow INSERT to do it REPEAT x. You can do that today. INSERT INTO foo SELECT const1,const2,... FROM generate_series(1,1000); regards, tom lane ---(end of

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-24 Thread Tom Lane
Kenneth Marshall [EMAIL PROTECTED] writes: Not that I am aware of. Even extending the relation by one additional block can make a big difference in performance Do you have any evidence to back up that assertion? It seems a bit nontrivial to me --- not the extension part exactly, but making

Re: [pgsql-patches] [HACKERS] unprivileged contrib and pl install (formerly tsearch

2007-01-24 Thread Tom Lane
[ redirecting thread from -patches to -hackers for wider comment ] Jeremy Drake [EMAIL PROTECTED] writes: On Wed, 24 Jan 2007, Tom Lane wrote: Note I'm not arguing against allowing it to be on by default, I just want to be sure there is a way for paranoid DBAs to turn it off. Maybe it'd be

[HACKERS] TODO list has removed developer names

2007-01-24 Thread Bruce Momjian
I have removed the developer names from the bottom of the TODO list now that URLs are used to reference discussions. The URLs are much more accurate than putting names on items. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard

Re: [HACKERS] Help with Degree Work

2007-01-24 Thread Jim C. Nasby
You should take a look at http://pgfoundry.org/projects/qbe, which deals with querying data by providing sample data that matches what you're looking for. On Wed, Jan 24, 2007 at 01:40:04PM -0400, Werner Echezuria wrote: Hello, I've suscribed to this mailing list for help, I will work on a

Re: [pgsql-patches] [HACKERS] unprivileged contrib and pl install

2007-01-24 Thread Jeremy Drake
On Wed, 24 Jan 2007, Tom Lane wrote: [ redirecting thread from -patches to -hackers for wider comment ] Jeremy Drake [EMAIL PROTECTED] writes: On Wed, 24 Jan 2007, Tom Lane wrote: Note I'm not arguing against allowing it to be on by default, I just want to be sure there is a way for

Re: [pgsql-patches] [HACKERS] unprivileged contrib and pl install

2007-01-24 Thread Jeremy Drake
On Wed, 24 Jan 2007, Jeremy Drake wrote: I am digging through the code looking at this, and I have a question. As far as I can tell, there is currently no owner for a pg_language entry. Is this correct or is ownership information stored somewhere other than the pg_language relation? Are you

Re: [HACKERS] pg_trigger.tgargs needs detoast

2007-01-24 Thread Bruce Momjian
Patch applied. Thanks. Backpached to 8.2.X. If it needs to be backpatched to older releases, someone needs to research that. --- Kenji Kawamura wrote: Hello, This patch fixes a bug of case of extraction of

Re: [pgsql-patches] [HACKERS] unprivileged contrib and pl install

2007-01-24 Thread Tom Lane
Jeremy Drake [EMAIL PROTECTED] writes: I am digging through the code looking at this, and I have a question. As far as I can tell, there is currently no owner for a pg_language entry. Er, doh. Sort of answered my own question, found this comment: * Note: for now, languages are treated as

Re: [HACKERS] Fix for bug in plpython bool type conversion

2007-01-24 Thread Bruce Momjian
Patch applied. Thanks. --- Guido Goldstein wrote: Hi! The attached patch fixes a bug in plpython. This bug was found while creating sql from trigger functions written in plpython and later running the generated

Re: [HACKERS] [PERFORM] how to plan for vacuum?

2007-01-24 Thread Alvaro Herrera
Jim C. Nasby wrote: I'll generally start with a cost delay of 20ms and adjust based on IO utilization. I've been considering set a default autovacuum cost delay to 10ms; does this sound reasonable? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [HACKERS] [PERFORM] how to plan for vacuum?

2007-01-24 Thread Jim C. Nasby
On Thu, Jan 25, 2007 at 12:52:02AM -0300, Alvaro Herrera wrote: Jim C. Nasby wrote: I'll generally start with a cost delay of 20ms and adjust based on IO utilization. I've been considering set a default autovacuum cost delay to 10ms; does this sound reasonable? For a lightly loaded

Re: [HACKERS] Recursive Queries

2007-01-24 Thread Hubert FONGARNAND
The only code that is usable (and performant) is the CONNECT BY patch made by Evgen Potemkin, It works on production servers on the 8.1.5 I hope that a WITH RECURSIVE will be in the 8.3... but I don't see anybody working on this... (what a shame...) Le mercredi 24 janvier 2007 à 17:27 +,

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Oleg Bartunov
Hi there, sorry, if I will a bit verbose - just tried to answer to several postings. On Wed, 24 Jan 2007, Tom Lane wrote: Teodor Sigaev wrote: If there aren't objections then we plan commit patch tomorrow or after tomorrow. This is a fairly large patch and I would like the chance to

Re: [HACKERS] tsearch in core patch, for inclusion

2007-01-24 Thread Oleg Bartunov
On Wed, 24 Jan 2007, Neil Conway wrote: On Wed, 2007-01-24 at 13:49 -0500, Tom Lane wrote: 2) once we put this in core we are going to be stuck with supporting its SQL API forever. Are we convinced that this API is the one we want? I don't recall even having seen any proposal or discussion.

Re: [HACKERS] [COMMITTERS] pgsql: Fix for plpython functions; return true/false for boolean,

2007-01-24 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: Fix for plpython functions; return true/false for boolean, This patch has broken a majority of the buildfarm. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the