Re: Zero throughput on a query on a very large table.

"ldh@laurent-hasson.com" <ldh@laurent-hasson.com> writes:
> Second, here is what i found and what messed us up.

>     select current_setting('random_page_cost'); --> 4
>     alter database "CMS_TMP" set random_page_cost=0.00000001;
>     select current_setting('random_page_cost'); --> 4 ????

ALTER DATABASE only affects subsequently-started sessions.

> I also tried:
>     select current_setting('random_page_cost'); --> 4
>     select set_config('random_page_cost', '0.000001', true);
>     select current_setting('random_page_cost'); --> 4 ????

That "true" means "local to the current transaction", which is
just the one statement if you don't have a BEGIN.

            regards, tom lane