Re: [PATCHES] strpos() && KMP

2007-08-07 Thread Tom Lane
Pavel Ajtkulov <[EMAIL PROTECTED]> writes: > Patch intends for artificial language (for example DNA, or > language with small alphabet, or regular language) only. > In natural language, KMP(and other search algo) haven't notable > advantages (+-5% time execution). I wonder why you didn't propose B

Re: [PATCHES] strpos() && KMP

2007-08-07 Thread Decibel!
On Wed, Aug 08, 2007 at 12:19:53AM +0500, Pavel Ajtkulov wrote: > > > Do you have any performance test results for this? > > I describe the worst case in first message (search 'aaa..aab' in > 'aa..aa', "complete" N^2). It works some msec instead of several sec > (in current version). You describ

Re: [PATCHES] strpos() && KMP

2007-08-07 Thread Pavel Ajtkulov
> Do you have any performance test results for this? I describe the worst case in first message (search 'aaa..aab' in 'aa..aa', "complete" N^2). It works some msec instead of several sec (in current version). Patch intends for artificial language (for example DNA, or language with small alphabet

Re: [PATCHES] further WIP for COPYable logs

2007-08-07 Thread Andrew Dunstan
Andrew Dunstan wrote: Here's my latest WIP patch for COPYable CSV logs. I think I addresses all (or most :-) ) of the concerns Dave and Tom had. It's a whole lot simpler than before (no extra pipe). I have not yet tested this on Windows, but given that it now contains almost no Windows-sp

Re: [PATCHES] HOT patch - version 11

2007-08-07 Thread Pavan Deolasee
On 8/2/07, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > > > > > . It would also be better if we didn't emit a > > separate WAL record for defraging a page, if we also prune it at the > > same time. I'm not that worried about WAL usage in general, but that > > seems simple enough to fix. > > > > Ah I

[PATCHES] further WIP for COPYable logs

2007-08-07 Thread Andrew Dunstan
Here's my latest WIP patch for COPYable CSV logs. I think I addresses all (or most :-) ) of the concerns Dave and Tom had. It's a whole lot simpler than before (no extra pipe). I have not yet tested this on Windows, but given that it now contains almost no Windows-specific code I'm not so wo

Re: [PATCHES] pgcrypto (v02)

2007-08-07 Thread Zdenek Kotala
There is updated version of patch. See comments bellow: Marko Kreen wrote: On 7/27/07, Zdenek Kotala <[EMAIL PROTECTED]> wrote: I attach pgcrypto patch which fix two problems on system without strong crypto support (e.g. default Solaris 10 installation): 1) postgres crashes when AES cipher use

Re: [PATCHES] Warning is adjusted of pgbench.

2007-08-07 Thread Hiroshi Saito
Hi. Magnus $ make gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -I../../src/interfaces/libpq -I. -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND "-I../../src/include/port/win32" -c -o pgbench.o pgben

Re: [PATCHES] Warning is adjusted of pgbench.

2007-08-07 Thread Magnus Hagander
On Tue, Aug 07, 2007 at 04:58:19PM +0900, Hiroshi Saito wrote: > Hi Magnus. > > pgbench.c: In function `main': > pgbench.c:1257: warning: implicit declaration of function `getopt' > > adjustment of some reference is required for this. > and this is a FRONTEND program. > patch is smooth at VC8 and

[PATCHES] Warning is adjusted of pgbench.

2007-08-07 Thread Hiroshi Saito
Hi Magnus. pgbench.c: In function `main': pgbench.c:1257: warning: implicit declaration of function `getopt' adjustment of some reference is required for this. and this is a FRONTEND program. patch is smooth at VC8 and MinGW (gcc). Regards, Hiroshi Saito pgbench_patch Description: Binary data

Re: [PATCHES] MemoryContextStats tweak: show tree structure

2007-08-07 Thread Neil Conway
On Mon, 2007-06-08 at 17:48 -0700, Neil Conway wrote: > Obviously this is just for debugging, but I've found it useful while > looking at some memory-related issues. Any comments or objections to > including this in HEAD? Applied, with an indentation of two spaces per level. -Neil