Re: Adding nextval() to a select caused hang/very slow execution
Eric Raskin <eraskin@paslists.com> writes:
> So, things get even weirder. When I execute each individual select
> statement I am generating from a psql prompt, they all finish very
> quickly.
> If I execute them inside a pl/pgsql block, the second one hangs.
> Is there something about execution inside a pl/pgsql block that is
> different from the psql command line?
Generic vs specific plan, perhaps? Are you passing any parameter
values in from plpgql variables?
IIRC, you could force the matter by using EXECUTE, though it's
somewhat more notationally tedious. In late-model PG versions,
plan_cache_mode could help you too.
regards, tom lane
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Eric H. Raskin 914-765-0500 x120 or 315-338-4461 (direct)
Professional Advertising Systems Inc. fax: 914-765-0500 or 315-338-4461 (direct)
3 Morgan Drive #310 eraskin@paslists.com
Mt Kisco, NY 10549 http://www.paslists.com
В списке pgsql-performance по дате отправления: