postgres tuning – fixing a production problem

Main menu:

Topics

Recent Posts

Feeds

RSS Feed RSS - Posts

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Past Posts

Java/Java EE

JDBC

Other

Archive for the tag "Database"

postgres tuning – fixing a production problem

December 22nd, 2012 by Jeanne Boyarsky

After a new feature was implemented (not by me), coderanch started crashing almost every day in the middle of the night.  In a few days, I’ll be blogging about the troubleshooting process and how timezones helped.  This post focuses on the end game – once we knew the problem was being caused by a large […]

more postgres tuning in jforum

October 21st, 2012 by Jeanne Boyarsky

A teammate installed a new feature on CodeRanch JForum that uses a 4,515,409 row table. When dealing with over a million rows, scans become a huge performance drain. To the point where one query was slow but real usages with many at the same time brought down the app. The reason why the query was […]

Where’s your database’s ER Diagram?

June 4th, 2012 by Scott Selikoff

I was recently training a new software developer, explaining the joys of three-tier architecture and the importance of the proper black-box encapsulation, when the subject switched to database design and ER diagrams. For those unfamiliar with the subject, entity-relationship diagrams, or ER diagrams for short, are a visual technique for modelling entities, aka tables in […]