Sammlung von Newsfeeds
#create named pipe
[pavel@nemesis ~]$ psql
Type "help" for help.
postgres=# \o ~/pokus
postgres=# select * from obce limit 10;
postgres=# --redirect content to pipe
Depending on your workload, the planning time can represent a significant part of the overal query procesing time. This is especially import in OLTP workload, but OLAP queries with numerous tables being joined and an aggressive configuration on the JOIN order search can also lead to hight planning time.
CREATE OR REPLACE FUNCTION public.buffer_dif(text, bigint)
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Allow pg_stat_statements to track planning statistics.
For a better experience of results, switch to desktop mode on your mobile browser [may take a second or two to load the results]
In this survey, I just wanted to understand how people are using PostgreSQL and wanted to give the information to the community
Given the recent Covid-19 outbreak, PGDG (PostgreSQL Global Devrim Group) recently announced a few updates to the project: Continue reading "Updates from the PostgreSQL project"
Recently I was talking in a more general way about some common auditing / change tracking approaches for PostgreSQL…but it also made me curious, how it roughly looks from the performance side?
The World has been taken by storm by the COVID-19. Our thoughts are with the people who, for any reason, are suffering from this. We are with you.
Example: I can write own isnull function:
CREATE OR REPLACE FUNCTION isnull(anyelement, anyelement)
RETURNS anyelement AS $$
SELECT coalesce($1, $2)
$$ LANGUAGE sql;
postgres=# SELECT public.isnull(NULL, 1);
│ isnull │
│ 1 │
postgres=# SELECT public.isnull(NULL, CURRENT_DATE);
│ isnull │
PostgreSQL has a rich set of indexing functionality, and there are many articles explaining the syntax, usage, and value of the index. In this article, I will write basic and useful queries to see the state of database indexes. People develop databases and after some time, when there is a demand to do changes in the architecture of software, they forget to do the previous indexes’ cleanup. This approach creates a mess and sometimes slows down the database because of too many indexes.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Enable BEFORE row-level triggers for partitioned tables
David Z: PostgreSQL GSSAPI Authentication with Kerberos part-3: the status of authentication, encryption and user principal
In previous two blogs, we explained how to setup Kerberos, and how to configure PostgreSQL to support GSSAPI user authentication. This blog will be focusing on how to check GSSAPI authentication, encryption and user principal information when given different connection options.
This is the second part of the topic, the more historical version is described in the previous part, and here is the vitality of wal in PostgreSQL which born replication、logical replication and more performance related configure, let’s continue to redo it.1. Replication(V9.0)
Replication is implemented here, and many corresponding GUC are added for replication. Corresponding to warm standby, replication can also be called hot standby, which helps to achieve the data synchronization using WAL record between the primary and the standby.
WAL is one of the most important parts of PostgreSQL., WAL records all the database activity. Hense we can regard wal as a change roadmap of the history of PostgreSQL database, and the crash recovery, logical replication etc aren’t possible without WAL. The following picture describes the various wal related GUC (based on PG12) involved in the production and use of wal logs. It is very important for us to know the meaning of each parameter to optimize database performance and configure high availability cluster..