Re: general question on two-partition table

On Mon, Jul 27, 2009 at 7:52 PM, Janet Jacobsen<jsjacobsen@lbl.gov> wrote:

> Can you suggest other strategies?

Something that might be easier to play with is to create a (or
several, to speed up other queries) functional index on the comparison
between rbscore and the cutoff. It won't buy you anything on seq
scans, but if most of the queries are done on small subsets of the
tuples which meet the "good" criteria, it could be a big win that's
very easy to implement.

--
- David T. Wilson
david.t.wilson@gmail.com