Re: Updates are slow.. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Updates are slow..
Date
Msg-id Pine.LNX.4.33.0206131106420.23500-100000@css120.ihs.com
Whole thread Raw
In response to Re: Updates are slow..  ("Tom Burke" <lists@spamex.com>)
List pgsql-general
On Thu, 13 Jun 2002, Tom Burke wrote:

> I didn't receive any response to my last post, but I've got a little
> more info and have 2 questions.
>
> I dropped the index on email.
> I then populated a smallint field with random value from 0 - 2000
> and created an in index on that field.

Have you tried other indexing methods (rtree, hash, gist) to see if any
of them work better for your data set?  I'd try that first.



pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Re: Updates are slow..
Next
From: "David Blood"
Date:
Subject: Re: Contrib reindex script: