From: Tom Lane
Sent: Saturday, November 24, 2018 3:32:41 PM
To: Amit Langote
Cc: Jung, Jinho; pgsql-hack...@postgresql.org
Subject: Re: Regarding performance regression on specific query
Amit Langote writes:
> On 2018/11/20 2:49, Jung, Jinho wrote:
>> [ assorted queri
Amit Langote writes:
> On 2018/11/20 2:49, Jung, Jinho wrote:
>> [ assorted queries ]
> I noticed that these two are fixed by running ANALYZE in the database in
> which these queries are run.
That didn't help much for me. What did help was increasing
join_collapse_limit and from_collapse_limit
On Tue, Nov 20, 2018 at 10:08 PM Jung, Jinho wrote:
> We are wondering how ANALYZE mitigated regression from query "1.sql" and
> "4.sql".
>
> We followed this procedure but still observe performance regression:
> 1) run ANALYZE on used table_name
> analyze pg_catalog.pg_ts_parser;
> analy
itbug/)
Jinho Jung
From: Amit Langote
Sent: Tuesday, November 20, 2018 2:47:54 AM
To: Jung, Jinho; pgsql-hack...@postgresql.org
Subject: Re: Regarding performance regression on specific query
Hi,
On 2018/11/20 2:49, Jung, Jinho wrote:
> Execution time
> =
> 1.sql
> 10.6 :
Hi,
On 2018/11/20 2:49, Jung, Jinho wrote:
> Execution time
> =
> 1.sql
> 10.6 : 469 ms
> 9.4.20: 10 ms
>
> 4.sql
> 10.6 : 34019 ms
> 9.4.20: 0.4 ms
I noticed that these two are fixed by running ANALYZE in the database in
which these queries are run.
> 20.sql
> 10.6 : 2791 ms
> 9
Hello,
I am Jinho Jung, PhD student at Georgia Tech and I am conducting DB performance
research. I am sending our evaluation result to get the feedback regarding our
findings.
We found several performance regression queries. Attached files are three of
them that we confirmed performance regre
