Re: Idea: Add first() and last() aggregate functions to the main release

On Sat, 11 Mar 2023 at 23:38, Ben Clements wrote: > Idea/request for enhancement: > > Add the first() and last() aggregate functions to the main release (CREATE > EXTENSION first_last_agg). > > Use Case: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK > FIRST/LAST ORDER BY ...)

Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

On 3/11/23 14:23, Atul Kumar wrote: Hi, Could someone help me in telling the difference between these three parameters 1. max_standby_archive_delay 2. max_standby_streaming_delay 3. recovery_min_apply_delay My basic motive is to make the standby database server to be delayed to apply the cha

confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

Hi, Could someone help me in telling the difference between these three parameters 1. max_standby_archive_delay 2. max_standby_streaming_delay 3. recovery_min_apply_delay My basic motive is to make the standby database server to be delayed to apply the changes on itself, if any data has been acc

Re: ERROR: only immutable functions supported in continuous aggregate view

Martijn de Munnik writes: > The error is caused by the jsonb_build_object function, is there any > reason why this function is not IMMUTABLE? It can invoke arbitrary datatype output functions, some of which are not immutable. We unfortunately lack any infrastructure that would allow reasoning th

ERROR: only immutable functions supported in continuous aggregate view

Hi List, I'm trying to create a TimescaleDB continuous aggregate using the following statement: CREATE MATERIALIZED VIEW "navigation_data_5min_hidden" WITH (timescaledb.continuous) AS SELECT   public.time_bucket(INTERVAL '5 min', "time") AS "time",   "context",   jsonb_build_object(     'max

Idea: Add first() and last() aggregate functions to the main release

Idea/request for enhancement: Add the first() and last() aggregate functions to the main release (CREATE EXTENSION first_last_agg). Use Case: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) (https://dba.stackexch