Am 05.08.19 um 22:47 schrieb Mariel Cherkassky:
Hey,
I have a very big query that consist from 3-4 subqueries that use
windows functions. There is a chance that I'll need to rewrite the
query but first I'm trying to search for other ways to improve it and
I'll be happy to hear if one of u h
Hey,
I have a very big query that consist from 3-4 subqueries that use windows
functions. There is a chance that I'll need to rewrite the query but first
I'm trying to search for other ways to improve it and I'll be happy to hear
if one of u have an idea.
Basically my table has the following struc
Tom Lane schrieb am 03.08.2019 um 18:05:
> Yeah, I get the same plan with or without ANALYZE, too. In this example,
> having the ANALYZE stats barely moves the rowcount estimates for
> foo_bar_baz at all, so it's not surprising that the plan doesn't change.
> (I do wonder how Thomas got a differen
