![This is my process to improve the performance of my PostgreSQL database and queries – Steven Can Plan This is my process to improve the performance of my PostgreSQL database and queries – Steven Can Plan](https://i0.wp.com/www.stevencanplan.com/wp-content/uploads/2020/08/Screen-Shot-2020-08-24-at-19.53.20-.png?fit=736%2C374&ssl=1)
This is my process to improve the performance of my PostgreSQL database and queries – Steven Can Plan
![David Rowley on X: "Performance of ORDER BY / DISTINCT aggregates has just been terrible for too long in Postgres. That was changed in master today, per https://t.co/Ad7eJwmSDm https://t.co/aAQo3vUjd2" / X David Rowley on X: "Performance of ORDER BY / DISTINCT aggregates has just been terrible for too long in Postgres. That was changed in master today, per https://t.co/Ad7eJwmSDm https://t.co/aAQo3vUjd2" / X](https://pbs.twimg.com/media/FZJzjG3UYAMb45J.png)
David Rowley on X: "Performance of ORDER BY / DISTINCT aggregates has just been terrible for too long in Postgres. That was changed in master today, per https://t.co/Ad7eJwmSDm https://t.co/aAQo3vUjd2" / X
![CONVERT lat and long field in PostgreSQL using ST_GeomFromText - Geographic Information Systems Stack Exchange CONVERT lat and long field in PostgreSQL using ST_GeomFromText - Geographic Information Systems Stack Exchange](https://i.stack.imgur.com/IKcyC.png)