Re: index with LIKE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "'Martijn van Oosterhout'" <kleptog(at)svana(dot)org>, "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: index with LIKE
Date: 2004-06-12 17:51:57
Message-ID: 26657.1087062717@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> any other idea?

Let's see EXPLAIN ANALYZE results from both servers?

Also, can you force an indexscan to be chosen by setting enable_seqscan
off? If so, let's see that EXPLAIN ANALYZE too.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2004-06-12 18:06:27 Re: Opteron scaling with PostgreSQL
Previous Message Jack Orenstein 2004-06-12 17:44:34 Re: Trying to minimize the impact of checkpoints