Postgres Pro
Downloads
Home   >   mailing lists

Re: index with LIKE - Mailing list pgsql-general

From Tom Lane
Subject Re: index with LIKE
Date
Msg-id 26657.1087062717@sss.pgh.pa.us
Whole thread Raw
In response to Re: index with LIKE  ("Henrik Steffen" <steffen@city-map.de>)
Responses Re: index with LIKE  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
Tree view 
"Henrik Steffen" <steffen@city-map.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

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Trying to minimize the impact of checkpoints
Next
From: Steve Atkins
Date:
Subject: Re: Opteron scaling with PostgreSQL