News for hackers. Stuff that matters.
Re:Pg_later: Asynchronous Queries for Postgres by gavinray on Friday August 18, 2023 @02:38PM (#37180155)
I tested the following and it seems to work:

    CREATE OR REPLACE FUNCTION run_with_adjusted_settings(query_text text)
    RETURNS SETOF record
    LANGUAGE plpgsql
    AS $$
    DECLARE 
        result_record record;
    BEGIN
        -- set_config ( setting_name text, new_value text, is_local boolean ) → text
        -- Sets the parameter setting_name to new_value, and returns that value.
        -- If is_local is true, the new value will only apply during the current transaction.
        PERFORM set_config('statement_timeout', '10s', true);
        PERFORM set_config('work_mem', '1MB', true);
        PERFORM set_config('maintenance_work_mem', '1MB', true);
        PERFORM set_config('max_parallel_workers_per_gather', '1', true);

        -- Execute the provided query dynamically and return the results
        FOR result_record IN EXECUTE query_text
        LOOP
            RETURN NEXT result_record;
        END LOOP;

        RETURN;
    END;
    $$;

    -- Example usage:
    SELECT *
    FROM run_with_adjusted_settings('SELECT 1 as id, false as some_bool;') AS (id int, some_bool boolean);

There are no comments on this comment yet.