Re: [HACKERS] [PATCHES] O_DIRECT for WAL writes

2005-06-20 Thread ITAGAKI Takahiro
is saving memory. O_DIRECT gives a hint that OS should not cache WAL files. Without direct io, OS might make a effort to cache WAL files, which will never be used, and might discard data file cache. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast

Re: [HACKERS] [PATCHES] O_DIRECT for WAL writes

2005-06-23 Thread ITAGAKI Takahiro
files. writeback-cache is always on. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] [PATCHES] O_DIRECT for WAL writes

2005-06-28 Thread ITAGAKI Takahiro
on. --- ITAGAKI Takahiro NTT Cyber Space Laboratories xlog.dio.diff Description: Binary data xlog.gw.diff Description: Binary data ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs

[HACKERS] Why do index access methods use LP_DELETE?

2005-08-11 Thread ITAGAKI Takahiro
tests. Why do index access methods use LP_DELETE? Does this change make troubles? (However, I guess there is no advantage in the change, because unused items are not recycled until next vacuum.) --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast

Re: [HACKERS] Why do index access methods use LP_DELETE?

2005-08-12 Thread ITAGAKI Takahiro
in http://archives.postgresql.org/pgsql-hackers/2005-03/msg00518.php I'll try to mark tuples with LP_DELETE on visibility checking and recycle the pages by bgwriter. ...However it is still a stage of an idea. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end

[HACKERS] Remove xmin and cmin from frozen tuples

2005-08-31 Thread ITAGAKI Takahiro
| 320 tuple_percent | 87.78 dead_tuple_count | 0 dead_tuple_len | 0 dead_tuple_percent | 0 free_space | 823628 -- + 8byte * 10 (whole tuples) free_percent | 22.59 --- ITAGAKI Takahiro NTT Cyber Space Laboratories xmincut.patch Description: Binary data

Re: [HACKERS] Remove xmin and cmin from frozen tuples

2005-08-31 Thread ITAGAKI Takahiro
-load. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Remove xmin and cmin from frozen tuples

2005-08-31 Thread ITAGAKI Takahiro
+ HEAP_XMIN_INVALID has currently no meaning, right? If so, HEAP_FROZEN can be assigned here. Also, t_natts is currently 16-bits, but it can be cut to 11-bits because MaxTupleAttributeNumber is 1664 2^11. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast

[HACKERS] Two different defs of MAX_TUPLES_PER_PAGE

2005-09-01 Thread ITAGAKI Takahiro
) / MAXALIGN(offsetof(HeapTupleHeaderData, t_bits) + sizeof(ItemIdData)) + 1) --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] Two different defs of MAX_TUPLES_PER_PAGE

2005-09-01 Thread ITAGAKI Takahiro
))) Also, is this something that should be in a common header file? If so which one? BLCKSZ, HeapTupleHeaderData, and ItemIdData are all defined in different places ... Considering include-hierarchy, I think bufpage.h is a good place. --- ITAGAKI Takahiro NTT Cyber Space Laboratories

[HACKERS] Alternative variable length structure

2005-09-08 Thread ITAGAKI Takahiro
| 36-- 28 + 2 + 2 + 2 + 2 ... --- ITAGAKI Takahiro NTT Cyber Space Laboratories varlena2.patch Description: Binary data ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Alternative variable length structure

2005-09-08 Thread ITAGAKI Takahiro
several text types and we will have to maintain them. Or were you planning this to handle VARCHAR(6) and the like? If the new text type wins VARCHAR in many respects, I'd like to propose to replace VARCHAR with it. --- ITAGAKI Takahiro NTT Cyber Space Laboratories

[HACKERS] Increase of buffers usage count by bgwriter

2005-10-25 Thread ITAGAKI Takahiro
). I'll appreciate any comments. Thanks, --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do

[HACKERS] Optimization of the alignment padding

2005-11-09 Thread ITAGAKI Takahiro
[ 5] (padding) [ 1] c char [ 3] (padding) [ 4] i int4 the size of tuple (patched) is 32 bytes [27] HeapTupleHeader [ 1] c char [ 4] i int4 Is this effective? Or are there some problems? I'll appreciate any comments. Thanks, --- ITAGAKI Takahiro NTT Cyber Space

