[PATCHES] WAL: O_DIRECT and multipage-writer

2005-01-25 Thread ITAGAKI Takahiro
. Sincerely, ITAGAKI Takahiro -- pgbench result -- $ ./pgbench -s 100 -c 50 -t 400 - 8.0.0 default + fsync: tps = 20.630632 (including connections establishing) tps = 20.636768 (excluding connections establishing) - multipage-writer + open_direct: tps = 33.761917 (including connections

Re: [PATCHES] WAL: O_DIRECT and multipage-writer

2005-01-25 Thread ITAGAKI Takahiro
Excuse me. I resend the patch with diff -c. On Tue, 25 Jan 2005 10:30:01 +0100 Michael Paesold [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: I think that there is room for improvement in WAL. Here is a patch for it. I think you should resend your patch as a context diff (diff -c

Re: [PATCHES] [HACKERS] WAL: O_DIRECT and multipage-writer

2005-01-27 Thread ITAGAKI Takahiro
, ILP64, or LLP64? If you used LLP64, I think the cause is buffer alignment routine because of sizeof(long) != sizeof(void*). I'll fix it soon... ITAGAKI Takahiro ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PATCHES] [HACKERS] WAL: O_DIRECT and multipage-writer (+ memory leak)

2005-02-03 Thread ITAGAKI Takahiro
and it worked properly, but I don't have IA64... BTW, I found memory leak in BootStrapXLOG(). The buffer allocated by malloc() is not free()ed. ISSUE_BOOTSTRAP_MEMORYLEAK in this patch points out it. (But this leak is not serious, because this function is called only once.) ITAGAKI Takahiro

[PATCHES] bugfix - contrib/pgbench

2005-05-22 Thread ITAGAKI Takahiro
++) { res = PQexec(con, DDLAFTERs[i]); ! if (strncmp(DDLAFTERs[i], drop, 4) PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, %s, PQerrorMessage(con)); exit(1); --- ITAGAKI Takahiro [EMAIL

Re: [PATCHES] bugfix - contrib/pgbench

2005-05-23 Thread ITAGAKI Takahiro
. Drop commands might be added to DDLAFTERs some time, so we may leave it. --- ITAGAKI Takahiro [EMAIL PROTECTED] NTT Cyber Space Laboratories Nippon Telegraph and Telephone Corporation. ---(end of broadcast)--- TIP 2: you can get off all lists

Re: [PATCHES] O_DIRECT for WAL writes

2005-05-29 Thread ITAGAKI Takahiro
data was bad... --- ITAGAKI Takahiro NTT Cyber Space Laboratories attachment: pgbench-result.png ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[PATCHES] Memory leak in BootStrapXLOG()

2005-06-06 Thread ITAGAKI Takahiro
= XLOG_BUFFERS_ALIGN( malloc(BLCKSZ + XLOG_EXTRA_BUFFERS) ); --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] A couple of patches for PostgreSQL 64bit support

2005-07-07 Thread ITAGAKI Takahiro
the overhead will be 32bytes per tuple. Avoiding overheads, can XIDs/CIDs be different bit length? For example, can XIDs/CIDs be changed to 48/16-bit or 40/24-bit? --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 8

[PATCHES] Unused MMCacheLock

2005-07-27 Thread ITAGAKI Takahiro
, - MMCacheLock, WALInsertLock, WALWriteLock, ControlFileLock, --- 33,38 --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PATCHES] Free WAL caches on switching segments

2005-08-30 Thread ITAGAKI Takahiro
Hi, Here is a small patch to prevent undesired WAL file caching by kernel. posix_fadvise(POSIX_FADV_DONTNEED) attempts to free cached pages and the kernel will discard them in preference to other data caches. I think it works just like as O_DIRECT in terms of cache control. O_DIRECT may be a

Re: [PATCHES] Free WAL caches on switching segments

2005-08-30 Thread ITAGAKI Takahiro
... Do you mean simply following code? or more pretty way? #ifdef POSIX_FADV_DONTNEED posix_fadvise(openLogFile, 0, 0, POSIX_FADV_DONTNEED); #endif --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 1

Re: [PATCHES] Free WAL caches on switching segments

2006-01-11 Thread ITAGAKI Takahiro
use the caches to read the WAL segment. By the way, should we put posix_fadvise on the separated place with renaming pg_fadvise? If we use posix_fadvise in other purposes, for example, read-ahead control, the separation would be good to keep codes clean. --- ITAGAKI Takahiro NTT Cyber Space

[PATCHES] Fix overflow of bgwriter's request queue

2006-01-12 Thread ITAGAKI Takahiro
Attached is a patch that fixes overflow of bgwriter's file-fsync request queue. It happened on heavy update workloads and the performance decreased. I have sent HACKERS the detail. --- ITAGAKI Takahiro NTT Cyber Space Laboratories bgwriter-requests-queue-overflow-2.patch Description: Binary

Re: [PATCHES] Fix overflow of bgwriter's request queue

2006-01-12 Thread ITAGAKI Takahiro
*before* writing the pages belonging to them. So I changed it to copy the contents of pendingOpsTable to a local variables and iterate on the vars later. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: explain analyze

Re: [PATCHES] Fix overflow of bgwriter's request queue

2006-01-15 Thread ITAGAKI Takahiro
Tom Lane [EMAIL PROTECTED] wrote: ITAGAKI Takahiro [EMAIL PROTECTED] wrote AbsorbFsyncRequests will be called during the fsync loop in my patch, so new files might be added to pendingOpsTable and they will be removed from the table *before* writing the pages belonging to them. I think

Re: [PATCHES] Index padding optimization

2006-01-16 Thread ITAGAKI Takahiro
advantage without another compression method. But if we tries to compress index keys using prefix compression or so, we might need to put tuples with no/small alignment. I would like to propose it again when I find another method which will work well with this patch. --- ITAGAKI Takahiro NTT Cyber

[PATCHES] memset using long instead of int32

2006-01-19 Thread ITAGAKI Takahiro
/ 1.553555 Loop by int (size=256) : 6.036154 / 5.997446 / 5.995208 Loop by long (size=256) : 6.047094 / 6.020463 / 6.111434 Loop by int (size=1024) : 20.973230 / 20.905700 / 20.905927 Loop by long (size=1024) : 20.943455 / 20.911707 / 20.931522 --- ITAGAKI Takahiro NTT Cyber Space

Re: [PATCHES] Fix overflow of bgwriter's request queue

2006-01-25 Thread ITAGAKI Takahiro
Tom Lane [EMAIL PROTECTED] wrote: ITAGAKI Takahiro [EMAIL PROTECTED] writes: Attached is a revised patch. It became very simple, but I worry that one magic number (BUFFERS_PER_ABSORB) is still left. Have you checked that this version of the patch fixes the problem you saw originally

[PATCHES] ignore_killed_tuples is always true

2006-02-10 Thread ITAGAKI Takahiro
I found IndexScanDesc-ignore_killed_tuples is always true. Is this still needed? Also, I cannot understand why gistgetmulti calls gistnext with ignore_killed_tuples = false. We can always ignore LP_DELETEed tuples, right? --- ITAGAKI Takahiro NTT Cyber Space Laboratories remove

Re: [PATCHES] ignore_killed_tuples is always true

2006-02-12 Thread ITAGAKI Takahiro
it not for performance, but for simplicity of code. So if we still need it, I agree to leave it. Moreover, LP_DELETEed tuples might be useful for Bitmap NOT And/Or join, not only maintenance operations. Union-side of bitmap should not contain LP_DELETEed tuples, and Except-side should do. --- ITAGAKI

Re: [PATCHES] Free WAL caches on switching segments

2006-02-12 Thread ITAGAKI Takahiro
OSes that supports posix_fadvise but not O_DIRECT, for example, NetBSD 4.0 (http://www.netbsd.org/Changes/changes-4.0.html). --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [PATCHES] [HACKERS] Automatic free space map filling

2006-03-08 Thread ITAGAKI Takahiro
. This patch is incomplete, so please discuss in the thread on HACKERS. --- ITAGAKI Takahiro NTT Cyber Space Laboratories bgvacuum-0309.patch.txt Description: Binary data ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [PATCHES] Fix overflow of bgwriter's request queue

2006-03-10 Thread ITAGAKI Takahiro
. If you have time to repeat your original test and see how this does, it'd be much appreciated. Thank you. It worked well on my machine(*). Undesirable behavior was not seen. (*) TPC-C(DBT-2) RHEL4 U1 (2.6.9-11) XFS, 8 S-ATA disks / 8GB memory(shmem=512MB) --- ITAGAKI Takahiro NTT Cyber Space

[PATCHES] table/index fillfactor control

2006-06-06 Thread ITAGAKI Takahiro
(fillfactor = 100); # ALTER INDEX idx SET (fillfactor = 100); # CLUSTER idx ON tbl; # REINDEX INDEX idx; | relname | relfillfactor | relpages | +-+---+--+ | tbl | 100 | 541 | | idx | 100 | 249 | --- ITAGAKI Takahiro NTT OSS Center

[PATCHES] 'Index Full Scan' for Index Scan without Index Cond

2006-06-06 Thread ITAGAKI Takahiro
ORDER BY j; Index Scan using test_pkey on test (cost=0.00..545.86 rows=21192 width=4) Index Cond: (j 2) --- ITAGAKI Takahiro NTT OSS Center indexfullscan.patch Description: Binary data ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [PATCHES] table/index fillfactor control

2006-06-06 Thread ITAGAKI Takahiro
of the options internally, with SQL-level backward compatibility. --- ITAGAKI Takahiro NTT OSS Center ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[PATCHES] table/index fillfactor control, try 2

2006-06-15 Thread ITAGAKI Takahiro
the as-is binary format to store the internal structures. Any comments or better ideas? --- ITAGAKI Takahiro NTT Open Source Software Center fillfactor-0616.patch.gz Description: Binary data fillfactor.sql Description: Binary data ---(end of broadcast

[PATCHES] pgstattuple extension for indexes

2006-06-28 Thread ITAGAKI Takahiro
. tuple_percent | 71.47 dead_tuple_count | 4 dead_tuple_len | 64 -- 64 tuples are marked as LP_DELETE. dead_tuple_percent | 0 free_space | 208188 free_percent | 9.21 Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pgstattuple.patch Description

Re: [PATCHES] table/index fillfactor control, try 3

2006-07-02 Thread ITAGAKI Takahiro
Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

[PATCHES] Resurrecting per-page cleaner for btree

2006-07-12 Thread ITAGAKI Takahiro
. Have I missed something? Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center btsplitvacuum.patch Description: Binary data ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] pgstattuple extension for indexes

2006-07-24 Thread ITAGAKI Takahiro
contrib module, or merge it into contrib/pgstattuple? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] Resurrecting per-page cleaner for btree

2006-07-27 Thread ITAGAKI Takahiro
a little !* free space is inefficient. !*/ ! if (ndeletable = 2) _bt_delitems(rel, buffer, deletable, ndeletable); /* * Note: if we didn't find any LP_DELETE items, then the page's Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

[PATCHES] LWLock statistics collector

2006-07-30 Thread ITAGAKI Takahiro
| 0 | 0 | 0 28 | MultiXactOffsetBuffer | 0 | 0 | 0 | 0 29 | MultiXactMemberBuffer | 0 | 0 | 0 | 0 (30 rows) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pg_stat_lwlocks.patch Description: Binary data

[PATCHES] contrib/pgbench bugfix

2006-07-30 Thread ITAGAKI Takahiro
); } ! memset(state + 1, 0, sizeof(*state) * (nclients - 1)); for (i = 1; i nclients; i++) { Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have

[PATCHES] pgbench: handring empty lines in external scripts

2006-08-15 Thread ITAGAKI Takahiro
(isspace((unsigned char) buf[i])) i++; ! if (buf[i] != '\0' strncmp(buf[i], --, 2) != 0) { commands = process_commands(buf[i]); if (commands == NULL) { Regards, --- ITAGAKI Takahiro NTT Open

[PATCHES] Adjust autovacuum naptime automatically

2006-08-16 Thread ITAGAKI Takahiro
? Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center autovacuum_adjust_naptime-0817.patch Description: Binary data ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] [HACKERS] CSStorm occurred again by postgreSQL8.2

2006-08-28 Thread ITAGAKI Takahiro
the patch. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center snapshot_subtrans.patch Description: Binary data ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [PATCHES] pgstattuple extension for indexes

2006-09-03 Thread ITAGAKI Takahiro
, --- ITAGAKI Takahiro NTT Open Source Software Center pgstattuple.sql.in.diff Description: Binary data pgstattuple.c.diff Description: Binary data ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

[PATCHES] guc units cleanup

2006-09-25 Thread ITAGAKI Takahiro
. GUC_UNIT_XBLOCKS is added for wal_buffers. It is like GUC_UNIT_BLOCKS, but uses XLOG_BLCKSZ instead of BLCKSZ. Also, I cleaned up the test of GUC_UNIT_* flags in preparation to add more unit flags in less bits. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center guc_units.patch Description: Binary

[PATCHES] Load distributed checkpoint patch

2006-12-19 Thread ITAGAKI Takahiro
checkpoint. I'm working on more robust control of checkpoint progress. WAL are written a lot just after checkpoints because of full-page-writes and decreases gradually. Linear control seems to be not enough in some cases. Comments, suggestions and testing are appreciated. Regards, --- ITAGAKI Takahiro NTT

[PATCHES] Dead Space Map patch

2006-12-27 Thread ITAGAKI Takahiro
space map. See also README.pg_deadspacemap. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center deadspacemap.patch.gz Description: Binary data ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

[pgsql-patches] O_DIRECT support for Windows

2007-01-15 Thread ITAGAKI Takahiro
flags? (eg FILE_FLAG_NO_BUFFERING/FILE_FLAG_WRITE_THROUGH) Is this worth doing? Do we need more performance reports for the change? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center win32_o_direct.patch Description: Binary data ---(end of broadcast

Re: [pgsql-patches] O_DIRECT support for Windows

2007-01-15 Thread ITAGAKI Takahiro
to FILE_FLAG_WRITE_THROUGH) Yes, it is not consistent to the source code... And if we had the conclusion you said, the comment should be We are not willing to use FILE_FLAG_NO_BUFFERING. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast

[PATCHES] Error correction for n_dead_tuples

2007-02-01 Thread ITAGAKI Takahiro
will be better, especially just after finish of a vacuum. The behavior in VACUUM FULL is not changed because concurrent updates are not allowed during VACUUM FULL. Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center n_dead_tuples.patch Description: Binary data

Re: [PATCHES] Error correction for n_dead_tuples

2007-02-19 Thread ITAGAKI Takahiro
cleared during vacuum The latter is usually larger with Heikki's patch. In the other hand, the formar is larger in only cases when many DELETEs were rollbacked. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1

Re: [PATCHES] [HACKERS] Load distributed checkpoint

2007-02-26 Thread ITAGAKI Takahiro
to checkpoint_timeout. Also, checking of archive_timeout during checkpoints and some error handling routines were added. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center checkpoint_02-27.patch.gz Description: Binary data ---(end of broadcast

Re: [PATCHES] patch for ECPG (BUG #2956: ECPG does not treat multibyte characters correctly.)

2007-02-27 Thread ITAGAKI Takahiro
) -- 8.3dev 表'; SELECT ;-- -- 8.2.3 : backslash_quote = safe_encoding sql error 'unsafe use of \' in a string literal' in line 21. -- 8.2.3 : backslash_quote = on (SQL injection!) -- 8.2.3 with patch : backslash_quote = safe_encoding 表'; SELECT ;-- Regards, --- ITAGAKI Takahiro

[PATCHES] Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2)

2007-03-04 Thread ITAGAKI Takahiro
with sleep |150tps | 50% | 98.6% | 70 pages/cycle I hope that this patch will be a first step of the intelligent bgwriter. Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center automatic_bgwriter_lru.patch Description: Binary data

[PATCHES] Optimized pgbench for 8.3

2007-03-04 Thread ITAGAKI Takahiro
option from starting full vacuum... to starting vacuum accounts... in reflection of the fact. - Shape duplicated error checks into executeStatement(). There is a big performance win in COPY with no WAL feature. Thanks for the efforts! Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages

2007-03-05 Thread ITAGAKI Takahiro
Sorry, I had a mistake in the patch I sent. This is a fixed version. I wrote: I'm working on making the bgwriter to write almost of dirty pages. This is the proposal for it using automatic adjustment of bgwriter_lru_maxpages. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

[PATCHES] Aggressive freezing in lazy-vacuum

2007-03-05 Thread ITAGAKI Takahiro
accounts SET aid = aid WHERE aid % 20 = 0; = UPDATE 5000 # SELECT count(*) FROM accounts WHERE xmin 2; = 7028 # VACUUM accounts; # SELECT count(*) FROM accounts WHERE xmin 2; = 0 (4) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center aggressive_freeze.patch Description: Binary data

[PATCHES] pgbench on mingw needs fflush

2007-03-12 Thread ITAGAKI Takahiro
, but redundant fflush() does not make mischief for platforms that have correct stderr. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pgbench.fflush.diff Description: Binary data ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [PATCHES] ecpg threading vs win32

2007-03-18 Thread ITAGAKI Takahiro
-threaded client programs | that work with only one PostgreSQL connection at a time Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

[PATCHES] vacuumdb cancel handler

2007-03-18 Thread ITAGAKI Takahiro
of psql at 7.3 and we rewrote them into C programs at 7.4. We might forget to port the feature then. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center vacuumdb_cancel.patch Description: Binary data ---(end of broadcast)--- TIP 4: Have you

[PATCHES] LIKE optimization in UTF-8 and locale-C

2007-03-21 Thread ITAGAKI Takahiro
= PG_GETARG_TEXT_P(1); text *result; - if (pg_database_encoding_max_length() == 1) + if (sb_match_available()) result = do_like_escape(pat, esc); else result = MB_do_like_escape(pat, esc); Regards, --- ITAGAKI Takahiro NTT Open Source

[PATCHES] Load distributed checkpoint V3

2007-03-22 Thread ITAGAKI Takahiro
Folks, Here is the latest version of Load distributed checkpoint patch. I've fixed some bugs, including in cases of missing file errors and overlapping of asynchronous checkpoint requests. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center checkpoint_v3.patch.gz Description: Binary

[PATCHES] Fix pg_wchar_tbl.maxmblen

2007-03-22 Thread ITAGAKI Takahiro
*/ {pg_latin12wchar_with_len, pg_latin1_mblen, pg_latin1_dsplen, pg_latin1_verifier, 1}, /* 10; PG_LATIN3 */ Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [PATCHES] Fix pg_wchar_tbl.maxmblen

2007-03-22 Thread ITAGAKI Takahiro
ITAGAKI Takahiro [EMAIL PROTECTED] wrote: I found wrong definitions of max bytes for a char in EUC_CN (3-2), EUC_TW (3-4) and MULE_INTERNAL (3-4). Also, the length of a char in GB18030 could be 4, though GB18030 is not supported as a server encoding. - {0, pg_gb18030_mblen

Re: [PATCHES] Load distributed checkpoint V3

2007-03-25 Thread ITAGAKI Takahiro
, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

[PATCHES] Small code clean-up

2007-03-27 Thread ITAGAKI Takahiro
, szShareMem))); if (GetLastError() == ERROR_ALREADY_EXISTS) ereport(FATAL, Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project

[PATCHES] Multibyte LIKE optimization

2007-03-30 Thread ITAGAKI Takahiro
encodings before it is applied. Trailing bytes of JOHAB can be less than 128. http://archives.postgresql.org/pgsql-hackers/2007-03/msg01475.php Regards, --- ITAGAKI Takahiro NTT Open Source Software Center mbtextmatch.patch Description: Binary data ---(end of broadcast

[PATCHES] Dead Space Map version 3 (simplified)

2007-03-30 Thread ITAGAKI Takahiro
change the value on-the-fly. If we want the feature, we need something like shared-memory-allocator or swap-supported memory management module. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center deadspacemap_v3.patch.gz Description: Binary data ---(end

[PATCHES] UTF8MatchText

2007-04-01 Thread ITAGAKI Takahiro
| 9682 EUC_JP| 17032 | 17557 | 17599 | 15240 - P1: UTF8MatchText() - P2: P1 + __inline__ GenericMatchText() - P3: P2 + __inline__ wchareq() (The attached patch is P3.) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center utf8matchtext.patch Description: Binary data

Re: [PATCHES] autovacuum multiworkers, patch 5

2007-04-04 Thread ITAGAKI Takahiro
) \ for ((_worker) = AutoVacuumShmem-av_workers; \ (_worker) AutoVacuumShmem-av_workers + autovacuum_max_workers; \ (_worker)++) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 4: Have

Re: [PATCHES] UTF8MatchText

2007-04-08 Thread ITAGAKI Takahiro
to call lower() for constant pattern in the right-hand side and can use functional indexes (lower(col)). I think we never need MBMatchTextIC() in the future unless we move to wide-character server encoding :) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center DropMBMatchTextIC.patch

[PATCHES] Clear up strxfrm() in UTF-8 with locale on Windows

2007-04-09 Thread ITAGAKI Takahiro
. We've passed the result+1 straight to palloc(), so the server tried to allocale more than 1GB of memory and gave up. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center fix_strxfrm.patch Description: Binary data ---(end of broadcast)--- TIP

Re: [PATCHES] autovacuum multiworkers, patch 5

2007-04-09 Thread ITAGAKI Takahiro
to use than present cost delay parameters, but we need more research to move to it. I think it is better to keep cost_limit and cost_delay as of 8.3, but we need cost-balanced multiworkers at any rate. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center autovacuum_balance.patch

Re: [PATCHES] Reviewers Guide to Deferred Transactions/TransactionGuarantee

2007-04-10 Thread ITAGAKI Takahiro
to open sockets to another server when we want to stream WAL. If there were WAL writer, we can save the number of those sockets. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center transaction_guarantee.v11fix.patch Description: Binary data ---(end of broadcast

[PATCHES] High resolution psql \timing on Windows

2007-04-11 Thread ITAGAKI Takahiro
This patch replace _ftime() by QueryPerformanceCounter() to measure durations in psql \timing on Windows. It had only 15ms~ of time resolusion. I brought the codes from src/include/executor/instrument.h . Regards, --- ITAGAKI Takahiro NTT Open Source Software Center psql_timing_on_windows.patch

Re: [PATCHES] autovacuum multiworkers, patch 5

2007-04-12 Thread ITAGAKI Takahiro
where to be fixed, sorry.) Multiworker and balancing seem to work well after they successfully start up. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PATCHES] Suppress warnings on mingw

