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