Re: [HACKERS] Optimization of the alignment padding

2005-11-09 Thread ITAGAKI Takahiro
to a separately created header. Thanks, I didn't consider it. I'll check the cases and whether they can be resolved. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] 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: [HACKERS] [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: [HACKERS] WAL: O_DIRECT and multipage-writer

2005-01-26 Thread ITAGAKI Takahiro
backends can write same contents later even if the backend in XLogWrite is crushed. Sincerely, 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

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 8: explain analyze is your friend

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

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

2005-03-22 Thread ITAGAKI Takahiro
and open_direct set: Throughput: 3489.69 --- ITAGAKI Takahiro [EMAIL PROTECTED] NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

[HACKERS] Notification when freespaces empty

2005-05-19 Thread ITAGAKI Takahiro
. Is this useful? --- ITAGAKI Takahiro [EMAIL PROTECTED] NTT Cyber Space Laboratories Nippon Telegraph and Telephone Corporation. freespace.diff Description: Binary data ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Notification when freespaces empty

2005-05-24 Thread ITAGAKI Takahiro
reuse them until next VACUUM. But I think it is a problem that FSMs keep being scanned after they are almost empty. In such a case, most stored pages are touched whenever new pages are requested. I intended to cut FSMs earlier in order to omit the scans. --- ITAGAKI Takahiro NTT Cyber Space

Re: [HACKERS] About varlena2

2005-12-05 Thread ITAGAKI Takahiro
+ data | 7 + n | Compressed | E | 0--- + 12 bytes| 13| External| F | 1--- + 16 bytes| 17| External+Compressed | ('*' bits are used for length, '-' are unused.) Comments welcome, --- ITAGAKI Takahiro NTT Cyber Space Laboratories

[HACKERS] Overflow of bgwriter's request queue

2006-01-11 Thread ITAGAKI Takahiro
hope this problem will be solved by some methods. --- ITAGAKI Takahiro NTT Cyber Space Laboratories bgwriter-requests-queue-overflow.patch Description: Binary data ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

Re: [HACKERS] Overflow of bgwriter's request queue

2006-01-12 Thread ITAGAKI Takahiro
. In fact, in my machine, the queue became full twice in a checkpoint and length of the queue decreased from 65536 to *32* by duplicate eliminations. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 6: explain analyze

[HACKERS] TODO-Item: B-tree fillfactor control

2006-01-18 Thread ITAGAKI Takahiro
remember their fillfactors when they are created? The last fillfactors will be used on next reindex. - Is fillfactor useful for hash and gist indexes? I think hash does not need it, but gist might need it. Look forward to your comments. Thanks, --- ITAGAKI Takahiro NTT Cyber Space Laboratories

Re: [HACKERS] TODO-Item: B-tree fillfactor control

2006-02-02 Thread ITAGAKI Takahiro
* leaf_free_percent) When leaf_free_percent is 10%, node_free_percent is 30%. They are the same values of the current implementation. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [HACKERS] Problemas with gram.y

2006-03-07 Thread ITAGAKI Takahiro
access methods (btree, hash and gist) have conception of fillfactors, but static bitmap index or something may not have it. I see that we should give priority to the design. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast

Re: [HACKERS] Automatic free space map filling

2006-03-08 Thread ITAGAKI Takahiro
room for discussion on this idea. Comments are welcome. --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

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

2006-03-13 Thread ITAGAKI Takahiro
Space Map (Heikki Linnakangas) http://archives.postgresql.org/pgsql-hackers/2006-02/msg01125.php | vacuuming pages one by one as they're written by bgwriter Thank you for reading till the last. I'd like to hear your comments. --- ITAGAKI Takahiro NTT Cyber Space Laboratories

Re: [HACKERS] bgwriter statistics

2006-06-05 Thread ITAGAKI Takahiro
the implementation should be well considered to avoid lock contentions. Comments are welcome. --- ITAGAKI Takahiro NTT OSS Center ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] fillfactor using WITH syntax

