Re: Alternative SAOP support for GiST

2024-03-18 Thread Michał Kłeczek
Hi All, > On 11 Mar 2024, at 18:58, Michał Kłeczek wrote: > > Hi All, > > During my journey of designing Pg based solution at my work I was severely > hit by several shortcomings in GiST. > The most severe one is the lack of support for SAOP filters as it makes it > difficult to have partitio

Alternative SAOP support for GiST

2024-03-11 Thread Michał Kłeczek
Hi All, During my journey of designing Pg based solution at my work I was severely hit by several shortcomings in GiST. The most severe one is the lack of support for SAOP filters as it makes it difficult to have partition pruning and index (only) scans working together. To overcome the difficu