Re: [PATCHES] win codepages 1253, 1254, 1255, 1257 and cleanup
Kris Jurka wrote: The attached patch adds support for windows codepages 1253, 1254, 1255, and 1257 and cleans up a bunch of the support utilities. I've applied this patch but left out the changes to the Japanese encoding maps, as you suggested. The CVS logs show that there were some manual customizations of these mapping files, so it's better to leave them. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] Uninstall scripts for contrib
David Fetter wrote: This one should do it. This patch fails to apply all over the place. Please fix it so we don't have to sort out the chunks manually. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] add additional options to CREATE TABLE ... AS
On Tue, 2006-02-14 at 14:32 -0500, Kris Jurka wrote: This patch adds most of the options available for regular CREATE TABLE syntax to the CREATE TABLE x AS SELECT ... and AS EXECUTE ... Barring any objections, I'll apply this later today or tomorrow. -Neil ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] pgcrypto: fix memory leak in openssl.c
On Sat, 2006-02-18 at 02:23 +0200, Marko Kreen wrote: Attached are one patch for 7.3, 7.4, 8.0 branches and another for 8.1 and HEAD. Thanks, patches applied to the appropriate branches. -Neil ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PATCHES] add additional options to CREATE TABLE ... AS
On Tue, 2006-02-14 at 14:32 -0500, Kris Jurka wrote: This patch adds most of the options available for regular CREATE TABLE syntax to the CREATE TABLE x AS SELECT ... and AS EXECUTE ... Applied to HEAD, including the documentation updates posted separately. Thanks for the patch. -Neil ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PATCHES] External Sort performance patch
Simon Riggs [EMAIL PROTECTED] writes: The enclosed patch substantially improves large sort performance, Applied with revisions. I thought the addition of the Tapestate structs complicated the notation considerably without really buying anything, so instead I just made the fixed-size arrays into pointers. A more serious objection was that MaxTapes and TapeRange can't be globals, they have to be struct fields, unless you want to assume that all sorts in progress at a given time must use identical memory settings. I also fixed some off-by-one logic in determining the appropriate number of tapes, and added accounting for tape buffer space. It was somewhat reasonable to ignore the LogicalTapeSet space when the number of tapes was fixed and small, but in the new regime I think it's necessary to account for the tape buffers while computing memory use. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PATCHES] External Sort performance patch
Simon Riggs [EMAIL PROTECTED] writes: Following patch implements matching sort cost calculations in the planner in sort_cost() As given, this didn't even compile. Cleaned up and applied. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org