2009/9/10 <t...@fuzzy.cz>: >> Playing around with seq_page_cost (1) and random_page_cost (1), I can get >> the correct index selected. Applying those same settings to our production >> server does not produce the optimal plan, though. > > I doubt setting seq_page_cost and random_page_cost to the same value is > reasonable - random access is almost always more expensive than sequential > access.
If the data figures to be read from the OS cache, it's very reasonable, and the right value is somewhere in the 0.05 - 0.10 range. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance