Re: index with LIKE

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: index with LIKE
Date: 2004-06-16 20:10:26
Message-ID: 1087416625.1582.39.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2004-06-16 20:27:13 Database accesss using plperl
Previous Message Henrik Steffen 2004-06-16 19:11:09 Re: index with LIKE