Tablesample In PostgreSQL 9.5

PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table.

What’s new in PgBouncer 1.6

The latest release of PgBouncer was announced on 1st of August 2015. In this blog post we’ll talk about the major new improvements of PgBouncer.

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses: the WITHIN GROUP and FILTER clauses.

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

In PostgreSQL 9.5 will be possible to import a complete schema from an external database, using Foreign Data Wrappers and IMPORT FOREIGN SCHEMA command.

Automating Barman with Puppet: it2ndq/barman (part three)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server (part three)

Automating Barman with Puppet: it2ndq/barman (part two)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server (part two)

Automating Barman with Puppet: it2ndq/barman (part one)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server

What’s new about Barman 1.4.0?

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver.

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data!

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out

PostgreSQL 9.4 for administrators (part two)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

PostgreSQL 9.4 for administrators (part one)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

Using Hibernate Query Language (HQL) with PostgreSQL

In my previous blog, I talked about using Java arrays to talk to PostgreSQL arrays. This blog is going to go one step further in using Java against the database. Hibernate is an ORM implementation available to use with PostgreSQL. Here we discuss its query language, HQL. The syntax for HQL is very close to…

A pipeline in the Western Australian goldfields

PostgreSQL-based application performance: latency and hidden delays

If you’re trying to optimise the performance of your PostgreSQL-based application you’re probably focusing on the usual tools: EXPLAIN (BUFFERS, ANALYZE), pg_stat_statements, auto_explain, log_statement_min_duration, etc. Maybe you’re looking into lock contention with log_lock_waits, monitoring your checkpoint performance, etc too. But did you think about network latency? Gamers know about network latency, but did you think…

logo-hires

Barman 1.6.1 is Released

2ndQuadrant is proud to announce the release of Barman version 1.6.1, a Backup and Recovery Manager for PostgreSQL.

Auditing Users and Roles in PostgreSQL

One of the services we offer are security reviews (or audits, if you want), covering a range of areas related to security. It may be a bit surprising, but a topic that often yields the most serious issues is roles and privileges. Perhaps the reason why roles and privileges are a frequent source of issues…

How Postgres-XL is tested

The purpose of this blog is to explain the process of Quality Analysis that Postgres-XL goes through internally at 2ndQuadrant. Here, I describe the bare minimum tests that each release goes through, not to mention the other tests carried out by many 2ndQuadrant and other community members.   Regression tests are carried out to ensure…

Using Java arrays to insert, retrieve, & update PostgreSQL arrays

Arrays are a powerful programming feature frequently used by developers, both in Java and in PL/pgSQL. Interfaces can potentially become tricky, however, when the two try and talk to each other. This section explores how you can write simple code that uses the java.sql.Array Interface to insert, retrieve, & update arrays in PostgreSQL. To illustrate…

PGLogical 1.1 packages for PostgreSQL 9.6beta1

We have made pglogical 1.1 packages available for PostgreSQL 9.6beta1 for both rpm and deb based distributions. They are available for install from our standard pglogical package repository. You may ask why do we release packages for beta version of Postgres? Well, one of the reasons is that you can use pglogical to replicate your…

Postgres-XL 9.5r1.1 released

The Postgres-XL community has released a new version of the software, tagged as 9.5r1.1. This is a minor update to earlier 9.5r1 release, but contains some very important bug fixes. I would encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from ,…

logo-hires

Waiting for Barman 1.6.1

The upcoming version 1.6.1 of Barman will introduce a few interesting new features which consolidate its central role in business continuity installations of PostgreSQL databases. Discover why.

Visual PostgreSQL debugging

Having recently been doing some debugging work where many watchpoints, conditional breakpoints etc were necessary I’d like to shout out to a really useful tool: The standalone CDT debugger. It’s part of the Eclipse project, but before you run screaming – it doesn’t require project setup or anything and it serves as a good GUI…

12345Next ›Last »