Michael Paquier - PostgreSQL committer

  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags
  • About

Postgres 9.3 feature highlight - event triggers

2013-09-13 06:01:01 +0000

Event triggers is a new kind of statement-based trigger added in PostgreSQL 9.3. Compared to normal triggers fired when DML queries run on a given table, event triggers are fired for DDL queries and are global to a database. The use cases of event triggers are various.

Read more...

Playing with large objects in Postgres

2013-09-04 03:54:14 +0000

PostgreSQL has for ages a feature called large objects allowing to store in the database objects with a… Well… Large size. All those objects are stored in dedicated catalog tables called pg_largeobject_metadata for general information like ownership and pg_largobject for the data itself, data divided into pages of 2kB (default size, defined as BLCKSZ/4). This feature got its major upgrade in 9.0 with the introduction of ownership of a large object and 9.3 with the maximum size of an object increased to 4TB. This maximum size was 2GB in versions prior to 9.2. One of the main advantages of a large object is its maximum size, which is particularly convenient compared for example to TOAST whose maximum size is 1GB (an internal storage system that stores objects larger than a single page, usually 8kB).

Read more...

Postgres module highlight - customize passwordcheck to secure your database

2013-08-24 06:26:37 +0000

passwordcheck is a contrib module present in PostgreSQL core using a hook present in server code when creating or modifying a role with CREATE/ALTER ROLE/USER able to check a password. This hook is present in src/backend/commands/user.c and called check_password_hook if you want to have a look. This module basically checks the password format and returns an error to the user if the password does not satisfy the conditions defined in the module.

Read more...

Tuning disks and Linux for Postgres

2013-08-23 02:19:18 +0000

Tuning the OS on which is running a database server is important to get good performance for an application. There are many tricks to know when tuning a system, being generally dependent on the application used and the hardware on which the system is running. Here are some general guidelines that you could get inspiration from when tuning your own environment.

Read more...

Postgres 9.4 feature highlight - dynamic background workers

2013-08-12 07:54:18 +0000

Following the recent API modifications done in Postgres 9.3 for background worker processes, here is more information about the latest features of background workers currently being developed for Postgres 9.4, and introduced by this commit:

Read more...

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Next »

Search

Social

Github

Mastodon

Twitter

RSS Feeds

Main

Postgres

Sponsor

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.