Re: Performance Question

Поиск
Список
Период
Сортировка
От Tim Perdue, The Des Moines City.net
Тема Re: Performance Question
Дата
Msg-id 015601be5157$80192a10$0b8c5aa5@timnt.weather.net
обсуждение исходный текст
Ответ на Performance Question  ("Tim Perdue" <tim@directricity.com>)
Список pgsql-sql
I did finally get most of the data dropped into the Postgres database. It's
now sitting at 55,000 email messages (100MB).

Even with a huge mix of records, search time is not impacted as far as I can
tell. Queries come back just as quickly as they did before.

I did discover that indexes on the text fields are not being used when I use
a Regex operator. So I dropped the index with no performance hit.

Thanks to everyone for their input,

Tim Perdue
geocrawler.com


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [SQL] Function returning multiple rows?
Следующее
От: "Bryan White"
Дата:
Сообщение: Functional Indexes