,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
prorocol or
prepared statements, but not simple protocol queries. And every user
can view other user's queries.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pg_stat_statements.tar.gz
Description: Binary data
executor_hook.patch
Description: Binary data
--
Sent via pgsql-patches
/%f' # Windows
+archive_command = 'copy %p C:\\server\\archivedir\\%f' # Windows
/programlisting
/para
/listitem
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your
core Xeon, 16GB RAM, 4x HDD (RAID-0)
[postgresql.conf]
shared_buffers = 2GB
wal_buffers = 4MB
checkpoint_segments = 64
checkpoint_timeout = 5min
checkpoint_completion_target = 0.5
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
sorted-ckpt-84.patch
Description: Binary data
Greg Smith [EMAIL PROTECTED] wrote:
On Tue, 15 Apr 2008, ITAGAKI Takahiro wrote:
2x Quad core Xeon, 16GB RAM, 4x HDD (RAID-0)
What is the disk controller in this system? I'm specifically curious
about what write cache was involved, so I can get a better feel for the
hardware your
-t1 -M extended
tps = 2877.697842 (excluding connections establishing)
$ pgbench -S -n -c5 -t1 -M prepared
tps = 4532.680627 (excluding connections establishing)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgbench_querymode.patch
Description: Binary data
scripts and ':'
at cast operators '::'. I'll send new one.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgbench_querymode-3.patch
Description: Binary data
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http
always 4.
I got it. This change will work on 64-bit windows, because DWORD is
defined as 'unsigned long' there, too. We need to support LLP64
compliers in advance, though.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
mingw-warnings.patch
Description: Binary data
--
Sent via
Here is a patch to suppress compiler warnings in mingw build.
- Remove unused local variables.
- Cast DWORD to unsigned integer explicitly.
DWORD is always 32bit integer on both 32bit and 64bit Windows.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
mingw-warnings.patch
Peter Eisentraut [EMAIL PROTECTED] wrote:
ITAGAKI Takahiro wrote:
- Cast DWORD to unsigned integer explicitly.
DWORD is always 32bit integer on both 32bit and 64bit Windows.
I think if that is so, you wouldn't need to add any casts. Instead you would
only need to use the right
WHERE i = 1;
Alvaro Herrera [EMAIL PROTECTED] wrote:
Perhaps it could be shown in CONTEXT, like so:
I think it's useful to show the PID of each statement, for the case
where there are more than two processes deadlocked.
Thanks for response. I bought your suggestion :-)
Regards,
---
ITAGAKI
://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/preproc.y?r1=1.348r2=1.349
Variables are represented as $%d instead of ? now.
The grammer of user_name should have followed the change.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
ecpg-connect.patch
Description: Binary data
)) / XLogSegSize) /
+((double) recptr.xrecoff - (double) ckpt_start_recptr.xrecoff)
/ XLogSegSize) /
CheckPointSegments;
if (progress elapsed_xlogs)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast
Tom Lane [EMAIL PROTECTED] wrote:
ITAGAKI Takahiro [EMAIL PROTECTED] writes:
-((double) (int32) (recptr.xrecoff -
ckpt_start_recptr.xrecoff)) / XLogSegSize) /
+((double) recptr.xrecoff - (double) ckpt_start_recptr.xrecoff)
/ XLogSegSize) /
Surely this makes
Tom Lane [EMAIL PROTECTED] wrote:
ITAGAKI Takahiro [EMAIL PROTECTED] writes:
Here is a trivial fix of locking issue in pgstattuple().
Hmm, is this really a bug, and if so how far back does it go?
I'm thinking that having a pin on the buffer should be enough to
call PageGetHeapFreeSpace
Here is a trivial fix of locking issue in pgstattuple().
It was locking buffers around PageGetHeapFreeSpace()
in the heap scan loop, but not in the scanning of the tail.
I think we need locks in the tail, too.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgstattuple_lock.patch
extended protocol with prepared statements.
default is simple.
Usage:
$ pgbench -M [simple|extended|prepared]
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
pgbench_querymode.patch
Description: Binary data
---(end of broadcast
Tom Lane [EMAIL PROTECTED] wrote:
ITAGAKI Takahiro [EMAIL PROTECTED] writes:
All of filler fields in branches, tellers and history is NULL. It is
probabbly a mistake because there are fields of char(22-88) in the table
definitions.
TPC-B requires at least 100 bytes per row for all
test).
At the moment, it reset all of lc_* variables, but it might be possible
use the default locale at lc_messages, lc_monetary, lc_numeric and lc_time
even if lc_collate and lc_ctype are reset to C.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
utf8-nolocale-on-failure.patch
table from encoding to codepage.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
chklocale-v2.patch
Description: Binary data
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
-- CP932 is SJIS in nature
I'll suggest to use UTF8 if the encoding is UTF-8 or NOT specified and
we don't support the locale encoding on Windows, i.e. locale is always
enabled on regression tests.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end
. Allow mismatch between server and locale encodings if the server
encoding is UTF-8.
I succeeded to run regression test on Japanese version of Windows
with the patch, but please test it on other language versions.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
utf8_win32.patch
.
BTW, do we need to distribute ecpg with server (or client library) ?
If it was a separate product, I think we will be able to maintain them
more flexiblly, just like libpqxx or JDBC.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast
don't have msvc build environment, but I hope it will fix the
build failure on it.
On another matter, this patch includes removing descriptors field in
struct connection. This was my mistake in the previous fix of descriptors.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
remove
initdb without options always fails in such environments.
Using UTF-8 with no-locale is better than error.
(Error is better than using wrong locale, though.)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast)---
TIP 7
(and older versions if possible).
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
ecpg-descriptor-fix-8.3.patch
Description: Binary data
descriptor.pgc
Description: Binary data
---(end of broadcast)---
TIP 3: Have you checked our
to reduce #ifdef WIN32.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
ecpg-memory-8.3.patch
Description: Binary data
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
variables.
* Make pthread_mutex_lock() for Win32 thread-safe. (It might be a paranoia...)
* Add more pthread emulation codes for Win32 to reduce #ifdef WIN32.
I'll try to fix thread-safe issues in memory management and
SQL DESCRIPTOR based on this change.
Regards,
---
ITAGAKI Takahiro
NTT Open Source
);
(connection_name argument is added.)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
ecpg_prepare.patch
Description: Binary data
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
ecpg_prepare-8.3.patch
Description: Binary data
prep.pgc
Description: Binary data
---(end of broadcast)---
TIP 6: explain analyze is your friend
= lower_text,
);
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
,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
)
(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
.)
*/
- 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
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
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
; /* 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
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
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
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
:-(.
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
comments in the code, sorry.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast)---
TIP 6: explain analyze is your friend
;
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
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
discussions abount the naming.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
---(end of broadcast)---
TIP 6: explain analyze is your friend
.
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
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
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
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
| 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
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
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
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
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
, 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
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
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
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
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
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
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
. 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
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
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
) \
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
| 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
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
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
, 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
,
---
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
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
*/
{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
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
= 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
-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
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
, 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
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
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
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
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
)
-- 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
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
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
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
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
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
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
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
.
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
,
---
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
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
?
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
(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
| 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
);
}
! 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
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
.
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
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
1 - 100 of 128 matches
Mail list logo