Re: name search query speed

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
Cc: Ken Egervari <ken(at)upfactor(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: name search query speed
Date: 2005-03-03 18:36:45
Message-ID: 4227593D.4020209@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, Jeremiah,

Jeremiah Jahn schrieb:
> yes, it does. I forgot to mention, that I also have clustering on that
> table by my name_field index. My Bad.

Fine. Did you run ANALYZE and CLUSTER on the table after every large
bunch of insertions / updates?

Markus

--
Markus Schaber | Dipl. Informatiker | Software Development GIS

Fight against software patents in EU! http://ffii.org/
http://nosoftwarepatents.org/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremiah Jahn 2005-03-03 20:14:47 Re: name search query speed
Previous Message John A Meinel 2005-03-03 17:46:02 Re: name search query speed