Re: Reuse of State value in Aggregates

From: Antonin Houska <ah(at)cybertec(dot)at>
To: gg pw <lucenaalmirjames123(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Reuse of State value in Aggregates
Date: 2021-11-10 07:40:12
Message-ID: 45167.1636530012@antos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

gg pw <lucenaalmirjames123(at)gmail(dot)com> wrote:

> Do Aggregate functions/queries reuse the state value they generate for subsequent queries? If not then an explanation would be greatly appreciated.

The subsequent queries are not supposed to feed the same input into the
aggregates, so their aggregate states will most likely be different. Maybe you
need to post an example where you think such reusing would be useful.

--
Antonin Houska
Web: https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2021-11-10 08:05:31 Re: Add connection active, idle time to pg_stat_activity
Previous Message Greg Nancarrow 2021-11-10 07:12:34 Re: On login trigger: take three