# RootPrompt.org   Nothing but Unix.[Home] [Features] [Programming] [Mac OS X] [Search]

 Analyzing PostgreSQL SQL usage

Everyone wants their database-backed web application to run faster on the same hardware - if a software tweak can postpone a hardware upgrade for a year, it's usually well worth it. One way to improve performance is to examine how the application is interacting with the database, and see if there is anything that we can do to speed things up. We will take a look at a handy script that can examine PostgreSQL logs and let you know what queries are getting run the most. Story.

 (Submitted by tcopeland Tue Apr 6, 2004 )


Our content can be syndicated: Main page Mac Page

Copyright 1999-2005 Noel Davis. Noel also runs web sites about sailing and kayaking.
All trademarks are the property of their owners.
All articles are owned by their author