Talk is cheap

Show me the code!

Contribuições no core do PostgreSQL

10

  • Reduce locking required to change table parameters (Simon Riggs, Fabrízio Mello)

9.6

  • Add an IF NOT EXISTS option to ALTER TABLE ADD COLUMN (Fabrízio de Royes Mello)
  • Reduce the lock strength needed by ALTER TABLE when setting fillfactor and autovacuum-related relation options (Fabrízio de Royes Mello, Simon Riggs)

9.5

  • Allow changing of the WAL logging status of a table after creation with ALTER TABLE … SET LOGGED / UNLOGGED (Fabrízio de Royes Mello)
  • Add IF NOT EXISTS clause to CREATE TABLE AS, CREATE INDEX, CREATE SEQUENCE, and CREATE MATERIALIZED VIEW (Fabrízio de Royes Mello)
  • Show tablespace size in psql’s \db+ (Fabrízio de Royes Mello)

9.4

  • DISCARD now also discards sequence-related state (Fabrízio de Royes Mello, Robert Haas)
  • Add recovery parameter recovery_min_apply_delay to delay replication (Robert Haas, Fabrízio de Royes Mello, Simon Riggs)
  • Add DISCARD SEQUENCES command to discard cached sequence-related state (Fabrízio de Royes Mello, Robert Haas)

9.3

  • Add CREATE SCHEMA … IF NOT EXISTS clause (Fabrízio de Royes Mello)

9.2

  • Show role password expiration dates in \du (Fabrízio de Royes Mello)
  • Add pg_xlog_location_diff() to simplify WAL location comparisons (Euler Taveira de Oliveira)

8.4

  • Make to_char()’s localized month/day names depend on LC_TIME, not LC_MESSAGES (Euler Taveira de Oliveira)
  • Add ability to specify per-relation autovacuum and TOAST parameters in CREATE TABLE (Alvaro, Euler Taveira de Oliveira)
  • Make \d on a sequence show its column values (Euler Taveira de Oliveira)
  • Add column storage type and other relation options to the \d+ display (Gregory Stark, Euler Taveira de Oliveira)
  • Add localization support for messages (Euler Taveira de Oliveira)

8.3

  • In initdb, allow the location of the pg_xlog directory to be specified (Euler Taveira de Oliveira)

8.2

  • Allow to_char() to print localized month and day names (Euler Taveira de Oliveira)

8.1

  • Add USING clause to allow additional tables to be specified to DELETE (Euler Taveira de Oliveira, Neil)
  • Create new reindexdb command-line utility by moving /contrib/reindexdb into the server (Euler Taveira de Oliveira)
  • Add pg_postmaster_start_time() function (Euler Taveira de Oliveira, Matthias Schmidt)

8.0

  • Allow changing the owners of aggregates, conversions, databases, functions, operators, operator classes, schemas, types, and tablespaces (Christopher, Euler Taveira de Oliveira)
  • New Brazilian version of FAQ (Euler Taveira de Oliveira)