Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 25 Minuten 29 Sekunden

Mark Wong: Demo of another benchmarking framework

21. Januar 2021 - 22:23

At PGCon 2020, I gave a presentation proposing that the PostgreSQL community could use better benchmarking tools to serve the open source developers.  Some of us continued discussing that during the unconference shortly after.  Here I describe a proof of concept for an open source framework to run, but not necessarily limited to, user defined benchmarks that follows the model of loading a database and running a s

Paul Ramsey: Production PostGIS Vector Tiles: Caching

21. Januar 2021 - 20:08

Building maps that use dynamic tiles from the database is a lot of fun: you get the freshest data, you don't have to think about generating a static tile set, and you can do it with very minimal middleware, using pg_tileserv.

Hans-Juergen Schoenig: Golden Proportions in PostgreSQL

21. Januar 2021 - 11:00

As CYBERTEC keeps expanding, we need a lot more office space than we previously did. Right now, we have a solution in the works: a new office building. We wanted something beautiful, so we started to dig into mathematical proportions to achieve a reasonable level of beauty. We hoped to make the building not just usable, but also to have it liked by our staff.

I stumbled upon some old books about proportions in architecture and went to work. Fortunately, one can use PostgreSQL to do some of the more basic calculations needed.

Kaarel Moppel: Tips and tricks to kick-start the Postgres year 2021

19. Januar 2021 - 9:00

I decided to start out this year by looking into my notes from last year and extracting from them a small set of Postgres tips for you. This might not be, strictly speaking, fresh news… but I guess the average RAM of tech workers is about 64KB or so nowadays, so some repetition might not be such a bad thing.

Andreas 'ads' Scherbaum: Marc Linster

18. Januar 2021 - 15:00
PostgreSQL Person of the Week Interview with Marc Linster: I was born and raised in Luxembourg. After getting a computer science degree at the University of Kaiserslautern, I joined the Gesellschaft für Mathematik und Datenverarbeitung (today part of Fraunhofer Gesellschaft) working on expert systems and AI. In 1992, I moved to the US, working in the software and consulting business, always with a focus on data and databases. After four years at Polycom, where I had the opportunity to work on their Video as a Service, I joined EDB in 2013.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time

18. Januar 2021 - 13:30
On 17th of January 2021, Magnus Hagander committed patch: Add pg_stat_database counters for sessions and session time   This add counters for number of sessions, the different kind of session termination types, and timers for how much time is spent in active vs idle in a database to pg_stat_database.

Luca Ferrari: PostgreSQL Literate Programming with GNU Emacs

18. Januar 2021 - 1:00

GNU Emacs is great! I can prepare my slides with PostgreSQL snippets of code and results.

Egor Rogov: MVCC in PostgreSQL — 6. Vacuum

18. Januar 2021 - 1:00

We started with problems related to isolation, made a digression about low-level data structure, then discussed row versions and observed how data snapshots are obtained from row versions.