opendbteam workspace

opendbteam workspace
opendbteam workspace

Friday, December 18, 2015

#PostgreSQL #9.5 is almost there

The PostgreSQL 9.5 Release Candidate 1 is here. This is the final step before the final version is out in early January. More information on the release page: PostgreSQL 9.5 RC1 Released

Tuesday, December 15, 2015

Quite the #Critical and #In-depth #Analysis of between #PostgreSQL and #MongoDB

Relational structures and NoSQL structures differ vastly, as demonstrated by this article from John de Goes.


Don't get us wrong, PostgreSQL is still a wonderful relational database engine but can it really fulfil the demands that rich data require?


Judge for yourself...
MongoDB 3.2: Now Powered by PostgreSQL

Thursday, November 26, 2015

Little #reminder on #pg_stat_activity

Ever wondered who was connected to your database? What the PID of the connection you want to terminate is? Well search no more and read the nicely packaged reminder on the pg_stat_activity from Alexey Lesovsky: Introduction to pg_stat_activity

Tuesday, November 10, 2015

A little refresher and #BestPractice before switching to #PostgreSQL

It seems to be obvious to follow these steps when switching to PostgreSQL but these mistakes are often made, leading to crisis and often very expensive support procedures. As such let's delve into this nicely crafted reminder from Enterprisedb: Top 10 Steps to a Smoother Postgres Deployment

Thursday, November 5, 2015

Understanding #PostgreSQL: #replication_slots and #pg_basebackup