2007-04-15 Thread ITAGAKI Takahiro
pthread_setspecific(pthread_key_t, void *); void *pthread_getspecific(pthread_key_t); Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [PATCHES] Dead Space Map version 3 (simplified)

2007-04-17 Thread ITAGAKI Takahiro
, lineNumber=1080) at assert.c:51 Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [PATCHES] Suppress warnings on mingw

2007-04-18 Thread ITAGAKI Takahiro
the instructions given in the error msg? pgevent.exp : error LNK2001: unresolved external symbol [EMAIL PROTECTED] .\Debug\pgevent\pgevent.dll : fatal error LNK1120: 1 unresolved externals Hmmm, ok. I'll try the MSVC build and find better solutions. Regards, --- ITAGAKI Takahiro NTT Open Source

[PATCHES] Load distributed checkpoint V4

2007-04-18 Thread ITAGAKI Takahiro
on ahead of checkpoints, so the writes were not needed *in* checkpoints. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center LDC_v4.patch Description: Binary data ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

[PATCHES] Load distributed checkpoint V4.1

2007-04-25 Thread ITAGAKI Takahiro
want to have such a new parameter? I think we have many and many guc variables even now. How about using the same parameter that controls the minimum write speed of the write-phase (the patch used bgwriter_all_maxpages, but I suggested renaming it)? Regards, --- ITAGAKI Takahiro NTT Open

