This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH | |
constants AS ( | |
SELECT | |
current_setting('server_version') AS version, | |
current_setting('block_size')::int AS block_size, | |
current_setting('autovacuum_vacuum_cost_delay') AS cost_delay, | |
1000 / extract(milliseconds FROM current_setting('autovacuum_vacuum_cost_delay')::interval) AS delays_per_sec, | |
COALESCE(NULLIF(current_setting('autovacuum_vacuum_cost_limit')::int, -1), current_setting('vacuum_cost_limit')::int) AS cost_limit, | |
current_setting('vacuum_cost_page_hit')::int AS cost_hit, | |
current_setting('vacuum_cost_page_miss')::int AS cost_miss, |
- Move away from PGXN type META.json metadat form or stick to it? We could think of a way to impove metadata colletion for an extension. (but sticking to a widely accepted standard like PGXN or considering improvements aligns with best practices)
-(Provide users with options for manual intervention in case they want more control over dependencies)
OlderNewer