postgresources – Telegram
postgresources
@postgresources
19 subscribers
8 photos
149 links
halp: @olegkovalov
Download Telegram
About
Blog
Apps
Platform
Join
postgresources
19 subscribers
postgresources
#index https://hakibenita.com/sql-tricks-application-dba#avoid-indexes-on-columns-with-low-selectivity
Hakibenita
Some SQL Tricks of an Application DBA
Non-trivial tips for database development
52 viewsOleg Kovalov, 
postgresources
#perf https://tanelpoder.com/posts/reasons-why-select-star-is-bad-for-sql-performance/
Tanelpoder
Reasons why SELECT * is bad for SQL performance - Tanel Poder Consulting
Here’s a list of reasons why SELECT * is bad for SQL performance, assuming that your application doesn’t actually need all the columns. When I write production code, I explicitly specify the columns of interest in the select-list (projection), not only for…
50 viewsOleg Kovalov, 
postgresources
#perf https://www.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements
Crunchy Data
Query Optimization in Postgres with pg_stat_statements | Crunchy Data Blog
I want to work on optimizing all my queries all day long because it will definitely be worth the time and effort. That's a statement that has hopefully never been said. So when it comes to query optimizing, how should you pick your battles?
55 viewsOleg Kovalov 🇺🇦, 
postgresources
#storage https://www.dbi-services.com/blog/toasting-in-postgresql-lets-see-it-in-action/
dbi Blog
TOASTing in PostgreSQL, let's see it in action
The last two posts introduced TOASTing strategies and how TOAST tables look like. Have a look at those posts if you are not yet familiar with TOAST in PostgreSQL. In this post we’ll look a bit under the hood to understand how TOASTing really works. We’ll…
64 viewsOleg Kovalov 🇺🇦, 
postgresources
#vacuum https://ottertune.com/blog/the-part-of-postgresql-we-hate-the-most/
Andy Pavlo - Carnegie Mellon University
The Part of PostgreSQL We Hate the Most
As much as Andy loves PostgreSQL, there is one part that is terrible and causes many headaches for people. Learn what it is and why it sucks.
67 viewsOleg Kovalov 🇺🇦, 
postgresources
#locks https://www.kylehailey.com/post/postgres-partition-pains-lockmanager-waits
Kyle Hailey
Postgres Partition Pains - LockManager Waits
1000 Fetch errors a second, 500 sessions waiting on LockManager, 150,000 locksIn above graphs, our production system hit the wall by a blind siding pile up on LockManager waits causing the application to start hitting 1000 errors a second. I managed to mitigate…
98 viewsOleg Kovalov 🇺🇦, 
postgresources
#index https://hakibenita.com/postgresql-correlation-brin-multi-minmax
Hakibenita
When Good Correlation is Not Enough
How outliers can trick the optimizer into the wrong plan
109 viewsOleg Kovalov 🇺🇦, 
postgresources
#logs https://www.endpointdev.com/blog/2012/06/logstatement-postgres-all-full-logging/
104 viewsOleg Kovalov 🇺🇦, 
postgresources
#locks https://pglocks.org/
105 viewsOleg Kovalov 🇺🇦, 
postgresources
#vacuum https://tembo.io/blog/optimizing-postgres-auto-vacuum/
2.67K viewsOleg Kovalov 🇺🇦, 
postgresources
#transaction https://www.postgresql.org/docs/current/transactions.html
PostgreSQL Documentation
Chapter 66. Transaction Processing
Chapter 66. Transaction Processing Table of Contents 66.1. Transactions and Identifiers 66.2. Transactions and Locking 66.3. Subtransactions 66.4. Two-Phase Transactions This chapter …
75 views🇺🇦 Oleg Kovalov, 
postgresources
#explain https://willj.net/posts/buffer-analysis-when-using-explain-analyse-in-postgres/
willj.net
Buffer analysis when using EXPLAIN ANALYSE in Postgres
The BUFFERS option to Postgres' EXPLAIN command can help you work out where queries are using lots of IO. learn how to use this to optimize your SQL.
68 views🇺🇦 Oleg Kovalov, 
postgresources
#constraints https://borretti.me/article/you-need-more-constraints
Fernando Borretti
You Need More Constraints
A checklist of useful SQL constraints.
62 views🇺🇦 Oleg Kovalov, 
postgresources
#locks https://postgres-locks.husseinnasser.com/
53 views🇺🇦 Oleg Kovalov, 
postgresources
#index https://pgdash.io/blog/finding-unused-indexes-in-postgresql.html?r
pgdash.io
Finding Unused Indexes In PostgreSQL
How to locate unused indexes in Postgres 16 and earlier
55 views🇺🇦 Oleg Kovalov, 
postgresources
postgres howtos https://gitlab.com/postgres-ai/postgresql-consulting/postgres-howtos
GitLab
PostgresAI / PostgreSQL Consulting / postgres-howtos · GitLab
Postgres HowTo articles
98 views🇺🇦 Oleg Kovalov, 
postgresources
#tx https://brandur.org/postgres-atomicity
brandur.org
How Postgres Makes Transactions Atomic
A dive into the mechanics that allow Postgres to provide strong atomic guarantees despite the chaotic entropy of production.
69 views🇺🇦 Oleg Kovalov, edited  
postgresources
#locks https://www.crunchydata.com/blog/one-pid-to-lock-them-all-finding-the-source-of-the-lock-in-postgres
Crunchy Data
One PID to Lock Them All: Finding the Source of the Lock in Postgres | Crunchy Data Blog
One process can lock your Postgres database, dominating all will, blocking other processes and queries. Jesse shows you how to find that one process that’s ruling them all. Once you’ve grabbed this lock and held it close to your chest, he’ll help you on your…
58 viewsOleg, 
postgresources
#explain https://plansplainer.com/explain
74 viewsOleg, 
postgresources
#tuple #null https://www.highgo.ca/2020/10/20/the-way-to-store-null-value-in-pg-record/
www.highgo.ca
The way PG store null value in record
When inserting data into a table, you can specify that the value of a field is null. For example, for a table t (i int, j int, k int), we can execute insert into t values (8,1,6), or insert into t values (3, null, 7) to insert a record with a null value.…
40 viewsOleg, 
postgresources
https://www.crunchydata.com/developers/tutorials
Crunchy Data
Postgres Tutorials | Crunchy Data
Learn Postgres using Crunchy Data's Postgres Playground. The Postgres Playground is a postgres database instance running directly in your browser session.
31 viewsOleg,