Re: [PATCHES] [HACKERS] autovacuum does not start in HEAD

2007-04-25 Thread ITAGAKI Takahiro
, time=230863419.25 ... (no autovacuum activities forever) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center autovacuum-debug.patch Description: Binary data autovacuum-fix.patch Description: Binary data ---(end of broadcast)--- TIP

Re: [PATCHES] Clear up strxfrm() in UTF-8 with locale on Windows

2007-05-06 Thread ITAGAKI Takahiro
all the way. Still looking for confirmation if it does, though. The fix works well. I tested it with UTF-8 encoding and Japanese_Japan.932 (SJIS) locale and I didn't see any errors. I think it it is enough to cover the buggy UTF-8 treatment on Windows. Regards, --- ITAGAKI Takahiro NTT Open

Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages

2007-05-14 Thread ITAGAKI Takahiro
to bgwriter_lru_percent and bgwriter_lru_maxpages as defaults? My original motivation was to enlarge bgwriter_lru_maxpages automatically; the default bgwriter_lru_maxpages (=5) seemed to be too small. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast

Re: [PATCHES] UTF8MatchText

2007-05-17 Thread ITAGAKI Takahiro
also misunderstood it before, and Dennis Bjorklund pointed out. http://archives.postgresql.org/pgsql-hackers/2007-03/msg01377.php Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our

