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
Greetings,
* Haroldo Kerry (hke...@callix.com.br) wrote:
> The bottleneck at dump is CPU (a single one, on a 44 thread server), as we
> are using the -Fc option, that does not allow multiple jobs.
> We tried some time ago to use the --jobs option of pg_dump but it was
> slower, even with more thre
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
