Counting is a slow measure in Postgresql, and it is even slower with a lot of data and complex statements. This issue is related with the kind of how the data consistency is implemented. As a result Postgresql must check the visiblity of all rows first and so it has to iterate over them all.
4 posts tagged with "performance"
View All TagsThink About It: PHP/PostgreSQL Bulk Performance (Part 3)
This article is the last of a three-part series and describes how we optimized the persistence process of bulk data in our code in combination with PostgreSQL. Make sure you covered the first article about how we tweaked PHPExcel to run faster while reading Excel and CSV files and the second article about how we optimized our data processing and reached performance improvements tweaking our code.
Think About It: Loop Iteration Performance (Part 2)
This article is the second of a three-part series and describes how we optimized our data processing and reached performance improvements tweaking our code. Make sure you covered the first article about how we tweaked PHPExcel to run faster while reading Excel and CSV files.
Think About It: PHPExcel Performance Tweaks (Part 1)
A few weeks back I covered a small article about a CSV-Tool optimized for memory usage and additionally tweaking performance.