Re: [PATCHES] [HACKERS] like/ilike improvements

2007-05-31 Thread ITAGAKI Takahiro
| 7887 | 9985 | 10370 [ms] It improved the performance not only for UTF8, but also for other multi-byte encodings and a bit for single-byte encodings. Thanks for the good work ;) --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast

[PATCHES] contrib/pgstattuple Japanese documentation fix

2007-06-06 Thread ITAGAKI Takahiro
The functions bt_metap, bt_page_stats and bt_page_items had moved from contrib/pgstattuple to pageinspect. We've already fixed English documentation, but Japanese version does not catch up. The attached patch just removes those descriptions from README.ja in pgstattuple. Regards, --- ITAGAKI

Re: [PATCHES] contrib/pgstattuple Japanese documentation fix

2007-06-07 Thread ITAGAKI Takahiro
Heikki Linnakangas [EMAIL PROTECTED] wrote: Would you like to add corresponding Japanese documentation to pageinspect, or is it not worthwhile? No, I think such *deep* users who want to use pageinspect would be satisfied with English documentation :) Regards, --- ITAGAKI Takahiro NTT Open

Re: [PATCHES] Autovacuum launcher doesn't notice death of postmaster immediately

2007-06-12 Thread ITAGAKI Takahiro
instead of INT_MAX. Incidentally, we've already had the same protections for log_min_duration_statement and log_autovacuum. I hope this patch could fix those large-autovacuum_naptime problems. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center autovacuum_naptime_overflow.patch