2006-06-05 Thread ITAGAKI Takahiro
. - ALTER TABLE/INDEX name SET (...) I appreciate any comments. --- ITAGAKI Takahiro NTT OSS Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] fillfactor using WITH syntax

2006-06-07 Thread ITAGAKI Takahiro
, I'll add a options array to pg_class instead of the fixed-field for fillfactor, referring to the aclitem. --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Alternative variable length structure

2006-06-14 Thread ITAGAKI Takahiro
the saving of a few bytes in particular for indexes on VLDBs, but my patch is still incomplete and needs more works. --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [HACKERS] sync_file_range()

2006-06-18 Thread ITAGAKI Takahiro
system call, but we could use the combination of mmap() and msync() instead of it; I mean we can use mmap only to flush dirty pages, not to read or write pages. --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have

Re: [HACKERS] sync_file_range()

2006-06-19 Thread ITAGAKI Takahiro
pseudo-code. (I don't know it works in fact...) my_sync_file_range(fd, offset, nbytes, ...) { void *p = mmap(NULL, nbytes, ..., fd, offset); msync(p, nbytes, MS_ASYNC); munmap(p, nbytes); } Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [HACKERS] note about syntax for fillfactor patch

2006-07-02 Thread ITAGAKI Takahiro
resolve this by adding a T_String handler to defGetBoolean(). 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

[HACKERS] Auto selection of internal representation for integer NUMERIC

2006-07-03 Thread ITAGAKI Takahiro
on fixed size integers. Comments and suggestions are welcome. 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: [HACKERS] passing parameters to CREATE INDEX

2006-07-11 Thread ITAGAKI Takahiro
, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Resurrecting per-page cleaner for btree

2006-07-12 Thread ITAGAKI Takahiro
at-a-time, so the problem is resolved, isn't it? http://archives.postgresql.org/pgsql-patches/2006-05/msg8.php I think this feature is independent from the SITC project and useful for heavily-updated indexes. If it is worthwhile, I'll revise the patch to catch up on HEAD. Regards, --- ITAGAKI

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

2006-07-25 Thread ITAGAKI Takahiro
| dead_tuple_count -+-- 900 |0 Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

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

2006-07-25 Thread ITAGAKI Takahiro
Tom Lane [EMAIL PROTECTED] wrote: ITAGAKI Takahiro [EMAIL PROTECTED] writes: I've applied this but I'm now having some second thoughts about it, because I'm seeing an actual *decrease* in pgbench numbers from the immediately prior CVS HEAD code. Had you done any performance testing

Re: [HACKERS] 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

[HACKERS] LWLock statistics collector (was: CSStorm occurred again by postgreSQL8.2)

2006-07-28 Thread ITAGAKI Takahiro
| 0 | 0 | 0 | 0 | (28 rows) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] LWLock statistics collector

2006-08-04 Thread ITAGAKI Takahiro
-to-stderr method is hard to use because it will increase syslogs and requires re-parsing efforts. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] LWLock statistics collector

2006-08-06 Thread ITAGAKI Takahiro
and DTrace methods. I assume we want to gather the statistics per resource (represented by LWLockKind in my patch), not per LWLockId. Even if we use DTrace, do we need some supports for coloring of lwlocks? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

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

2006-08-06 Thread ITAGAKI Takahiro
SELECT abalance FROM accounts WHERE aid::int8 = :aid; -- cast to force seqscan -- cs_indexscan.sql \set naccounts 10 * :tps \setrandom aid 1 :naccounts SELECT abalance FROM accounts WHERE aid = :aid; Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

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

2006-08-07 Thread ITAGAKI Takahiro
of buffers. A sequential scanning is used in SLRU, so it will not work well against many buffers. I hope some cares in upper layer, snapshot, hitbits or something, being discussed in the recent thread. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end

[HACKERS] 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 2: Don't 'kill -9' the postmaster

Re: [HACKERS] pgstattuple extension for indexes

2006-08-16 Thread ITAGAKI Takahiro
which method is better? Or do you have other ideas? 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: [HACKERS] Adjust autovacuum naptime automatically

