Re: State of Beta 2 - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: State of Beta 2
Date
Msg-id 20030911112925.W57860@ganymede.hub.org
Whole thread Raw
In response to Re: State of Beta 2  (Vivek Khera <khera@kcilink.com>)
Responses Re: State of Beta 2  (Vivek Khera <khera@kcilink.com>)
Re: State of Beta 2  (Sean Chittenden <sean@chittenden.org>)
List pgsql-general

On Thu, 11 Sep 2003, Vivek Khera wrote:

> >>>>> "sm" == scott marlowe <scott.marlowe> writes:
>
> >> I'm pondering doing the same, but I'm not 100% sure there won't be any
> >> dump/restore-required changes to it before it goes gold.  From my
> >> tuning tests I've been running on it, it appears to be extremely fast
> >> and stable.
>
> sm> Yeah, right now it's looking like the only thing you'll have to do is
> sm> reindex hash indexes between beta2 and beta3.
>
>
> Sean had grumbled something about making pagesize 16k on FreeBSD for
> 7.4 but it seems unlikely.  I'll just locally patch it since it does
> seem to offer some improvement.

Without a fair amount of testing, especially on other platforms, it most
likely won't happen in the distribution itself ... one of the things that
was bantered around for after v7.4 is released is seeing how increasing it
on the various platforms fairs, and possibly just raising the default to
16k or 32k (Tatsuo mentioned a 15% improvement at 32k) ...

But, we'll need broader testing before that happens ...

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: I need a SQL...
Next
From: Vivek Khera
Date:
Subject: Re: A Question About Insertions -- Performance