On Mon, Jan 30, 2012 at 3:19 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Mon, Jan 30, 2012 at 2:55 PM, Alessandro Gagliardi > <alessandro@xxxxxxxx> wrote: >> I set random_page_cost to 2 (with enable_seqscan on) and get the same >> performance I got with enable_seqscan off. >> So far so good. Now I just need to figure out how to set it globally. :-/ > > alter database set random_page_cost=2.0; That should be: alter database dbnamegoeshere set random_page_cost=2.0; -- To understand recursion, one must first understand recursion. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
