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

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>, pgsql-performance(at)postgresql(dot)org
Cc: harvsys(at)morgan(dot)harvard(dot)edu, russo(at)morgan(dot)harvard(dot)edu
Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7
Date: 2007-05-08 14:54:48
Message-ID: 601821.86400.qm@web31815.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


--- Susan Russo <russo(at)morgan(dot)harvard(dot)edu> wrote:
> and accession like 'AY851043%'

I don't know if you've tried refactoring your query, but you could try:

AND accession BETWEEN 'AY8510430' AND 'AY8510439' -- where the last digit is
^ ^ -- lowest AND highest expected value

Regards,
Richard Broersma Jr.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Staubo 2007-05-08 14:59:30 Re: specific query (not all) on Pg8 MUCH slower than Pg7
Previous Message Steinar H. Gunderson 2007-05-08 14:48:34 Re: specific query (not all) on Pg8 MUCH slower than Pg7