Re: [PATCHES] Patch for testing query modes on pgbench

2008-03-18 Thread Tatsuo Ishii
Patches applied. Thanks. -- Tatsuo Ishii SRA OSS, Inc. Japan > Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > > The cause of this is obvious and easy to fix. However I wonder this is > > because of accidental old or wrong patches. Can you resubmit new patches > > against CVS Head? > > Thanks for yo

Re: [PATCHES] Patch for testing query modes on pgbench

2008-03-18 Thread ITAGAKI Takahiro
Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > The cause of this is obvious and easy to fix. However I wonder this is > because of accidental old or wrong patches. Can you resubmit new patches > against CVS Head? Thanks for your review. Sorry, it's a wrong patch. I found another bugs in handling exte

Re: [PATCHES] Patch for testing query modes on pgbench

2008-03-18 Thread Tatsuo Ishii
> Here is a updated patch to add query modes into pgbench in order to > measure performance of simple protocol, extended protocol and > prepared statements with it. > > [PATCHES] Patch for testing query modes on pgbench > http://momjian.us/mhonarc/patches/msg00335.html > > A new runtime option (-

Re: [PATCHES] Wrong result with pgbench -C option?

2008-03-18 Thread Tatsuo Ishii
Patch applied. Thanks. -- Tatsuo Ishii SRA OSS, Inc. Japan > Hi, > > I ran pgbench with -C option. Here is an output. > > % pgbench -C -c 10 -t 100 bench > starting vacuum...end. > transaction type: TPC-B (sort of) > scaling factor: 1 > number of clients: 10 > number of transactions per client

Re: [PATCHES] Patch to inline stable SQL set returning UDFs

2008-03-18 Thread Tom Lane
"Richard Rowell" <[EMAIL PROTECTED]> writes: > I discussed this hack with Neil and Josh in Ottawa back in May. I > took a stab at it a few weeks ago and below are the results. It is > mostly modeled after the existing inline_function. The approach taken > is to recursively cleanup the RTable whe

[PATCHES] Moving snapshot code around

2008-03-18 Thread Alvaro Herrera
Hi, I'm playing with the snapshot code to create a new module to stash used snapshots and refcount them. It occured to me that a first easy step is to separate the relevant code from tqual.c into a new file, snapshot.c, and split tqual.h in two creating snapshot.h. Basically the internals of sna

Re: [PATCHES] UPDATE using sub selects

2008-03-18 Thread Bruce Momjian
Patch removed from patch queue --- NikhilS, please resubmit when you are ready. Thanks. --- NikhilS wrote: > Hi, > > As per discussion on -hackers, a patch which allows updates to use > subselects is attached with this mai

Re: [PATCHES] UPDATE using sub selects

2008-03-18 Thread NikhilS
Hi Tom, > ... eg backend/nodes/, optimizer/util/clauses.c, ruleutils.c...) > > Actually, on further thought ruleutils.c represents one of the biggest > stumbling blocks here. We have to be able to reverse-compile the parse > tree into something that's at least semantically equivalent to the > ori

[PATCHES] Patch for testing query modes on pgbench

2008-03-18 Thread ITAGAKI Takahiro
Here is a updated patch to add query modes into pgbench in order to measure performance of simple protocol, extended protocol and prepared statements with it. [PATCHES] Patch for testing query modes on pgbench http://momjian.us/mhonarc/patches/msg00335.html A new runtime option (-M) is added: -