Thread: Is it possible to set a timeout for optimization in PostgreSQL?

Is it possible to set a timeout for optimization in PostgreSQL?

From

Zhan Li

Date:

04 November 2014, 05:01:14

Hi all,

In PostgreSQL is there a timeout when the optimizer stops the optimization process and returns the least expensive plan it has found so far? Is it possible to change its value?

Thanks,

Zhan

Re: Is it possible to set a timeout for optimization in PostgreSQL?

From

Andreas Kretschmer

Date:

04 November 2014, 06:13:57


> Zhan Li <zhanli89@gmail.com> hat am 4. November 2014 um 03:01 geschrieben:
>
>
> Hi all,
>
> In PostgreSQL is there a timeout when the optimizer stops the optimization
> process and returns the least expensive plan it has found so far? Is it
> possible to change its value?
>
> Thanks,
> Zhan


Please read http://www.postgresql.org/docs/current/static/geqo-pg-intro.html.