Studying Stored Procs in Postgres 11 With Postgres 11 looming on the near horizon, it’s only appropriate to check out a recent beta and kick the tires a few times. Whether it’s improvements in parallelism, partitions, stored procedures, JIT functionality, or any number of elements in the release page, there’s a lot to investigate. It […]
Sequential UUID Generators
/26 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas VondraUUIDs are a popular identifier data type – they are unpredictable, and/or globally unique (or at least very unlikely to collide) and quite easy to generate. Traditional primary keys based on sequences won’t give you any of that, which makes them unsuitable for public identifiers, and UUIDs solve that pretty naturally. But there are disadvantages […]
PostgreSQL Buildfarm Client Release 9
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanAnnouncing Release 9 of the PostgreSQL Buildfarm client. Along with numerous fixes of minor bugs and a couple of not so minor bugs, this release has the following features: new command line parameter –run-parallel for run_branches.pl runs all branches in parallel, possibly across animals as well new config setting max_load_avg inhibits a run if the […]
OmniDB debugger for PostgreSQL 11
/1 Comment/in OmniDB, William's PlanetPostgreSQL /by William IvanskiPostgreSQL 11 was released recently, with exciting new features. One of them is the ability to write SQL procedures that can perform full transaction management, enabling developers to create more advanced server-side applications. SQL procedures can be created using the CREATE PROCEDURE command and executed using the CALL command. Since OmniDB 2.3.0 it is possible […]
Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]
/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL /by Liaqat AndrabiPostgreSQL is referred to as “The world’s most advanced open source database” – but what does PostgreSQL have that other open source relational databases don’t? 2ndQuadrant recently hosted a webinar on this very topic: PostgreSQL is NOT your traditional SQL database, presented by Gülçin Yıldırım Jelínek, Cloud Services Manager at 2ndQuadrant. The recording of […]
PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11
/0 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David RowleyDuring the PostgreSQL 11 development cycle an impressive amount of work was done to improve table partitioning. Table partitioning is a feature that has existed in PostgreSQL for quite a long time, but it really wasn’t until version 10 that it started to become a highly useful feature. We’d previously claimed that table inheritance was […]
Adding new table columns with default values in PostgreSQL 11
/3 Comments/in 2ndQuadrant, Andrew's PlanetPostgreSQL /by Andrew DunstanIn PostgreSQL version 10 or less, if you add a new column to a table without specifying a default value then no change is made to the actual values stored. Any existing row will just fill in a NULL for that column. But if you specify a default value, the entire table gets rewritten with […]
PGDay Down Under 2018
/0 Comments/in 2ndQuadrant, Andrea's Planet PostgreSQL /by Andrea CuccinielloAfter the success of last year’s event, the second PGDay held in Australia, we’re back this year with PGDay Down Under. The name “Down Under” refers to Australia and New Zealand, due to the fact these countries are located in the lower latitudes of the southern hemisphere. The conference is a one-day community event organized by […]
PG Phriday: Studying Stored Procedures in Postgres 11
/6 Comments/in 2ndQuadrant, Shaun's PlanetPostgreSQL /by Shaun ThomasStudying Stored Procs in Postgres 11 With Postgres 11 looming on the near horizon, it’s only appropriate to check out a recent beta and kick the tires a few times. Whether it’s improvements in parallelism, partitions, stored procedures, JIT functionality, or any number of elements in the release page, there’s a lot to investigate. It […]
Managing Freezing in PostgreSQL
/6 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew DunstanPostgres contains a moving event horizon, which is in effect about 2 billion transactions ahead of or behind the current transaction id. Transactions up to 2 billion ahead of or more than 2 billion behind the current transaction id are considered to be in the future, and will thus be invisible to current transactions. Postgres […]
[Video] Introduction to JSON data types in PostgreSQL
/0 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew DunstanThe video of my presentation below walks you through the major features of the native JSON data type in PostgreSQL 9.3 and beyond. This presentation covers the following topics: What is JSON? How is it available in PostgreSQL? What’s the difference between JSON and JSONB? Accessing JSON values Creating JSON from table data Creating table […]