Re: Re[2]: Postgresql planning time too high

2019-11-22 Thread Pavel Stehule
pá 22. 11. 2019 v 12:46 odesílatel Sterpu Victor napsal: > No rows should be returned, DB is empty. > I'm testing now on a empty DB trying to find out how to improve this. > > In this query I have 3 joins like this: > > SELECT t1.id, t2.valid_from > FROM t1 > JOIN t2 ON (t1.id_t1 = t1.id) > LEFT

RE: Re[2]: Postgresql planning time too high

2019-11-22 Thread Fırat Güleç
Could you run VACCUM ANALYZE. *From:* Sterpu Victor *Sent:* Friday, November 22, 2019 2:46 PM *To:* Fırat Güleç *Cc:* pgsql-performance@lists.postgresql.org *Subject:* Re[2]: Postgresql planning time too high I did runned "VACCUM FULL" followed by "VACUUM" but no difference. -- Orig