Re: specific query (not all) on Pg8 MUCH slower than Pg7

From: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>
To: russo(at)morgan(dot)harvard(dot)edu, sgunderson(at)bigfoot(dot)com
Cc: harvsys(at)morgan(dot)harvard(dot)edu, pgsql-performance(at)postgresql(dot)org
Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7
Date: 2007-05-08 15:19:55
Message-ID: 200705081519.l48FJtsT028597@larrys.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Eisentraut 2007-05-08 15:22:16 Nested loops overpriced
Previous Message Tom Lane 2007-05-08 15:05:48 Re: specific query (not all) on Pg8 MUCH slower than Pg7