Re: Performance Question - Mailing list pgsql-sql

From Tim Perdue, The Des Moines City.net
Subject Re: Performance Question
Date
Msg-id 015601be5157$80192a10$0b8c5aa5@timnt.weather.net
Whole thread Raw
In response to Performance Question  ("Tim Perdue" <tim@directricity.com>)
List 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 by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Function returning multiple rows?
Next
From: "Bryan White"
Date:
Subject: Functional Indexes