PostgresCafe @PostgresCafe

PostgreSQL Tips and Tricks Joined September 2018

Tweets

13
Followers

12
Following

25
Likes

9

PostgresCafe @PostgresCafe

2 months ago

Avoid using TIMESTAMP (WITHOUT TIME ZONE) in Postgres Use TIMESTAMPTZ when storing a specific point in time. The naive TIMESTAMP lacks time zone context, making it unsuitable for time arithmetic. It also offers no performance or storage advantage over TIMESTAMPTZ.

0 0 1 16 0

PostgresCafe @PostgresCafe

3 months ago

PostgreSQL 18 Beta 1 has been released, introducing several new GUC parameters. You can explore the full list here: postgresqlco.nf/doc/en/param/. Interested in specific additions like io_method or extension_control_path? Check out their documentation for details.

0 1 2 39 0

PostgresCafe @PostgresCafe

4 years ago

Features of @PostgreSQL 14: GUC default_toast_compression postgresqlco.nf/doc/en/param/d… Now you can use "lz4" as the compression method for toast tables providing faster compression than the default "pglz". #NewFeatures #PostgreSQL14

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: FETCH FIRST WITH TIES WITH TIES is an option to the FETCH FIRST N ROWS clause, where you additionally get rows that compare equal to the last of those N rows by the columns in the mandatory ORDER BY clause. #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgreSQL @PostgreSQL

5 years ago

News: PostgreSQL 13 Released! postgresql.org/about/news/207…

5 365 651 0 4

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: GUC max_slot_wal_keep_size postgresqlco.nf/en/doc/param/m… Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: GUC hash_mem_multiplier postgresqlco.nf/en/doc/param/h… Allow hash aggregation and grouping sets to use disk storage for large aggregation result sets. #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: DROP DATABASE FORCE The database can now be forcibly dropped even if there are connected users. DROP DATABASE database_name [[WITH] (FORCE)] #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: Incremental sort Is a way to reduce the resources used for multi-column sorting. This feature can be controlled by the 'enable_incrementalsort' parameter. The default value is 'on'. #NewFeatures #PostgreSQL13

0 0 1 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: Remove pseudo-type opaque. Remove support for "opaque" pseudo-types. This data type was used for compatibility from PostgreSQL 7.3 and earlier. #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: LOCALE option in CREATE DATABASE The LOCALE clause can now be specified as an option in the CREATE DATABASE statement. This is a shortcut for setting LC_COLLATE and LC_CTYPE at once. CREATE DATABASE music LOCALE 'es_NI.utf8' #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: Generate a random UUID PostgreSQL includes one function to generate a UUID without installing additional supplied modules: gen_random_uuid () → uuid #NewFeatures #PostgreSQL13

0 0 0 0 0

PostgresCafe @PostgresCafe

5 years ago

Features of @PostgreSQL 13: Deduplication of B-Tree index Deduplication is now executed by default for B-Tree indexes. Storage capacity and I/O can be reduced. #NewFeatures #PostgreSQL13