LWN: Comments on "PostgreSQL 9.6 Beta and PGCon 2016"

PostgreSQL 9.6 Beta and PGCon 2016

Cyberax — Thu, 09 Jun 2016 07:57:54 +0000

Proprietary but cheap enough not to care about it.

PostgreSQL 9.6 Beta and PGCon 2016

oldtomas — Thu, 09 Jun 2016 07:56:29 +0000

What is the license?

PostgreSQL 9.6 Beta and PGCon 2016

Cyberax — Fri, 03 Jun 2016 07:38:57 +0000

I recommend https://www.jetbrains.com/datagrip/?fromMenu - they support PostgreSQL and do intelligent code completion. It's already better than PgAdmin for most of the tasks.

PostgreSQL 9.6 Beta and PGCon 2016

pabs — Fri, 03 Jun 2016 07:37:51 +0000

...

A small runtime application allows it to be run as a desktop application - this is a Qt executable that incorporates a Python interpreter and web browser along with the main application in a single package that can be installed on a developer laptop as with previous versions of pgAdmin.

PostgreSQL 9.6 Beta and PGCon 2016

pabs — Fri, 03 Jun 2016 07:29:59 +0000

Not if the replacement is another web based tool :(

PostgreSQL 9.6 Beta and PGCon 2016

jberkus — Fri, 03 Jun 2016 03:25:10 +0000

Sorry it wasn't clear. That specifically refers to a 110% improvement in *throughput*, that is, transactions per second. Specifically, a workload which did 150,000 transactions per second with 128 concurrent clients was able to do over 300,000 transactions per second using 9.6.

PostgreSQL 9.6 Beta and PGCon 2016

smurf — Fri, 03 Jun 2016 03:19:34 +0000

What does "110% improvement" mean? As I understand English, 50% improvement would be half the time, so 110% would return the result before the query was even issued. As thiotimoline hasn't been invented yet, this is not feasible.

PostgreSQL 9.6 Beta and PGCon 2016

flussence — Thu, 02 Jun 2016 23:59:27 +0000

pgAdmin no longer needs wxWidgets! That's the best database-related news I've heard in a long while.