performance

This tag is associated with 4 posts

Column And Table Redefinition With Minimal Locking

Posted by Jeremy ⋅ November 8, 2018 ⋅ 1 Comment

TLDR: Note to future self… (1) Read this before you modify a table on a live PostgreSQL database. If you do it wrong then your app might totally hang. There is a right way to do it which avoids that. (2) Especially remember the lock_timeout step. Many blog posts around the ‘net are missing this … Continue reading →

This Week in PostgreSQL – May 31

Posted by Jeremy ⋅ June 4, 2018 ⋅ Leave a comment

Since last October I’ve been periodically writing up summaries of interesting content I see on the internet related to PostgreSQL (generally blog posts). My original motivation was just to learn more about PostgreSQL – but I’ve started sharing them with a few colleagues and received positive feedback. Thought I’d try posting one of these digests … Continue reading →

Understanding CPU on AIX Power SMT Systems

Posted by Jeremy ⋅ July 1, 2016 ⋅ 6 Comments

This month I worked with a chicagoland company to improve performance for eBusiness Suite on AIX. I’ve worked with databases running on AIX a number of times over the years now. Nevertheless, I got thrown for a loop this week. TLDR: In the end, it came down to a fundamental change in resource accounting that … Continue reading →

November/December Highlights

Posted by Jeremy ⋅ January 2, 2014 ⋅ 1 Comment

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over beers – justifying hotel and … Continue reading →