Received: from slip3.raccoon.com (slip3.raccoon.com [165.90.134.130]) by hub.org (8.9.2/8.9.1) with ESMTP id RAA95560 for ; Fri, 5 Feb 1999 17:35:25 -0500 (EST) (envelope-from tim@dmcity.net) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip3.raccoon.com (8.8.7/8.8.7) with SMTP id QAA03123 for ; Fri, 5 Feb 1999 16:40:46 -0600 Message-ID: <015601be5157$80192a10$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: Subject: Re: Performance Question Date: Fri, 5 Feb 1999 16:33:05 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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