Postgres Pro
Downloads
Home   >   mailing lists

Re: specific query (not all) on Pg8 MUCH slower than Pg7 - Mailing list pgsql-performance

From Susan Russo
Subject Re: specific query (not all) on Pg8 MUCH slower than Pg7
Date
Msg-id 200705081519.l48FJtsT028597@larrys.harvard.edu
Whole thread Raw
In response to specific query (not all) on Pg8 MUCH slower than Pg7  (Susan Russo <russo@morgan.harvard.edu>)
Responses Re: specific query (not all) on Pg8 MUCH slower than Pg7
List pgsql-performance
Tree view 
Hi,

>You could always try
>
>  CREATE INDEX test_index ON dbxref (accession varchar_pattern_ops);

WOW!  we're now at runtime 0.367ms on Pg8

Next step is to initdb w/C Locale (tonight) (Thanks Tom et al.!).

Thanks again - will report back soon.

Susan

pgsql-performance by date:

Previous
From: Peter Eisentraut
Date:
Subject: Nested loops overpriced
Next
From: Alvaro Herrera
Date:
Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7