2006-08-17 Thread ITAGAKI Takahiro
. Is this in-line with what others were thinking? I agree. We can use autovacuum thresholds and cost-delay parameters to control the frequency and priority of vacuum. I don't think it is good to control vacuums by changing naptime. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [HACKERS] pgstattuple extension for indexes

2006-08-17 Thread ITAGAKI Takahiro
? and How to set the fillfactor?. I hope you to write how to interpret the framgentation (and other) info in README. In my understanding, I'll write You'd better do REINDEX when you see the fragmentation is greater than 50% under the present calculation method. Regards, --- ITAGAKI Takahiro NTT Open

Re: [HACKERS] pgstattuple extension for indexes

2006-08-17 Thread ITAGAKI Takahiro
of the indexes are same. I worry that users will misunderstand the 50% of fragmentation -- if the report says 100%, they'll consider to do REINDEX. But 50%, the necessity is unclear. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast

Re: [HACKERS] Removing the performance gap caused by CHECKPOINT

2006-08-18 Thread ITAGAKI Takahiro
my, *NTT*'s presentation :D But sorry, there are my company-specific troubles to open the source :-( I missed 8.2 feature freeze, so gave up proposing it. Please wait for a moment, or invent more effective checkpoint methods! Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [HACKERS] Autovacuum on by default?

2006-08-22 Thread ITAGAKI Takahiro
. This is a too simplified policy, but we probably need documentation for the linkages between autovacuum and fillfactors. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [HACKERS] Some minor changes to pgbench

2006-08-23 Thread ITAGAKI Takahiro
(bid) references branches (bid); ... Are you interested in this idea? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] autovacuum cannot start when connection is full

2006-08-24 Thread ITAGAKI Takahiro
few people have seen it. Autovacuum can always start in normal use. (I found it when I tried to make multi-processed autovacuum.) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 3: Have you checked our

Re: [HACKERS] autovacuum cannot start when connection is full

2006-08-25 Thread ITAGAKI Takahiro
of superuser_reserved_connections. Thank you! It may be as well to add the same mention to the description of superuser_reserved_connections. | Determines the number of connection slots that are reserved for connections | by PostgreSQL superusers, *including autovacuum*. Regards, --- ITAGAKI Takahiro

Re: [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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] stats test on Windows is now failing repeatably?

2006-08-29 Thread ITAGAKI Takahiro
and Windows? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] stats test on Windows is now failing repeatably?

2006-08-30 Thread ITAGAKI Takahiro
to work very well! I ran the same workload on the HEAD, and I did not see any pgstat.stat related logs now. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] stats collector is stuck on Windows

2006-09-04 Thread ITAGAKI Takahiro
, rfds, NULL, NULL, sel_timeout) 0) | { ... After stuck, select() always results in time-out. LOG: pgstat select is repeated every 2 seconds (maybe PGSTAT_SELECT_TIMEOUT). Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast

[HACKERS] Questions about guc units

2006-09-24 Thread ITAGAKI Takahiro
GUC_UNIT_BLOCKS and GUC_UNIT_XLOG_BLCKSZ unit? I feel inconsistency in them. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [HACKERS] Questions about guc units

2006-09-25 Thread ITAGAKI Takahiro
database size ? (the latter is a bit too radical interpretation, though.) So I think it is not so odd to give a unit to max_fsm_pages. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 4: Have you searched

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-09-28 Thread ITAGAKI Takahiro
goal to shrink the headers is 16 bytes. The headers become 23 bytes using phantom cids and we are limited by alignments, so we will have no more advantages unless we delete extra 7 bytes in the headers. ...and it seems to be very difficult. Regards, --- ITAGAKI Takahiro NTT Open Source Software

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-10-01 Thread ITAGAKI Takahiro
. The above ideas probably do not work well. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Auto-explain patch

2008-09-01 Thread ITAGAKI Takahiro
= InstrAlloc(1, long_lived_memory_context); InstrStartNode(node-instrument); } Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] rmgr hooks and contrib/rmgr_hook

2008-09-02 Thread ITAGAKI Takahiro
. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Auto-explain patch

