Sharding or horizontal scalability is a popular topic, discussed widely on PostgreSQL mailing lists these days. When we started the Postgres-XC project back in 2010, not everyone was convinced that we need a multi-node PostgreSQL cluster that scales with increasing demand. Even more likely, we, the PostgreSQL community, were skeptical about whether we have enough […]
Parallel Aggregate – Getting the most out of your CPUs
/10 Comments/in David's PlanetPostgreSQL /by David RowleyA small peek into the future of what should be arriving for PostgreSQL 9.6. Today PostgreSQL took a big step ahead in the data warehouse world and we now are able to perform aggregation in parallel using multiple worker processes! This is great news for those of you who are running large aggregate queries over […]
Tables and indexes vs. HDD and SSD
/3 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraAlthough in the future most database servers (particularly those handling OLTP-like workloads) will use a flash-based storage, we’re not there yet – flash storage is still considerably more expensive than traditional hard drives, and so many systems use a mix of SSD and HDD drives. That however means we need to decide how to split […]
Sharding: Bringing back Postgres-XL technology into core PostgreSQL
/4 Comments/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeSharding or horizontal scalability is a popular topic, discussed widely on PostgreSQL mailing lists these days. When we started the Postgres-XC project back in 2010, not everyone was convinced that we need a multi-node PostgreSQL cluster that scales with increasing demand. Even more likely, we, the PostgreSQL community, were skeptical about whether we have enough […]
And Barman 1.6.0 is out!
/2 Comments/in Featured, Rubens' PlanetPostgreSQL /by Rubens SouzaGood news has come out to ensure your disaster recovery strategy is even better! Wait…what?! You don’t have a disaster recovery strategy?! No good, my friend, no good…
BRIN for PostGIS: my story at the Code Sprint 2016 in Paris
/0 Comments/in Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressLast week I was pleased to attend Code Sprint 2016 in Paris, organised by the OSGeo Foundation: it has been an opportunity for many GIS users from all over the world to get together, discuss and actively work on many open tasks of some of the major open source frameworks on GIS. PostGIS was obviously […]
Extended the call for papers for “5432…MeetUs!”
/0 Comments/in International News /by Gabriele BartoliniYou now have time until March 14th, 2016 to submit your talk to “5432…MeetUs!”, the conference organised by 2ndQuadrant that will take place in Milan next June 28th and 29th. Further information on the call for papers can be found on the conference website.
Announcing Barman 1.6.0
/0 Comments/in Barman, International News /by Marco NenciariniVersion 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.
Are we ready for Nordic PGDay?
/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimThe 3rd annual Nordic PGDay will be held on 17th of March in Helsinki this year. Registration is still open, reserve yourselves a seat before it’s too late!
FLOSS UK Spring Conference
/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL, United Kingdom News /by Gulcin YildirimFloss UK Spring conference will be held on 15th-17th of March in London.
Managing a PostgreSQL Commitfest
/1 Comment/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraIf you’ve been following PostgreSQL development for the last few years, you’ve probably heard the term commitfest manager a few times. You probably already know what a commitfest is, but why is there a manager? Since I spent a good deal of time this past January managing one, I’ll explain. At its heart, a PostgreSQL […]