Overview
News
Technologies
Salaries
Products
People
Growth
Financials
Overview
The Database Chronicles. This post is not about troubleshooting but rather about an interesting observation. I will start with a quick intro.Visibility map is a fork of the relation which maintains two bits: one for visible, the other for frozen tuples. These bits set per page.
News
On visibility map and failing transactions
This post is not about troubleshooting but rather about an interesting observation. I will start with a quick intro. Visibility map is a fork of the relation which maintains two bits: one for visible, the other for frozen tuples. These bits set per page.
Read more
Report
Beyond Basic OS Tools
One common performance issue in Linux systems is a program consuming unexpectedly high CPU. At first glance, high CPU usage alone doesn't necessarily indicate a problem, but if the reason for the high usage is unclear, it warrants further investigation. O
Read more
Report
Application-oblivious diagnosis
When diagnosing a performance problem, interpreting the flow inside of the application is as important as other aspects of the whole process, such as tools and methodology. One of the key points is to figure out what the application threads are supposed t
Read more
Report
Diving deeper into the LWLock in PostgreSQL.
Lightweight locks (LWLocks) are a type of interprocess lock used by PostgreSQL to coordinate simultaneous access of multiple processes to a shared memory region. There are various reasons that can cause this lock to create issues in the database. I will n
Read more
Report
Reasoning about OS Scheduler for Performance Degradation Analysis
It all started with a performance issue in one of our clusters. One of the components on the critical path turned out to be the OS scheduler which I analyzed to find out whether it was the offender itself or just a symptom, and the global slowness was cau
Read more
Report
Pro access
Upgrade to see all 10 mentions
Upgrade to a paid plan to read every media mention of this company - funding news, awards, product launches and press releases from all the outlets writing about it.
Every media mention and press release
Funding news, awards and product launches
Fresh coverage from every outlet writing about the company
Upgrade now
Cancel anytime. Secure checkout. Instant activation.