DatenbankenPlanet PostgreSQLEnglisch (hoher Informationsgehalt bei geringem lokalem Volumen)
Datenbanken
Postgres gives you no way to take back a single statement. When someone runs an UPDATE without its WHERE clause, recovery is a procedure rather than a command. You restore a copy of the database to the moment before the mistake, pull out…
A first look at what CloudNativePG 1.31 will bring to PostgreSQL credentials: a DatabaseRole can now generate its own password, keep it in a Secret the operator owns, shape it with criteria and rotate it on a schedule, with PostgreSQL…
On 12 October, the PostgreSQL User Group Vienna met, organized by * Cornelia Biacsics * Ranjeet Kumar Speakers: Mayur B. Radim Marek On 13 October, the San Francisco Bay Area PostgreSQL Meetup Group met online. Christophe Pettus delivered…
PostgreSQL 15's `recursive_worktable_factor` helps you fix slow recursive CTEs by tuning a single estimate. (I consult on PostgreSQL through PGX Inc..)