Re: Updates are slow..

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Updates are slow..
Дата
Msg-id Pine.LNX.4.33.0206131106420.23500-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Updates are slow..  ("Tom Burke" <lists@spamex.com>)
Список 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 по дате отправления:

Предыдущее
От: wsheldah@lexmark.com
Дата:
Сообщение: Re: Updates are slow..
Следующее
От: "David Blood"
Дата:
Сообщение: Re: Contrib reindex script: