Re: [PATCHES] win codepages 1253, 1254, 1255, 1257 and cleanup

2006-02-18 Thread Peter Eisentraut
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

2006-02-18 Thread Peter Eisentraut
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

2006-02-18 Thread Neil Conway
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

2006-02-18 Thread Neil Conway
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

2006-02-18 Thread Neil Conway
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

2006-02-18 Thread Tom Lane
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

2006-02-18 Thread Tom Lane
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