On Mon, Jan 30, 2012 at 3:19 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > On Mon, Jan 30, 2012 at 2:55 PM, Alessandro Gagliardi > <alessandro@path.com> 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.