Re: [HACKERS] Vertical Partitioning with TOAST

2005-12-08 Thread Junji TERAMOTO
ant to know that community is how much interested in a partial update. Of course, it is interested whether to want the vertical partitioning function in PostgreSQL, too. :-) By the way, should I send the patch to -patches again? -- Junji Teramoto / teramoto.junji (a) lab.ntt.co.jp

[HACKERS] Vertical Partitioning with TOAST

2005-12-01 Thread Junji TERAMOTO
SET STRAGE FORCEEXTERNAL; I do not understand whether "FORCEEXTERNAL" is an appropriate word. Please teach when there is a better word... -- Junji Teramoto diff -purN postgresql-8.1.0.org/src/backend/access/heap/heapam.c postgresql-8.1.0/src/backend/access/heap/heapam.c --- post

Re: [HACKERS] prefix btree implementation

2005-10-05 Thread Junji TERAMOTO
ot;High key" is not... My consideration was just started, whether it goes well really has not been understood yet. --- Junji Teramoto ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Quick-and-dirty compression for WAL backup blocks

2005-07-12 Thread Junji TERAMOTO
= Checkpoint frequency It has been understood that patchs seems to be effective at VACUUM as a result of the measurement. But, in other cases, the effect was not so seen. -- Junji Teramoto ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [HACKERS] tsearch2 vs core?

2005-06-30 Thread Junji TERAMOTO
store UTF-8 text into tsearch2? Or, do we have to make own parser which can parse UTF-8 text? > Japanese Mr. Junji TERAMOTO(NTT) is supporting it. > http://www.oss.ecl.ntt.co.jp/tsearch2j/ > However, It is EUC_JP. He will probably understand the problem. > Though I don't understa

Re: [HACKERS] Daily DBT-3 (DSS) Results on CVS head

2005-06-10 Thread Junji TERAMOTO
Hello Mark, Mark Wong wrote: >http://developer.osdl.org/markw/postgrescvs/ This site includes "Profile Report". It's very interesting and useful! Then, I compared result of 5/29 with the result of 5/30. new-order transactions per minute 20050529 17

Re: [HACKERS] Quick-and-dirty compression for WAL backup blocks

2005-06-07 Thread Junji TERAMOTO
Tom Lane wrote: In the XLogInsert(), it makes two kinds of logs, "whole buffer(page) log" and "partial buffer log", isn't it? Is it only "who buffer log" to generate a log with "hole"? > >> >> Right. I see. I think, it is important to reduce the n

Re: [HACKERS] Quick-and-dirty compression for WAL backup blocks

2005-06-06 Thread Junji TERAMOTO
Hello all, I am interested in how to "Compress WAL entries". Then, I study the source now, and read this discussion. There are some questions. 1. In the XLogInsert(), it makes two kinds of logs, "whole buffer(page) log" and "partial buffer log", isn't it? Is it only "