Re: Updates are slow..

From: Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Burke <lists(at)spamex(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Updates are slow..
Date: 2002-06-13 18:00:00
Message-ID: Pine.LNX.4.33.0206131106420.23500-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Blood 2002-06-13 18:12:48 Re: Contrib reindex script:
Previous Message wsheldah 2002-06-13 17:34:44 Re: Updates are slow..