Re: [HACKERS] PCTFree Results

Jonah, > Do you have an 8.1 patch for this or only the 8.0.x? Nope, this is Satoshi's code, ask him. BTW, I'm not sure that the DBT2 test is ideal for this sort of thing anyway. We really need a few tests that are heavier on UPDATEs than on INSERTS. Maybe a few data warehousing-style merges.

Re: [HACKERS] PCTFree Results

Josh, Do you have an 8.1 patch for this or only the 8.0.x? On 9/22/05, Josh Berkus wrote: Folks,Well, it took a while but I finally have the results of Satoshi's PCTFreepatch back from the STP.  Bad news about the STP, see below ...Anyway, a series of DBT2 runs doesn't seem to

Re: [HACKERS] PCTFree Results

On Thu, Sep 29, 2005 at 11:05:47AM -0400, Jonah H. Harris wrote: > Has there been any movement on this? If not, I finally have some time to > look at it. Well, here's the original thread: http://archives.postgresql.org/pgsql-hackers/2005-08/msg00637.php I think the problem is that the testing isn

Re: [HACKERS] PCTFree Results

Has there been any movement on this?  If not, I finally have some time to look at it. On 9/23/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: On Thu, Sep 22, 2005 at 10:05:57PM -0400, Tom Lane wrote:> With respect to the original point, I'm pretty nervous about either> accepting or rejecting a perform

Re: [HACKERS] PCTFree Results

On Thu, Sep 22, 2005 at 10:05:57PM -0400, Tom Lane wrote: > With respect to the original point, I'm pretty nervous about either > accepting or rejecting a performance-oriented patch on the strength > of a single test case. This report certainly doesn't favor the PCTFREE > patch, but it probably sh

Re: [HACKERS] PCTFree Results

Tom, > I dug through the CVS logs since 5-July (when full_page_writes was > added, so I suppose that's before your unspecified "July" test). > AFAICS the only changes that might possibly affect xlog/checkpoint > performance were these: > > Use O_DIRECT if available when using O_SYNC for wal_

Re: [HACKERS] PCTFree Results

Josh Berkus writes: > ... The good news is that it appears that stuff which has been > done since July has lessened the penalty for checkpoints somewhat; while > the maximum response time is still better on the full_page_writes=off > systems, the average throughput is no longer substantially di

Re: [HACKERS] PCTFree Results

Josh, Sorry, duh.  I'll check it out.  It has been a long day and I totally missed the URL :(On 9/22/05, Josh Berkus < josh@agliodbs.com> wrote:Jonah,> Seems like this was to be somewhat expected. Was there any > stats/diagnostics included in the patch to show the effectiveness of> PCTFREE?Lots, l

Re: [HACKERS] PCTFree Results

Jonah, > Seems like this was to be somewhat expected. Was there any > stats/diagnostics included in the patch to show the effectiveness of > PCTFREE? Lots, look up the tests on OSDL, per link. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broa

Re: [HACKERS] PCTFree Results

Seems like this was to be somewhat expected.  Was there any stats/diagnostics included in the patch to show the effectiveness of PCTFREE? On 9/22/05, Josh Berkus wrote: Folks,Well, it took a while but I finally have the results of Satoshi's PCTFreepatch back from the STP.  Bad