Re: Postgresql planning time too high

2019-11-22 Thread Tomas Vondra
On Fri, Nov 22, 2019 at 11:44:51AM +, Sterpu Victor wrote: No rows should be returned, DB is empty. I'm testing now on a empty DB trying to find out how to improve this. I'm a bit puzzled why you're doinf tests on an empty database, when in production it'll certainly contain data. I guess

RE: Postgresql planning time too high

2019-11-22 Thread Fırat Güleç
Hello Sterpu, First, please run vaccum for your Postgresql DB. No rows returned from your query. Could you double check your query criteria. After that could you send explain analyze again . Regards, *FIRAT GÜLEÇ* Infrastructure & Database Operations Manager firat.gu...@hepsijet.com

Re: Postgresql planning time too high

2019-11-22 Thread Luís Roberto Weck
o.ro>> Cc: pgsql-performance@lists.postgresql.org <mailto:pgsql-performance@lists.postgresql.org> Sent: 2019-11-22 1:35:15 PM Subject: RE: Postgresql planning time too high Hello Sterpu, First, please run vaccum for your Postgresql DB. No rows returned from your query. Could you double ch