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
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
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