Re: Partial aggregates pushdown - Mailing list pgsql-hackers

From Alexander Pyhalov
Subject Re: Partial aggregates pushdown
Date
Msg-id e78f9b81dff902b27ee868caa60d0502@postgrespro.ru
Whole thread Raw
In response to Re: Partial aggregates pushdown  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Partial aggregates pushdown  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers
Tomas Vondra писал 2021-10-15 17:56:
> Hi Alexander,
> 

Hi.

> And then we should extend this for aggregates with more complex
> internal states (e.g. avg), by supporting a function that "exports"
> the aggregate state - similar to serial/deserial functions, but needs
> to be portable.
> 
> I think the trickiest thing here is rewriting the remote query to call
> this export function, but maybe we could simply instruct the remote
> node to use a different final function for the top-level node?
> 
> 

If we have some special export function, how should we find out that 
remote server supports this? Should it be server property or should it 
somehow find out it while connecting to the server?

-- 
Best regards,
Alexander Pyhalov,
Postgres Professional



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Partial aggregates pushdown
Next
From: Tomas Vondra
Date:
Subject: Re: Partial aggregates pushdown