Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

An early look at Postgres 14: Performance and monitoring Improvements

pganalyze.com

Post reply on HN
Print view View original

11–20 of 254 posts

Re: An early look at Postgres 14: Performance and monitoring Improvements

#11

Post by ComputerGuru »

wiradikusuma wrote: post #3

I'm thinking of using Postgres for a project, but a DBA friend told me operationally it's more challenging than MySQL. Unfortunately, he can't elaborate. Does anyone have real work experience? Or is it based on outdated "PG must manually vacuum frequently"?

One thing is that Postgres doesn’t let you just upgrade to a new major version, as it doesn’t update the format of the on-disk binary database files; you must replicate from an existing node or dump/restore. MySQL upgrades the previous version when a new version is installed (which can cause problems, but is certainly “easier”).

Re: An early look at Postgres 14: Performance and monitoring Improvements

#12

Post by paozac »

jjeaff wrote: post #7
matthewbauer wrote: post #5

Postgres is one of those pieces of software that’s so much better than anything else, it’s really incredible. I wonder if it’s even possible for competitors to catch up at this point - there’s not a lot of room for improvement in architecture of relational databases any more. I’m starting to think that Postgres is going to be with us for decades maybe even centuries. Do any other entrenched software projects come to…

MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.

MySQL's lack of DDL transactions is a serious shortcoming.

Re: An early look at Postgres 14: Performance and monitoring Improvements

#13

Post by Supermancho »

yakubin wrote: post #10
matthewbauer wrote: post #5

Postgres is one of those pieces of software that’s so much better than anything else, it’s really incredible. I wonder if it’s even possible for competitors to catch up at this point - there’s not a lot of room for improvement in architecture of relational databases any more. I’m starting to think that Postgres is going to be with us for decades maybe even centuries. Do any other entrenched software projects come to…

Fortran for linear algebra software. Excel for business spreadsheets. Java for enterprise server software.

> Java for enterprise server software.

Big corporations are horribly inefficient and Enterprise Software necessarily so from that...if you're saying Java is terrible by nature of it being the goto for enterprise, then that makes sense. It took 20 years for it to swap places with COBOL and I expect it will be something else in 20 more.

Re: An early look at Postgres 14: Performance and monitoring Improvements

#14

Post by ezekiel68 »

jjeaff wrote: post #7
matthewbauer wrote: post #5

Postgres is one of those pieces of software that’s so much better than anything else, it’s really incredible. I wonder if it’s even possible for competitors to catch up at this point - there’s not a lot of room for improvement in architecture of relational databases any more. I’m starting to think that Postgres is going to be with us for decades maybe even centuries. Do any other entrenched software projects come to…

MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.

You claim that MySQL 8 is ahead when it comes to scalability. What are the bases of this claim? When I see comparisons or entire systems that rely on a database (that is, not micro-benchmarks) such as the TechEmpower web framework benchmarks [0] , I notice that the 'Pg' results cluster near the top, with the "My" results showing up further down the rankings. I understand this isn't version 14 of the former versus version 8 of the latter. But it makes me wonder what the basis of your claims is.

[0] https://www.techempower.com/benchmarks/

Re: An early look at Postgres 14: Performance and monitoring Improvements

#16

Post by purerandomness »

jjeaff wrote: post #7
matthewbauer wrote: post #5

Postgres is one of those pieces of software that’s so much better than anything else, it’s really incredible. I wonder if it’s even possible for competitors to catch up at this point - there’s not a lot of room for improvement in architecture of relational databases any more. I’m starting to think that Postgres is going to be with us for decades maybe even centuries. Do any other entrenched software projects come to…

MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.

No DDL transactions, no materialized views, the list is endless.

There's almost no reason to pick MySQL for a new project.

Re: An early look at Postgres 14: Performance and monitoring Improvements

#17

Post by gigatexal »

From the article:

And 200+ other improvements in the Postgres 14 release!

These are just some of the many improvements in the new Postgres release. You can find more on what's new in the release notes, such as:

    The new predefined roles pg_read_all_data/pg_write_all_data give global read or write access
    Automatic cancellation of long-running queries if the client disconnects
    Vacuum now skips index vacuuming when the number of removable index entries is insignificant
    Per-index information is now included in autovacuum logging output
    Partitions can now be detached in a non-blocking manner with ALTER TABLE ... DETACH PARTITION ... CONCURRENTLY
the killing of queries when the client disconnects is really nice imo -- the others are great too

Re: An early look at Postgres 14: Performance and monitoring Improvements

#18

Post by nerdbaggy »

Waterluvian wrote: post #15

Tangential to this topic: If I have a Django + PG query that takes 1 second and I want to deeply inspect the breakdown of that entire second, where might I begin reading to learn what tools to use and how?

Django has built in explain support which can guide you on the right track https://docs.djangoproject.com/en/3.2/ref/models/querysets/#...

Re: An early look at Postgres 14: Performance and monitoring Improvements

#19

Post by etxm »

Waterluvian wrote: post #15

Tangential to this topic: If I have a Django + PG query that takes 1 second and I want to deeply inspect the breakdown of that entire second, where might I begin reading to learn what tools to use and how?

I’d start w ‘EXPLAIN query’, if you arent familiar with the output there, you can put it on PEV and get a visualization.

https://tatiyants.com/pev/#/plans

Re: An early look at Postgres 14: Performance and monitoring Improvements

#20

Post by isbvhodnvemrwvn »

ezekiel68 wrote: post #14
jjeaff wrote: post #7

Earlier quoted context omitted.

MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.

You claim that MySQL 8 is ahead when it comes to scalability. What are the bases of this claim? When I see comparisons or entire systems that rely on a database (that is, not micro-benchmarks) such as the TechEmpower web framework benchmarks [0] , I notice that the 'Pg' results cluster near the top, with the "My" results showing up further down the rankings. I understand this isn't version 14 of the former versus ver…

Aren't those run on a single node DB server? And the queries don't really seem realistic at all, e.g. single query test fetches 1 out of 10 000 rows, with no joins at all. Fortunes fetches 1 out of 10 rows. This seems extremely trivial.
Post reply on HN