2008-09-02 Thread ITAGAKI Takahiro
Marko Kreen [EMAIL PROTECTED] wrote: On 8/28/08, ITAGAKI Takahiro [EMAIL PROTECTED] wrote: You can use shared_preload_libraries or local_preload_libraries to load the module automatically. If you do so, you also need to add explain in custom_variable_classes and define explain

Re: [HACKERS] [Review] pgbench duration option

2008-09-04 Thread ITAGAKI Takahiro
it. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] NDirectFileRead and Write

2008-09-08 Thread ITAGAKI Takahiro
. NDirectFileRead/Writes are counters for BufFile in the patch and don't depend on bufmgr. It might be cleaner if we had something like storage/bufstats.h and declared all counter variables in it, but it seems to be an overkill. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via

Re: [HACKERS] [Review] pgbench duration option

2008-09-08 Thread ITAGAKI Takahiro
. gnari I used this condition expression here: if ((st-cnt = nxacts duration = 0) || timer_exceeded) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pgbench-duration_v3.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Synchronous Log Shipping Replication

2008-09-08 Thread ITAGAKI Takahiro
Markus Wanner [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: Are there any better idea to share one socket connection between backends (and bgwriter)? I fear I'm repeating myself, but I've had the same problem for Postgres-R and solved it with an internal message passing

Re: [HACKERS] Synchronous Log Shipping Replication

2008-09-08 Thread ITAGAKI Takahiro
between backends (and bgwriter)? The connections could be established after fork() from postmaster, and number of them could be two or more. This is one of the most complicated part of synchronous log shipping. Switching-processes apporach like b) is just one idea for it. Regards, --- ITAGAKI

Re: [HACKERS] Synchronous Log Shipping Replication

2008-09-09 Thread ITAGAKI Takahiro
for the communicating backend on WALWriteLock. WAL sender only needs to send one signal for each time it sends WAL buffers to slave. We could be split the LWLock to WALWriterLock and WALSenderLock, but the essential point is same. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent

Re: [HACKERS] Synchronous Log Shipping Replication

2008-09-09 Thread ITAGAKI Takahiro
, but I'm not sure it can be also used in the group commit. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] NDirectFileRead and Write

2008-09-12 Thread ITAGAKI Takahiro
it as-is? ShowBufferUsage() ! Shared blocks: ... ! Local blocks: ... ! Direct blocks: R read, W written * In any case I agree that the current arrangement with execdebug.h declaring variables defined in bufmgr.c is just weird. Ok. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center

Re: [HACKERS] NDirectFileRead and Write

2008-09-15 Thread ITAGAKI Takahiro
access. ShowBufferUsage() ! Shared blocks: ... ! Local blocks: ... ! Direct blocks: R read, W written Regards, --- ITAGAKI Takahiro NTT Open Source Software Center BufFileCount.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] 0x1A in control file on Windows

