Re: Strange query behaviour between 9.4 and 12beta1

2019-06-04 Thread Tomas Vondra
On Tue, Jun 04, 2019 at 05:34:07PM +0300, Vasilis Ventirozos wrote: Hello everyone, I started comparing performance between postgres 9.4 and 12beta1 more specifically comparing the new (materialized) CTE. Are you saying the CTE is specified as MATERIALIZED in the query on 12? Because I don't s

Strange query behaviour between 9.4 and 12beta1

2019-06-04 Thread Vasilis Ventirozos
Hello everyone, I started comparing performance between postgres 9.4 and 12beta1 more specifically comparing the new (materialized) CTE. The statements i use are application statements that i have little control over, Hardware is identical as both clusters are running on the same server, on the