Latest published stories - DeveloperSites
1
likes
spam Like Dislike

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

published 350 days, 14 hours, 19 minutes ago posted by matthewpomarmatthewpomar 359 days, 18 hours, 2 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 350 days, 14 hours, 19 minutes ago posted by matthewpomarmatthewpomar 359 days, 18 hours, 3 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 350 days, 14 hours, 19 minutes ago posted by matthewpomarmatthewpomar 359 days, 18 hours, 5 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 350 days, 14 hours, 19 minutes ago posted by matthewpomarmatthewpomar 359 days, 18 hours, 6 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 350 days, 14 hours, 19 minutes ago posted by matthewpomarmatthewpomar 359 days, 18 hours, 27 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