Re: index with LIKE - Mailing list pgsql-general

From Scott Marlowe
Subject Re: index with LIKE
Date
Msg-id 1087416625.1582.39.camel@localhost.localdomain
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
1: Is index capable of being used on the slaves, or are they just making
bad decisions?  Try disabling seq scans on the slave servers for testing
and see if they can use the index.  Use "set enable_seqscan = FALSE;"

If they can't use the index then, then they are likely in the wrong
locale, and you'll need to re initdb them to get them to use an index.

If they can use the index then we have tuning issue.


pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: why no answer? [Fwd: backup and restore just with use of jdbc?]
Next
From: Robert Fitzpatrick
Date:
Subject: Database accesss using plperl