Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 49 Minuten

Bo Peng: Query Load Balancing in Pgpool-II

30. Dezember 2020 - 6:25
Pgpool-II is a PostgreSQL cluster management tool. The major features of Pgpool-II are:

Asif Rehman: Checkpoints In PostgreSQL

29. Dezember 2020 - 18:52

PostgreSQL database writes all changes happening in the database to a log file before it writes them to the actual data files. These log files are called WAL (Write-Ahead Log). Until these changes are flushed to the disk, they are kept in memory and is returned from the memory when it’s asked for. Writing to the data files directly is a costly operation for several reasons and is performed periodically.

Hubert 'depesz' Lubaczewski: How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2

29. Dezember 2020 - 14:30
In previous post I showed how I'd install PostgreSQL for developer. But that's not all. Now we need to add some configuration. What, how, where? First let's talk about where can we put configuration. Initially the place for PostgreSQL config is postgresql.conf, which is in /etc/postgresql/13/main/postgresql.conf.

Robins Tharakan: What Postgres SQL causes a Table Rewrite?

29. Dezember 2020 - 8:54

While developing SQL based applications, it is commonplace to stumble on these 2 questions:

  1. What DDLs would block concurrent workload?
  2. Whether a DDL is going to rewrite the table (and in some cases may need ~ 2x disk space)?

Although completely answering Question 1 is beyond the scope of this post, one of the important pieces that helps answering both of these questions is whether a DDL is going to cause a relfilenode change..

Devrim GÜNDÜZ: RPM repository for unsupported PostgreSQL releases / distros

28. Dezember 2020 - 14:10
PostgreSQL RPM repository has been out for quite a long time, and we've been building packages since PostgreSQL 7.3. If you are using an unsupported PostgreSQL version or Red Hat / CentOS / Scientific Linux / Oracle Linux release for some reason and need RPMs of those releases, we have archives of them.
Continue reading "RPM repository for unsupported PostgreSQL releases / distros"

Raghavendra Rao: AFTER LOGON(Oracle) trigger in PostgreSQL with extension – login_hook

25. Dezember 2020 - 20:00
Before going into the details, thanks to the author of ‘login hook’ extension for developing and maintaining it. Many times, in Oracle to Postgres migration exercise, I have seen the use of Oracle Database Event trigger – AFTER LOGON ON. Its one type of Oracle database/user event trigger(LOGON) that fires when a user connects to...

Devrim GÜNDÜZ: LLVM issues with PostgreSQL YUM repository on CentOS 8

25. Dezember 2020 - 12:00
In the latest 3 minor releases of Red Hat Enterprise Linux 8, Red Hat have broken LLVM compatibility with the previous minor releases (like introducing LLVM 8 with RHEL 8.1, LLVM 9 with RHEL 8.2, and LLVM 10 with RHEL 8.3). Continue reading "LLVM issues with PostgreSQL YUM repository on CentOS 8"

Devrim GÜNDÜZ: What is new in PostgreSQL 13 RPMs?

24. Dezember 2020 - 12:50
It has been a while since PostgreSQL 13 has been out, and v13 RPMs have some new features for end users. In this short blog post, I would like to summarize them:

Continue reading "What is new in PostgreSQL 13 RPMs?"

Hubert 'depesz' Lubaczewski: How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1

24. Dezember 2020 - 4:00
Recently I spent some time thinking about what can be improved when it comes to helping new users start using PostgreSQL. One thing that almost immediately jumped to my mind is – how to install PostgreSQL? The task is theoretically simple. But there are always some caveats – which packages to use, what to configure … Continue reading "How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 1"

Pavel Stehule: redirect query result from psql to LibreOffice Calc by using clipboard

23. Dezember 2020 - 7:48
psql as classic TUI application doesn't support clipboard. But it isn't hard to redirect result to clipboard in good format for LibreOffice. First You need an psql from PostgreSQL 13 release. Next you need some clipboard manager application like xclip (XWindows) or pbcopy (MacOS) or wl-clipboard (Wayland). After some testing I found so LibreOffice Calc reads tsv format without problems (for numbers and texts without tabs). It uses identification application/x-libreoffice-tsvc for this format.