matthewpomar
Name: matthewpomar
Score: n/a
Last Seen: 327 days, 20 hours, 40 minutes ago
Member Since: 8 December, 2021
Role:
Moderator
DeveloperSites
atom rss
1
likes
spam Like Dislike

12 Common Mistakes and Missed Optimization Opportunities in SQL

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 20 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:12:55 PM GMT
SQL is used by analysts, data scientists, product managers, designers and many others. These professionals have access to databases, but they don't always have the intuition and understanding to write efficient queries. In an effort to make my team write better SQL, I went over reports written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 32 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:00:22 PM GMT
Any database schema is likely to have plenty of text fields. In this article I demonstrate the surprising impact of medium-size texts on query performance. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

Re-Introducing Hash Indexes in PostgreSQL

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 33 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:59:22 PM GMT
There is a type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

The Unexpected Find That Freed 20GB of Unused Index Space

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 35 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:57:25 PM GMT
In this article I describe the process we took to identify potential free space, and one surprising find that helped up clear up ~10GB of unused indexed values! (more)
category: PostgreSQL | clicked: 2 | comment | | source: hakibenita.com
tags: Django, ORM
1
likes
spam Like Dislike

Practical SQL for Data Analysis

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 36 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:56:24 PM GMT
Pandas is by far the most popular tool for data analysis. It's packed with useful features, it's battle tested and widely accepted. However, pandas comes at a cost which is often overlooked. SQL databases has been around since the 1970s. They contain many features that most developers never heard of, and I want to bring some of them to light. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: SQL
1
likes
spam Like Dislike

18+ Powerful PostgreSQL Features You Didn't Know Existed

published 830 days, 14 hours, 49 minutes ago posted by matthewpomarmatthewpomar 839 days, 18 hours, 57 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:35:29 PM GMT
PostgreSQL is a powerful, full featured relational database management system. However, this free and open-source DBMS has a surprising number of fantastic features most PostgreSQL developers don't know anything about. In this article, Haki Benita, a renown and respected blogger on PostgreSQL, Python, and related technologies, list more than 18 lesser known PostgreSQL features that can improve your productivity and make your life easier as a PostgreSQL developer or admin. (more)
category: PostgreSQL | clicked: 5 | 1 comment | | source: hakibenita.com
tags: SQL
Previous 1 2 Next