News for hackers. Stuff that matters.
Re:Why PostgreSQL doesn't have query hints by mcfunley on Friday February 04, 2011 @12:27PM (#2180222)
By 'enum' I meant in the more general sense, a constrained set of a few values. In our case the original schema designer used a text column for states: 'active,' 'dead,' etc. The planner would generally guess incorrectly about the range of values it might expect to find in a text column like that and working around it required hand fiddling.

(Disclaimer: forgive me, it's been a few years since I've had to deal with this specific problem, some of the details may be off.)

Re:Why PostgreSQL doesn't have query hints by rbranson on Friday February 04, 2011 @01:35PM (#2180543)
Was it indexing the faux-enum columns? First thing I would do would be to drop the index if there is one considering it will add very little to the selectivity of the query.