[PATCHES] Improvement of search for a binary operator

4 5 average --- original: 214.33 184.60 192.52 158.62 170.04 184.02 patched : 223.86 198.72 207.48 165.70 179.67 195.09 regards, --- Atsushi Ogawa *** ./src/backend/catalog/namespace.c.orig Tue Apr 25 23:16:57 2006

Re: [PATCHES] Allow an alias for the target table in UPDATE/DELETE

Thanks for comments. I modified the patch.Tom Lane wrote:> Atsushi Ogawa <[EMAIL PROTECTED]> writes:> > (2)About processing when column identifier of SET clause is specified > > like 'AAA.BBB'. 'AAA' is a composite column now. When an alias for> >

[PATCHES] Allow an alias for the target table in UPDATE/DELETE

target table. And, make the second element a column name. Example: UPDATE tbl AS t SET t.col = 1; => 't' is eaten up, and 'col' becomes a column name. --- Atsushi Ogawa allow_alias_update.patch Description: Binary data ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] Space management for PGresult

Alvaro Herrera wrote: > Tom Lane wrote: > > Atsushi Ogawa <[EMAIL PROTECTED]> writes: > > > The number of malloc calls at pqResultAlloc: > > > 8.1.0 : 80542 > > > patched:86 > > > > > Execution time: > > > 8.1.0 : 6.80 s

[PATCHES] Space management for PGresult

accounts; (It is pgbench's table. scale factor is 10.) The number of malloc calls at pqResultAlloc: 8.1.0 : 80542 patched:86 Execution time: 8.1.0 : 6.80 sec patched: 6.73 sec regards, --- Atsushi Ogawa libpq_alloc.patch Description: Binary data ---(e

Re: [PATCHES] Improve the comparison of NUMERIC data

2005/11/9, Tom Lane <[EMAIL PROTECTED]>: > Atsushi Ogawa <[EMAIL PROTECTED]> writes: > > An attached patch enables the comparison of Numeric values without > > executing conversion to NumericVar. > > Rather than trying to share code, it'd likely be better

[PATCHES] Improve the comparison of NUMERIC data

s regards, --- Atsushi Ogawa numeric_cmp.patch Description: Binary data ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[PATCHES] Fix argument of SetBufferCommitInfoNeedsSave at _bt_check_unique

The argument of SetBufferCommitInfoNeedsSave at _bt_check_unique might be not correct. When the next page is checked, I think that the argument is not buf but nbuf. regards, --- Atsushi Ogawa *** ./src/backend/access/nbtree/nbtinsert.c.orig 2005-10-13 00:59:55.599839064 +0900 --- ./src/backend

Re: [PATCHES] sum(int4)/sum(int2) improvement

width=4) - Result original: 2.416s patched: 2.286s regards, --- Atsushi Ogawa ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PATCHES] sum(int4)/sum(int2) improvement

Tom Lane wrote: > Atsushi Ogawa <[EMAIL PROTECTED]> writes: > > An attached patch uses AggState->aggcontext instead of per-tuple > > context to allocate the data. As a result, per-tuple context is not > > used, and the cycles of AllocSetReset is reduced. >

[PATCHES] sum(int4)/sum(int2) improvement

0.00 heapgettup 6.25 0.56 0.12 195 0.00 0.00 slot_getattr 4.35 0.64 0.08 524420 0.00 0.00 hash_search 4.35 0.71 0.08 45 0.00 0.00 execTuplesMatch (skip ...) 0.54 1.67 0.01 102 0.00 0.00 AllocSetR

Re: [PATCHES] regexp_replace

tring. There is an overhead of PG_TEXT_GET_STR when appendStringInfoString is executed by text type. This can be reduced by appendStringInfoText. regards, Atsushi Ogawa varlena.patch Description: Binary data ---(end of broadcast)--- TIP 1: if pos

Re: [PATCHES] regexp_replace

\df replace >List of functions >Schema | Name | Result data type | Argument data types > +-+--+- > pg_catalog | replace | text | text, text, text > I think that regexp_replace is a

[PATCHES] regexp_replace

ues: g: global (replace all) i: ignore case When the flags is not specified, case sensitive, replace the first instance only. regards, --- Atsushi Ogawa regexp_replace.patch Description: Binary data ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[PATCHES] replace_text() improvement

(BI made the patch that improved the performance of replace_text(). (BThe content of the patch is as follows: (B (B(1)Create shortcut when subtext was not found. (B (B(2)Stop using LEFT and RIGHT macro. (BIn LEFT and RIGHT macro, TEXTPOS is executed by the same content as (Bexecution immed

[PATCHES] EUC_JP and SJIS conversion improvement

(BThe character-code conversion from EUC_JP to SJIS is executed by (Bconverting two stages. The first stage is conversion from EUC_JP to MIC. (BThe next stage is conversion from MIC to SJIS. (Conversion from SJIS to (BEUC_JP is also similar.) (B (BIt is not so efficient, because it is necess

[PATCHES] bugfix: character-code conversion of MIC -> EUC_JP.

(BI found a bug in character-code conversion of MIC -> EUC_JP. (B(MIC: Mule Internal Code) (B (BIn mic_to_euc_jp(), the call of mic2sjis() is a mistake. (BIt is necessary to call mic2euc_jp() here. (B (Bregards, (B (B--- (BAtsushi Ogawa mic_to_euc_jp.patch Description: Binary data -

Re: [HACKERS] [PATCHES] regexp_replace

ql replaces all string, and regexp_replace() of oracle10g is also similar. And I think that it is better to be able to specify the option with text. I think about this function specification: regexp_replace( string text, pattern text, replacement text ) RETURNS TEXT; /* Replace all */ regexp_replace( s