Postgres Pro
Downloads
Home   >   mailing lists

Re: name search query speed - Mailing list pgsql-performance

From Markus Schaber
Subject Re: name search query speed
Date
Msg-id 4227593D.4020209@logix-tt.com
Whole thread Raw
In response to Re: name search query speed  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: name search query speed
Next
From: Jeremiah Jahn
Date:
Subject: Re: name search query speed