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.
Josh,
Do you have an 8.1 patch for this or only the 8.0.x?
On 9/22/05, Josh Berkus josh@agliodbs.com 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
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
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
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
Folks,
Well, it took a while but I finally have the results of Satoshi's PCTFree
patch back from the STP. Bad news about the STP, see below ...
Anyway, a series of DBT2 runs doesn't seem to show any advantage to PCTFree
over a 3-hour run with no vacuums:
test# pctfree full_page_writes
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 josh@agliodbs.com wrote:
Folks,Well, it took a while but I finally have the results of Satoshi's PCTFreepatch back from the STP.Bad news
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
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, look up
Josh Berkus josh@agliodbs.com 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
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
11 matches
Mail list logo