On Wed, Mar 25, 2009 at 10:28 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Bryan Murphy <bmurphy1976@xxxxxxxxx> writes: >> What I did was change seq_page_cost back to 1.0 and then changed >> random_page_cost to 0.5 > > [ squint... ] It makes no physical sense for random_page_cost to be > less than seq_page_cost. Please set them the same. > > regards, tom lane Done. Just saw the tip in the docs as well. Both are set to 0.5 now and I'm still getting the good query plan. Thanks! Bryan -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
