On Fri, Sep 26, 2008 at 5:03 PM, John Huttley <[EMAIL PROTECTED]> wrote:
> Hi Andrew,
> There are two problems.
> The first is the that if there is a table with a index and an update is
> performed on a non indexed field,
> the index is still re indexed.
I assume you mean updated, not reindexed, a
On Sat, 27 Sep 2008, John Huttley wrote:
I've got 32M shared on a 1G machine and 16 checkpoint segments.
I'll run some tests against 64 segments and see what happens.
Increase shared_buffers to 256MB as well. That combination should give
you much better performance with the type of update yo
