On Mon, Jul 27, 2009 at 7:52 PM, Janet Jacobsen<[email protected]> 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
