linux

This tag is associated with 4 posts

Copy-and-Paste A New Postgres Dev Env In 5 Min

Posted by Jeremy ⋅ January 8, 2024 ⋅ 1 Comment

You can cut-and-paste the following commands to quickly get a new & clean dev environment for working with PostgreSQL source code. This includes Michael Paquier’s powerful script kit for managing the PostgreSQL development environment. Setting up from scratch takes me about 5 minutes, plus 3 minutes to configure, compile and install PostgreSQL for testing. Running the … Continue reading →

Researching the Performance Puzzle

Posted by Jeremy ⋅ July 31, 2022 ⋅ 1 Comment

The PostgreSQL Performance Puzzle was, perhaps, too easy – it didn’t take long for someone to guess the correct answer! But I didn’t see much discussion about why the difference or what was happening. My emphasis on the magnitude of the difference was a tip-off that there’s much more than meets the eye with this … 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 →