Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types
Date
Msg-id 4f51168a-3a3e-4bae-b2e9-ba7bb05c06f7@tantorlabs.com
Whole thread Raw
In response to Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
List pgsql-hackers
Have you benchmarked this change except in first message in this thread?

While reviewing the patch more closely, I noticed 
that compute_distinct_stats() is only used for types where we have =, != 
but not <. In practice, most common scalar types go through 
compute_scalar_stats() instead.

That makes me wonder how often this optimization would actually trigger 
in real workloads. Since compute_scalar_stats() is the more common path, 
there's chance that the hash-table based improvement in 
compute_distinct_stats() may not provide a noticeable overall benefit.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/




pgsql-hackers by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Partial Mode in Aggregate Functions
Next
From: Ashutosh Bapat
Date:
Subject: Re: doc: Clarify that empty COMMENT string removes the comment