Re: [PATCHES] Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?

2007-12-01 Thread Steve Singer
/SPARC with perl 5.6.1 and it seems to work fine. Test output attached. Steve regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [PATCHES] TCL fix in HEAD

2007-10-01 Thread Marshall, Steve
Bruce Momjian wrote: Marshall, Steve wrote: The recent TCL patch assumed Tcl_NotifierProcs.initNotifierProc was added in TCL 8.2: In fact it was added in 8.4 so I have modified the CVS with the following patch. I confirmed this against the 8.2.5 release. Sorry I did not notice

Re: [PATCHES] TCL fix in HEAD

2007-10-01 Thread Marshall, Steve
I'm fine with Tom's wording and placement. This seems a bit wordy, as well as wrongly placed --- the time to tell people they need a non-multithreaded Tcl is in the installation instructions. I added the following instead. regards, tom lane

Re: [PATCHES] TCL fix in HEAD

2007-09-28 Thread Marshall, Steve
libraries earlier than 8.4 that have multithreading enabled? Yours, Steve Marshall ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PATCHES] PL/TCL Patch to prevent postgres from becoming multithreaded

2007-09-21 Thread Marshall, Steve
rate system (processing lots and lots of continually changing weather data). Let me know if there is any information we could provide that would be of help in making the back-patching decision. Yours, Steve Marshall -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent

[PATCHES] PL/TCL Patch to prevent postgres from becoming multithreaded

2007-09-11 Thread Marshall, Steve
will be considered for a future PostgreSQL release. Steve Marshall Paul Bayer Doug Knight WSI Corporation pltcl_multithread_bug_test.tar.gz Description: GNU Zip compressed data *** pltcl.c.orig2007-09-10 12:58:34.0 -0400 --- pltcl.c 2007-09-11 11:37:33.363222114 -0400

[PATCHES] Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

2007-04-16 Thread Steve
and an obvious improvement. Talk to you later, Steve ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[PATCHES] Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

2007-04-15 Thread Steve
let you know on Monday if I can find any queries that perform worse. My tests so far have shown equivalent or better performance so far but I've only done sort of a survey so far ... I've got plenty of special cases to test that should put this through the paces. Steve

[PATCHES] Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

2007-04-14 Thread Steve
Steve, can you try this out on your queries and see if it makes better or worse decisions? It seems to fix your initial complaint but I do not have a large stock of test cases to try. Wow, this is a remarkable difference. Queries that were taking minutes to complete are coming up

Re: [PATCHES] Improve psql's handling of multi-line queries

2006-03-29 Thread Steve Woodcock
On 21/03/06, Bruce Momjian pgman@candle.pha.pa.us wrote: Steve, we have already applied a patch by Sergey E. Koposov to do this. Would you review CVS HEAD and see that everything works as you would like. Thanks. Yeah it's good; stores multiline queries in .psql_history which is an improvement

[PATCHES] Make 2PC error messages match docs

2005-10-02 Thread Steve Woodcock
Hi, This makes the error messages for PREPARE TRANSACTION, COMMIT PREPARED etc. match the docs, which talk about transaction identifier not gid or global transaction identifier. Regards, Steve Woodcock Index: src/backend/access/transam/twophase.c

[PATCHES] Improve psql's handling of multi-line queries

2005-08-28 Thread Steve Woodcock
not a good time, but it caught my eye and looked easy enough even for my rusty C. Regards, Steve Woodcock Index: input.c === RCS file: /projects/cvsroot/pgsql/src/bin/psql/input.c,v retrieving revision 1.45 diff -c -r1.45 input.c

Re: [PATCHES] [HACKERS] CVS should die (was: Possible make_oidjoins_check ...)

2004-11-09 Thread Steve Crawford
project. Interesting reading: http://better-scm.berlios.de/comparison/comparison.html http://zooko.com/revision_control_quick_ref.html Cheers, Steve ---(end of broadcast)--- TIP 8: explain analyze is your friend