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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)postgresql(dot)org, Zhan Li <zhanli89(at)gmail(dot)com>
Subject: Re: Is it possible to set a timeout for optimization in PostgreSQL?
Date: 2014-11-04 03:13:50
Message-ID: 988520069.51569.1415070830760.open-xchange@oxweb01.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Zhan Li <zhanli89(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-11-04 04:15:15 Re: Help with PostgreSQL 9.4 to expand jsonb int array into table with row numbers
Previous Message Zhan Li 2014-11-04 02:01:09 Is it possible to set a timeout for optimization in PostgreSQL?