Temporary files in PostgreSQL – Steps to identify and fix temp file issues

Work_mem is the memory area used by queries for operations such as JOINS, ORDER BY, DISTINCT etc . Default value is 4 MB which is not sufficient for large sort operations.

What we do

We produce high quality content on open source databases

All of our blog posts are well researched and we spend weeks to conduct research on select topics.Please share our content with your network. Our team can help you with Vitess deployment, Cloud migration . Hit below button to schedule an appointment

Book Appointment

PostgreSQL Tips and Tricks – Part 1

Pgpool Issues – Part 2

We are a team of seasoned database engineers

Extensive experience in suppporting mission critical systems- 50+ years of combined experience.Our team members are certified in database and cloud technologies .

Lets Get Started
on your project

We will help you to achieve your goals and to grow your business.

Start Now