upgrading from postgres 8.3 to 8.4

Main menu:

Topics

Recent Posts

Feeds

RSS Feed RSS - Posts

February 2019
M T W T F S S
« Jan    
 123
45678910
11121314151617
18192021222324
25262728  

Past Posts

Java/Java EE

JDBC

Other

Archive for category Database

upgrading from postgres 8.3 to 8.4

February 23rd, 2014 by Jeanne Boyarsky

I upgraded my postgres today.  (Yes, I know it is an old version – that is what the CodeRanch forums use.)  First I reviewed what I did to install 8.3 originally and how frustrating that was.  Upgrading went smoother.  Here’s what I did: Download the Mac Postgres 8.4 graphical installer. Install it. Create my 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 […]