BE SHARING

postgres

PGIO, PG_STAT_ACTIVITY and PG_STAT_STATEMENTS

28.06.2018 by Oracle Team

By Franck Pachot . For an Oracle DBA, we are used to join active sessions (from V$SESSION where status='ACTIVE) with active statements (from V$SQL where users_executing>0) on the SQL_ID. V$ACTIVE_SESSION_HISTORY also displays the TOP_LEVEL_SQL_ID to get the entrypoint of the(…)

Database Administration & Monitoring

Lighty for PostgreSQL

27.06.2018 by Oracle Team

By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)

Database Administration & Monitoring

PostgreSQL – logical replication with pglogical

23.03.2018 by Joël Cattin

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called(…)

Oracle

Full page logging in Postgres and Oracle

14.02.2018 by Oracle Team

By Franck Pachot . In my opinion, the volume of logging (aka redo log, aka xlog, aka WAL) is the most important factor for OLTP performance, availability and scalability, for several reasons: This is the only structure where disk latency(…)

Oracle

Server process name in Postgres and Oracle

09.02.2018 by Oracle Team

By Franck Pachot . Every database analysis should start with system load analysis. If the host is in CPU starvation, then looking at other statistics can be pointless. With ‘top’ on Linux, or equivalent such as process explorer on(…)

Oracle

Dbvisit replicate – SQL Developer chart

31.10.2017 by Oracle Team

By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours(…)

Oracle

Postgres vs. Oracle access paths II – Index Only Scan

02.08.2017 by Oracle Team

By Franck Pachot . In the previous post I've explained a sequential scan by accident: my query needed only one column which was indexed, and I expected to read the index rather than the table. And(…)

PostgreSQL

Postgres unique constraint

01.08.2017 by Oracle Team

By Franck Pachot . I'll start a series on Postgres vs. Oracle access paths because I know Oracle and I learn Postgres. While preparing it, I came upon some surprises because I'm so used to Oracle(…)

PostgreSQL

PostgreSQL on Cygwin

01.08.2017 by Oracle Team

By Franck Pachot . I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install(…)

Database Administration & Monitoring

PostgreSQL 10 Beta 1 : pg_hba_file_rules view

30.06.2017 by Joël Cattin

This short blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll(…)