Hacker News new | past | comments | ask | show | jobs | submit login
Plprofiler – A Handy Tool for Profiling PL/pgSQL Code (percona.com)
19 points by avivallssa on Feb 24, 2019 | hide | past | favorite | 6 comments



Original article title is "plprofiler – Getting a Handy Tool for Profiling Your PL/pgSQL Code." What is the implication behind the title used here, "If you still write stored procedures in a Database, you may need a profiler"?


We reverted the title. Submitted title was "If you still write stored procedures in a Database, you may need a profiler", which broke the site guidelines.

Submitters: accounts that editorialize titles eventually lose submission privileges, so please remember that the guidelines ask you to "use the original title, unless it is misleading or linkbait; don't editorialize".

https://news.ycombinator.com/newsguidelines.html


Maybe they are of the opinion that stored procedures are anachronistic and rarely used anymore?


> Essentially all applications that are performance-sensitive use a stored-procedure interface to run application logic inside the DBMS and avoid the crippling overhead of back-and-forth communication between the application and the DBMS.

—Micheal Stonebreaker [1]

[1]: https://courses.cs.washington.edu/courses/csep544/10au/resou...


Also stored procedures are convenient for complex data processing, SQL is much more expressive and efficient for selecting, grouping, joining than something like java.


A misguided attempt to play off the “You might be a redneck” joke pattern popularized years ago by Jeff Foxworthy?




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: