The PostgreSQL Developer Meeting went well with attendees from UK, Czechia, US, Russia and Germany. The meeting is in Brussels, near the FOSDEM conference. Andreas Seltenreich was the new face at the meeting. Andreas’ sqlsmith tool has found many PostgreSQL bugs, so we discussed extending that for the latest features in PostgreSQL 11. We discussed […]
PostgreSQL Meltdown Benchmarks
/1 Comment/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraTwo serious security vulnerabilities (code named Meltdown and Spectre) were revealed a couple of weeks ago. Initial tests suggested the performance impact of mitigations (added in the kernel) might be up to ~30% for some workloads, depending on the syscall rate. Those early estimates had to be done quickly, and so were based on limited […]
Dev Corner: error context stack corruption
/4 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL uses error context callbacks to allow code paths to annotate errors with additional information. For example, pl/pgsql uses them to add a CONTEXT message reporting the procedure that was executing at the time of the error. But if you get it wrong when you use one in an extension or a patch to core, […]
PostgreSQL Maximum Table Size
/9 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsVarious limits on the PostgreSQL database are listed here: http://www.postgresql.org/about/ One of those limits is the Maximum Table Size, listed as 32TB. It’s been that way for many years now. Only problem is that it has always been wrong, slightly. And now its got much, much bigger. The table size is limited by the maximum […]
PostgreSQL 11 – Server-side Procedures (Part 2)
/7 Comments/in 2ndQuadrant, Umair's PlanetPostgreSQL /by Umair ShahidTransaction control in PL procedures A couple of months back, I wrote about how we now have the ability to write Stored Procedures in PostgreSQL. This post follows up on that and talks about the next step that was implemented: transaction control in PL procedures. The feature was committed on 22-Jan-2018. With this addition, you […]
Webinar: Data Integration With PostgreSQL [Follow Up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiHaving a unified view when combining data from different sources is essential for every business. Whether you want to connect to a cloud application, import/export data to/from a text file, or sync data between your datasource and a 3rd party platform – having a database platform that provides a seamless and effective data integration process […]
Oracle with OmniDB
/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William IvanskiOmniDB was designed to allow users to manage multiple databases from different RDMBS within an unified workspace. The philosophy is to use the same familiar web interface (same structures, icons, context menu and handy features such as SQL Autocomplete, Create/Edit Table Form and Edit Data) so the user feels comfortable and confident to manage different […]
OmniDB: Monitoring Dashboard
/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William IvanskiOmniDB 2.4.0 introduces a new cool feature called Monitoring Dashboard. We know a picture is worth a thousand words, so please take a look: As you can see, this is a new kind of inner tab showing some charts and grids. This Monitoring inner tab is automatically opened once you expand the tree root node (the PostgreSQL […]
PostgreSQL Developer Meeting Brussels
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsThe PostgreSQL Developer Meeting went well with attendees from UK, Czechia, US, Russia and Germany. The meeting is in Brussels, near the FOSDEM conference. Andreas Seltenreich was the new face at the meeting. Andreas’ sqlsmith tool has found many PostgreSQL bugs, so we discussed extending that for the latest features in PostgreSQL 11. We discussed […]
Using Multimaster and BDR appropriately – LinuxConfAu
/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringerUnless you were in Sydney for linux.conf.au 2018 last week you probably didn’t see my talk Geographically distributed multi-master replication with PostgreSQL and BDR. Luckily for you it’s on archive.org and YouTube. If you’re interested in multi-master replication of any sort, even non-PostgreSQL-based multi-master, it should be worth taking a look. The talk could’ve been […]
Upcoming Enhancements to Partitioning & Indexes in PostgreSQL 11
/8 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsMy colleague Alvaro Herrera has been working on a series of connected features for PostgreSQL 11. It’s worth explaining what these are rather than trying to piece together what is happening from reading commit messages. The overall idea is to allow Partitioned tables to have Referential Integrity, by way of Primary Keys and Foreign Keys, […]