2008-09-17 Thread ITAGAKI Takahiro
; pg_crc32crc; - if ((fd = open(XLOG_CONTROL_FILE, O_RDONLY, 0)) 0) + if ((fd = open(XLOG_CONTROL_FILE, O_RDONLY | PG_BINARY, 0)) 0) { /* * If pg_control is not there at all, or we can't read it, the odds Regards, --- ITAGAKI Takahiro

Re: [HACKERS] 0x1A in control file on Windows

2008-09-18 Thread ITAGAKI Takahiro
Tom Lane [EMAIL PROTECTED] wrote: ITAGAKI Takahiro [EMAIL PROTECTED] writes: We probably need to add PG_BINARY when we open control files because 0x1A is an end-of-file marker on Windows. Well, why is that a bug? If the platform is so silly as to define text files that way, who are we

[HACKERS] Operation needed for datfrozenxid bug?

2008-09-28 Thread ITAGAKI Takahiro
= current_database(); Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] autovacuum and reloptions

2008-10-08 Thread ITAGAKI Takahiro
will be in reloptions because ALTER TABLE SET cannot be used with JOINs. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] auto_explain contrib moudle

2008-10-09 Thread ITAGAKI Takahiro
('explain.log_min_duration', $1, false); $$ LANGUAGE sql SECURITY DEFINER; Regards, --- ITAGAKI Takahiro NTT Open Source Software Center auto_explain.patch Description: Binary data auto_explain.tgz Description: Binary data autoexplain.sgml Description: Binary data -- Sent via pgsql-hackers mailing list

Re: [HACKERS] [WIP] Reduce alignment requirements on 64-bit systems.

2008-10-09 Thread ITAGAKI Takahiro
, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] contrib/pg_stat_statements

2008-10-11 Thread ITAGAKI Takahiro
welcome! Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pgstatstatements.sgml Description: Binary data pg_stat_statements-1011.tgz Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] [PATCH] Extending pg_class info + more flexible TOAST chunk size

2008-10-12 Thread ITAGAKI Takahiro
way? Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Buffer pool statistics in Explain Analyze

2008-10-12 Thread ITAGAKI Takahiro
for your purpose. How about adding buffer usage counters into HeapScanDesc and IndexScanDesc? It requires only changes in ReadBufferWithStrategy and lower layer functions. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] Convert check constraints into One-Time_Filter on prepared statements

2008-10-13 Thread ITAGAKI Takahiro
ok and worth trying? If it is reasonable, I'll try it. Comments welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Is autovacuum too noisy about orphan temp tables?

2008-10-14 Thread ITAGAKI Takahiro
, we should use WARNING level. Monitoring middleware notifies DBAs of WARNING or higher messages, but discards LOG or lower messages. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] Annoying error messages in _dosmaperr

2008-10-14 Thread ITAGAKI Takahiro
programs also don't need to report them, no? If possible, I'd like to remove the #else block (or all of them) from the above routine. (On the other hand, unrecognized win32 error code part should be there.) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers

Re: [HACKERS] contrib/pg_stat_statements

2008-10-15 Thread ITAGAKI Takahiro
to ignore queries using simple protocol, but I'm not sure how to distinguish them from extended or prepared queries. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] contrib/pg_stat_statements

2008-10-15 Thread ITAGAKI Takahiro
Alvaro Herrera [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: My idea was modifying heap tuples directly in pages: heap_inplace_update? It writes WAL. I don't think we need WAL here, and it is enough to write out pages every checkpoints. Regards, --- ITAGAKI Takahiro NTT Open Source

Re: [HACKERS] Annoying error messages in _dosmaperr

2008-10-15 Thread ITAGAKI Takahiro
, errno))); -#else +#elif FRONTEND_DEBUG fprintf(stderr, _(mapped win32 error code %lu to %d), e, errno); #endif return; Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] contrib/pg_stat_statements

2008-10-20 Thread ITAGAKI Takahiro
is separated from the core codes. (The same can be said for contrib/auto_explan, which is my other proposal.) Now I'm working on storing statistics into disks on server shutdown. If it is impossible unless the module is in core, I would change my policy... Regards, --- ITAGAKI Takahiro NTT Open Source

[HACKERS] pg_stat_statements in core

2008-10-20 Thread ITAGAKI Takahiro
ExecutorRun instead of using ExecutorRun_hook. If no objections, I'll go ahead in the direction. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] pg_stat_statements in core

2008-10-22 Thread ITAGAKI Takahiro
functions are called by startup process after REDO. It is used for loading stats data, but is not always necessary because the first user of the module can load the data. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] double-buffering page writes

2008-10-22 Thread ITAGAKI Takahiro
of double-buffering? For example, we could avoid avoid waiting for LockBufferForCleanup(). It is cool if the double-buffering can be used for multiple purposes. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] contrib/pg_stat_statements

2008-10-27 Thread ITAGAKI Takahiro
Martin Pihlak [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: I'd like to submit pg_stat_statements contrib module Nice work! There is one feature I'd like to request -- we need to be able to also track nested statements. This would greatly simplify diagnosing performance problems

[HACKERS] contrib/pg_stat_statements v2

2008-10-27 Thread ITAGAKI Takahiro
restart. The default path of the saved file is 'global/pg_stat_statements.dump'. * pgstatstatements.sgml Documentation of the module. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center pg_stat_statements-1027.tgz Description: Binary data pgstatstatements.sgml Description

  1   2   3   4   5   6   7   8   9   >