[PATCHES] Cancel autovacuum conflicting with DROP TABLE

2007-06-19 Thread ITAGAKI Takahiro
. Comments welcome. --- ITAGAKI Takahiro NTT Open Source Software Center cancel_autovac_on_drop.patch Description: Binary data ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [PATCHES] Load Distributed Checkpoints, take 3

2007-06-20 Thread ITAGAKI Takahiro
discussions abount the naming. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] Cancel autovacuum conflicting with DROP TABLE

2007-06-21 Thread ITAGAKI Takahiro
ITAGAKI Takahiro [EMAIL PROTECTED] wrote: Here is a patch that cancels autovacuum workers conflicting with DROP TABLE, TRUNCATE and CLUSTER. It was discussed here: http://archives.postgresql.org/pgsql-hackers/2007-06/msg00556.php I made an adjustment for the latest 'more autovacuum fixes

[PATCHES] pgstat_drop_relation bugfix

2007-06-26 Thread ITAGAKI Takahiro
; Since we don't discard any of stat entries except pg_stat_reset(), those useless entries would cause memory leaks, though it is very trivial. I fell my fix is uncool; Let me know if there are any other better ways. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [PATCHES] Cancel autovacuum conflicting with DROP TABLE

2007-06-27 Thread ITAGAKI Takahiro
comments in the code, sorry. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] pgstat_drop_relation bugfix

