On 3/15/2015 6:54 AM, Robert Kaye wrote:
Hi!
We at MusicBrainz have been having trouble with our Postgres install
for the past few days. I’ve collected all the relevant information here:
http://blog.musicbrainz.org/2015/03/15/postgres-troubles/
If anyone could provide tips, suggestions or ot
On 12/18/2011 1:31 PM, Tom Lane wrote:
If you have a specific case where that's not true, you might consider
a partial index (CREATE INDEX ... WHERE x <> constant). But the
details of that would depend a lot on the queries you're concerned
about. regards, tom lane
Which I had tried in the fo
ter basing on check constraint?
2011/12/17 Roxanne Reid-Bennett:
I have a query that used<> against an indexed column. In this
case I can use the reverse and use in or = and get the performance
I need... but "in general"... will the planner ever use an index when the
related co
I have a query that used <> against an indexed column. In this
case I can use the reverse and use in or = and get the performance
I need... but "in general"... will the planner ever use an index when
the related column is compared using <>?
I feel like the answer is no, but wanted to ask.
Roxa
