[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

[PATCHES] regexp_replace

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

Re: [PATCHES] regexp_replace

Schema | Name | Result data type | Argument data types +-+--+- pg_catalog | replace | text | text, text, text I think that regexp_replace is a good name. It is easy to understand. regards, --- Atsushi Ogawa

Re: [PATCHES] regexp_replace

. 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 posting/reading

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

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 AllocSetReset regards, --- Atsushi Ogawa

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. Why is this better than the fix already in place

[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

[PATCHES] Improve the comparison of NUMERIC data

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

[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 ---(end

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 sec patched: 6.73 sec This hardly seems worth adding any complexity for ... What

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

. 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] 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 target table is supported, 'AAA' is a composite column

[PATCHES] Improvement of search for a binary operator

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 --- ./src