Re: [HACKERS] [PATCHES] regexp_replace

2005-06-06 Thread a_ogawa
Bruce Momjian wrote: > David Fetter wrote: > > On Mon, Jun 06, 2005 at 12:02:18PM -0400, Bruce Momjian wrote: > > > > > > Patch removed because we already have this functionality. > > > > We don't yet have this functionality, as the patch allows for using > > second and later regex matches "()" in

Re: [HACKERS] Cost of XLogInsert CRC calculations

2005-05-17 Thread a_ogawa
I tested crctest in two machines and two versions of gcc. UltraSPARC III, gcc 2.95.3: gcc -O1 crctest.c 1.321517 s gcc -O2 crctest.c 1.099186 s gcc -O3 crctest.c 1.099330 s gcc -O1 crctest64.c

Re: [HACKERS] FunctionCallN improvement.

2005-02-02 Thread a_ogawa
Tom Lane wrote: > Based on this I think we ought to go with the "unrolled" approach, ie, > we'll create a macro to initialize the fixed fields of fcinfo but fill > in the arg and argisnull arrays with code like what's already in > FunctionCall2: I agree. The unrolled approach is a good result in

Re: [HACKERS] FunctionCallN improvement.

2005-02-01 Thread a_ogawa
Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > I agree; I think the macro is a nice improvement to readability. > > But a dead loss for performance, since it does a MemSet *and* some other > operations. What's worse, it changes a word-aligned MemSet into a > n

[HACKERS] FunctionCallN improvement.

2005-01-31 Thread a_ogawa
When SQL that returns many tuples with character code conversion is executed, the FunctionCall3/FunctionCall5 becomes a bottleneck. Because MemSet is used to initialize FunctionCallInfoData in these functions, a lot of cycles are spent. set client_encoding to 'SJIS'; sel