Re: Qual push down to table AM

2025-10-18 Thread Mark Dilger
Thanks for the patchset, Julien. v1-0001: All current callers of scan_rescan() pass NULL for the `key` parameter, making it unclear to Table AM authors if this is supposed to be a pointer to a single key, or an array. If an array, how is it terminated? None of this is addressed in the curr

Re: Qual push down to table AM

2025-08-29 Thread Julien Tachoires
Hi, On Thu, Aug 28, 2025 at 02:57:02AM +0500, Kirill Reshke wrote: > Hi! > I was also always wondering if something like quals pushing can be > implemented in Postgres. It is indeed very beneficial for Column-based > processing in MPP databases, Greenplum and Cloudberry to name a few. I > did my o

Re: Qual push down to table AM

2025-08-29 Thread Julien Tachoires
Hi, On Wed, Aug 27, 2025 at 05:50:01PM -0400, Andres Freund wrote: > On 2025-08-27 22:27:37 +0200, Julien Tachoires wrote: > > Please find attached a patch set proposal intended to implement WHERE > > clauses (qual) push down to the underlying table AM during > > table/sequential scan execution. >

Re: Qual push down to table AM

2025-08-27 Thread Kirill Reshke
On Thu, 28 Aug 2025 at 01:27, Julien Tachoires wrote: > > Hi, > > Please find attached a patch set proposal intended to implement WHERE > clauses (qual) push down to the underlying table AM during > table/sequential scan execution. > > The primary goal of this project is to convert quals to ScanKe

Re: Qual push down to table AM

2025-08-27 Thread Andres Freund
On 2025-08-27 22:27:37 +0200, Julien Tachoires wrote: > Please find attached a patch set proposal intended to implement WHERE > clauses (qual) push down to the underlying table AM during > table/sequential scan execution. > > The primary goal of this project is to convert quals to ScanKeys and > p