One word in PostgreSQL unlocked a 9x performance improvement

Re:One word in PostgreSQL unlocked a 9x performance improvement by oefrha on Sunday June 14, 2020 @01:57PM (#23519733)

If you never had a formal introduction to SQL, you can probably get a lot of value from a run-of-the-mill SQL textbook by scanning the table of contents and skimming the chapters/sections on topics new to you. (For the record, I learned SQL myself through fumbling. My first schema designs didn’t even have relations.)

The problem with this blog post isn’t lack of novelty; rather, with the clickbait title, it piqued my interest but I ended up learning nothing, other than being reminded of my own terrible designs and queries back when I was a noob.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by badrequest on Sunday June 14, 2020 @03:28PM (#23520579)

All that is well and good, but RETURNING is a Postgres feature, not part of the SQL standard. I don't think a standard SQL textbook (especially one targeting something like MySQL/Sqlite) would have taught the author about it.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by fabian2k on Sunday June 14, 2020 @03:34PM (#23520621)

I was quite surprised when I found out that RETURNING is actually a Postgres feature, and not standard. It just felt like such an obvious and extremely useful thing to have.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by AdrianB1 on Sunday June 14, 2020 @04:11PM (#23520900)

RETURNING exists also in Oracle PL/SQL and it is called OUTPUT in T-SQL. It may exist in other SQL variants.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by branko_d on Sunday June 14, 2020 @08:29PM (#23522685)

> My first schema designs didn’t even have relations.

I'm pretty sure your first schema designs had relations (tables). I can't speak for relationSHIPS (foreign keys) though...

;)

[ Parent | on HN ]