Since version 9.4, a lot of things have changed: new options, new default values, new workarounds. In this article Denish Patel takes a look at replication_slots and pg_basebackup which does not yet support it (don't worry, it has been committed to 9.6). More details @ POSTGRES REPLICATION SLOT & PG_BASEBACKUP

Tuesday, October 27, 2015

Hurray! New behaviour for #pg_ctl start with #PostgreSQL #9.5

Gone are the days of weird errors and exit codes given by pg_ctl start as a new commit has been pushed for the newt minor versions to be realeased! More information in the article posted by Michael Paquier at: Reliability improvements for pg_ctl start

Monday, October 19, 2015

EDB #postgresql Positioned in the Leaders Quadrant in Gartner's Magic Quadrant for RDBMS

The 2015 Gartner Magic Quadrant for Operational Database Management Systems is now available and reflects several important trends and interesting market changes.
One of the most significant changes is the continued movement of open source databases, like EDB Postgres, into the Leaders quadrant alongside giant proprietary vendors like Oracle, Microsoft and IBM.
In fact, Gartner reports that by 2018, 70% of all new applications and 50% of all existing applications will be moved to open source relational databases like EDB Postgres. 

Further, Gartner reports the performance of opens source is now at parity with commercial options but with dramatic total cost of ownership advantages.

http://www.opendbteam.com is a partner of EDB. Please contact us for more information.










Thursday, October 8, 2015

#PostgreSQL #9.5 in Beta version 1!

PostgreSQL 9.5 has arrived. Many bugs were corrected during the rather long Alpha 2 period. Check them out at: PostgreSQL 9.5 Beta 1 release annoucement The final release of PostgreSQL 9.5 is set for late 2015. In the meantime, a few security updates have been released for the existing versions of PostgreSQL which you can check at: PostgreSQL security release annoucement

Tuesday, September 29, 2015

Monday, September 14, 2015

A little reminder of why #statistics matter, and how to #tune your #PostgreSQL instance.

Thomas Vondra writes a good recap of why statistics matter in tuning a PostgreSQL instance: "That however does not mean there are no issues with data distribution (planner) statistics, and as that's one of my areas of interest, in this post I'll discuss the usual issues with data distribution statistics, usually observed by the user as slow (or even failing) queries. And I'll also mention what are the possible remedies available (if any)." Common issues with planner statistics

Wednesday, August 5, 2015

#postgresql #replication training session PGDBA3 planned (french session) @ Brussels !

Our next training session PGDBA3 (PostgreSQL replication) is planned from 8 September 2015 till 9 September 2015 (9.00 am - 5.30 pm). This session will be in French.

Interested ?
http://www.opendbteam.com/home/training/postgresql-training-session-pgdba3/

Place: OPENDBTEAM Brussels, Rue des Pères Blancs 4, 1040 Etterbeek.

Tuesday, August 4, 2015

#job #postgresql #opensource Job offer: IT guy who loves Open Source and Databases

We are looking for people who are passionate about the Open Source world and values, particularly in the field of databases (PostgreSQL, MongoDB, Hadoop, ...)
with either a degree in ICT (whatever the field) or equivalent experience.

We offer the possibility and time to learn about new technologies on the job (FPI contracts are a possibility).

Language skills: French mandatory, English and Dutch will be considered a plus.

Knowledge of the following will be considered a plus:
- Linux/FreeBSD administration
- Bash Scripting
- ICT Security
- Networks (firewalls, TCP/IP)
- Programming languages such as Python and PERL
- Any Open Source Database type

Offices: Brussels (1040, Etterbeek), ICAB incubator, rue des Pères Blancs.

Possibility of working from home a few days a week.

If you would like to work in a fast-paced, challenging and everchanging environment, send us your CV in PDF format at admin@opendbteam.com

Meeting with Jeremy Allison (Storage & Open Source Engineer at #Google Moutain View)


Thank you Jeremy for our meeting @ the Google Campus ! Amazing day, very interesting chat about Open Source, entrepreneurship and of course... Open Source Databases !

#job #postgresql #opensource Offre d'emploi informatitien passionné par l'Open Source

Nous sommes à la recherche de plusieurs passionnés dans le domaine de l'Open Source et plus particulièrement dans le domaine des bases de données (PostgreSQL, MongoDB, Hadoop, ...).

avec un diplome en informatique (peu importe la spécialisation) ou expérience équivalente.

Nous donnons la possibilité et le temps à chacun de se former aux nouvelles technologies.

La connaissance du Français est obligatoire. L'anglais et le néérlandais est un plus.

Les connaissances suivantes sont un point positif à votre demande:
- L'administration système Linux / FreeBSD
- Le scripting bash
- La sécurité IT
- Réseau (firewall, TCP/IP)
- La connaissance de langage comme le Python et le PERL
- Tous les types de base de données Open Source.

Siège d'exploitation: Bruxelles (Etterbeek), à l'incubateur ICAB, rue des Pères Blancs.

Télétravail possible quelques jours par semaine.

Envie de nous rejoindre et d'avoir un job intéressant, non routinier, varié ?
Prêt à relever de nouveau défis chaque jour ?

Envoyez-nous vos CV au format PDF à l'adresse admin@opendbteam.com


Tuesday, July 28, 2015

New #PostgreSQL 9.5 #archiving feature to come

For those of you who would like to perpetually archive, good news: it might just be possible with a new parameter.

#PostgreSQL #9.5 Alpha 1 released

The future new version is right on track, with previews of all features, such as:
Block-Range Indexes (BRIN) which enable compact indexing of very large tables
Large speed improvements in in-memory sorting and hashing
Automated management of transaction log size
INSERT ON CONFLICT UPDATE, otherwise known as “UPSERT”
Grouping Sets, CUBE and ROLLUP analytic operations
Row-Level Security (RLS) support
More JSONB data manipulation functions and operators
Added the pg_rewind tool and other high availability improvements to replication
Multiple enhancements to Foreign Data Wrappers, including IMPORT FOREIGN SCHEMA
Large increases in multi-core and large memory scalability
Beta version to be released in August.

Wednesday, June 10, 2015

But why learn #PostgreSQL?

Sometimes it is good to remember why we learn to use PostgreSQL:
Why learn at all? What can PostgreSQL do for me? Why PostgreSQL and not another DBMS engine?
A few answers here, in this nice piece by Harald Armin Massa.
“Why should you learn PostgreSQL?” @

Monday, June 8, 2015

Things to look forward to in #PostgreSQL #9.5 #Replication

Who said WAL archiving cannot be improved?
PostgreSQL committed a suffix improvement for archiving WALS. Archiving of the last segment on timeline after promotion will become much safer.

Wednesday, April 1, 2015

The beautiful possibilities of #Quantum computing #pg_rewind



Interesting article on pg_rewind from Andrea Scherbaum

“Someone in the audience asked, if it’s possible to roll a PostgreSQL database forward, ahead of the master. The answer was that currently it’s not possible, but there is no technical reason why this should not work. So I decided to have a look. Turns out, it’s surprisingly easy to do…”

More details @http://andreas.scherbaum.la/blog/archives/893-Reversing-pg_rewind-into-the-future.html#extended