2007-07-13 Thread ITAGAKI Takahiro
:-(. I'm worried that we leave garbage entries in the stats. As you suggested, don't we need to remove unreferenced entries from stats periodically? and rely entirely on VACUUM to clean out dead entries in the pgstats data. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

[PATCHES] docfix - DELETE doesn't affect auto-analyze

2007-07-16 Thread ITAGAKI Takahiro
Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [PATCHES] docfix - DELETE doesn't affect auto-analyze

2007-07-17 Thread ITAGAKI Takahiro
of autovacuum at 8.1. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] docfix - DELETE doesn't affect auto-analyze

2007-07-17 Thread ITAGAKI Takahiro
is not affected by deletions. if (isCommit) { tabstat-t_counts.t_new_live_tuples += trans-tuples_inserted - trans-tuples_deleted; tabstat-t_counts.t_new_dead_tuples += trans-tuples_deleted; } Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

[PATCHES] Reduce the size of PageFreeSpaceInfo on 64bit platform

2007-08-09 Thread ITAGAKI Takahiro
; /* which page in relation */ - Sizeavail; /* space available on this page */ + uint32 avail; /* space available on this page */ } PageFreeSpaceInfo; Regards, --- ITAGAKI Takahiro NTT Open Source Software

Re: [PATCHES] Reduce the size of PageFreeSpaceInfo on 64bit platform

