Version 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of multi-master replication into core PostgreSQL. In this two-part article we will show you the main new features for administrators; we begin with […]
BDR for PostgreSQL: Present and future
/11 Comments/in Craig's PlanetPostgreSQL /by craig.ringerFor a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become known as the BDR project. We’re really excited to see these efforts leading to new PostgreSQL features and have a great deal more still to […]
PostgreSQL 9.4 for administrators (part two)
/0 Comments/in Francesco's PlanetPostgreSQL /by 2ndQuadrant PressWritten by Francesco Canovai In the previous instalment, we introduced the logical replication feature which has been added to PostgreSQL 9.4. Let’s go on exploring the multitude of new features that version 9.4 brings to the Operation field, easing the management of PostgreSQL databases for system and database administrators. pg_prewarm pg_prewarm is a new extension to […]
Progress on online upgrade
/4 Comments/in Petr's PlanetPostgreSQL, PostgreSQL /by Petr JelinekIn last couple of months I’ve been working on online upgrade for very large databases as part of the AXLE project and I would like to share my thoughts on the topic and what progress we have made recently. Before joining 2ndQuadrant I used to work in Skype where the business would not allow a […]
All-processes breakpoints / watchpoints for PostgreSQL
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerSometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s being changed by some unknown backend at some unknown time. Or a function that’s called from somewhere, but you don’t know where or when. I’ve recently been doing quite a bit of work on code where bgworkers launch […]
Italian PGDay, eighth edition: over 120 attendees!
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniNovember 7th 2014 was the eighth Italian PostgreSQL Day, the national event dedicated to the promotion of the world’s most advanced open source database. The Italian edition is one of the most enduring in the whole Postgres community (the first one took place in July 2007) and the results of the activity of a very […]
PostgreSQL 9.4 for administrators (part one)
/1 Comment/in Francesco's PlanetPostgreSQL /by 2ndQuadrant PressVersion 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of multi-master replication into core PostgreSQL. In this two-part article we will show you the main new features for administrators; we begin with […]
… and now for something completely different!
/0 Comments/in Josette's PlanetPostgreSQL /by 2ndQuadrant PressUp until now, reading this blog has kept you up-to-date with the latest developments in PostgreSQL. This time I would like to invite you to meet the team of 2ndQuadrant at the PostgreSQL Conference Europe 2014 which took place in Madrid on October 21st-24th. As you know, 2ndQuadrant offers 7 days a week, 24 hours […]
Ware Yosemite? Possible PostgreSQL upgrade issues in OS X 10.10
/10 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI’m seeing reports of a number of issues with PostgreSQL after upgrades of OS X machines to Yosemite (OS X 10.10) that I’m concerned about, so I’m seeking more information about the experiences of PostgreSQL users who’ve done OS X 10.10 upgrades. I can’t confirm anything yet, but back up all your databases before any […]
Index Overhead on a Growing Table
/0 Comments/in Mark's PlanetPostgreSQL /by Mark WongThis another simple test in continuation from last time. We will start with the same lineitem table as in the previous example. We will measure the time it takes to load the same 7.2GB text file repeatedly until the table size grows to about 1TB. We create a baseline with a table that has no indexes built on […]
Loading Tables and Creating B-tree and Block Range Indexes
/2 Comments/in Mark's PlanetPostgreSQL /by Mark WongI have been looking at the new Block Range Indexes (BRIN) being developed for PostgreSQL 9.5. BRIN indexes are designed to provide similar benefits to partitioning, especially for large tables, just without the need to declare partitions. That sounds pretty good but let’s look in greater detail to see if it lives up to the hype. How large? Here’s […]