anarazel

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,

cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

IshaanAdarsh

Improvements/Enhancements for PGPM:

Enhanced Metadata:

• 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)

Automatic Dependency Installation:(kinda like homebrew)

-(Provide users with options for manual intervention in case they want more control over dependencies)