2007-08-12 Thread ITAGAKI Takahiro
places so that users can always estimate the memory to 6 bytes per page. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [PATCHES] Reduce the size of PageFreeSpaceInfo on 64bit platform

2007-08-12 Thread ITAGAKI Takahiro
with freespace will extended to 21GB from 8GB with 16MB of default maintenance_work_mem. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center remove_PageFreeSpaceInfo.patch Description: Binary data ---(end of broadcast)--- TIP 9: In versions

[PATCHES] XLogCacheByte is unused

2007-08-27 Thread ITAGAKI Takahiro
.) */ - XLogCtl-XLogCacheByte = (Size) XLOG_BLCKSZ *XLOGbuffers; - XLogCtl-XLogCacheBlck = XLOGbuffers - 1; XLogCtl-Insert.currpage = (XLogPageHeader) (XLogCtl-pages); SpinLockInit(XLogCtl-info_lck); Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

[PATCHES] Version in Japanese FAQ is wrong (was [COMMITTERS] pgsql: Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.)

2007-09-11 Thread ITAGAKI Takahiro
) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html?r1=1.358.2.7r2=1.358.2.8) FAQ_japanese.html (r1.36.2.3 - r1.36.2.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ_japanese.html?r1=1.36.2.3r2=1.36.2.4) Regards, --- ITAGAKI

[PATCHES] Various fixes for syslogger

2007-09-19 Thread ITAGAKI Takahiro
files are created under $PGDATA/pg_log/ even if log_destination does not contain 'stderr' (i.e, only csvlog or syslog). Is this an intentional behavior? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center syslogger_parseArgs_assert.patch Description: Binary data logfile_rotate.patch

Re: [PATCHES] Various fixes for syslogger

2007-09-20 Thread ITAGAKI Takahiro
, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

  1   2   >