postgresources – Telegram
postgresources
@postgresources
19 subscribers
8 photos
149 links
halp: @olegkovalov
Download Telegram
About
Blog
Apps
Platform
Join
postgresources
19 subscribers
postgresources
#scaling https://www.cybertec-postgresql.com/en/postgres-scaling-advice-for-2021/
CYBERTEC PostgreSQL | Services & Support
Postgres scaling advice
This article covers scaling advices for PostgreSQL and explains why it may be a good idea to keep it simple on the database side.
23 viewsOleg Kovalov, 
postgresources
#replication https://medium.com/moveax/how-postgresql-replication-works-6288b3e6000e
Medium
How PostgreSQL replication works
A quick (almost deep) dive into replication and HA configurations
27 viewsOleg Kovalov, 
postgresources
#index https://vsevolod.net/postgresql-12-btree/
Vsevolod Solovyov
Unexpected indexes on PostgreSQL 12 | Vsevolod Solovyov
Vsevolod Solovyov's blog
26 viewsOleg Kovalov, 
postgresources
#index #json https://vsevolod.net/postgresql-jsonb-index/
Vsevolod Solovyov
Pitfalls of JSONB indexes in PostgreSQL | Vsevolod Solovyov
Vsevolod Solovyov's blog
28 viewsOleg Kovalov, 
postgresources
https://www.postgresql.org/docs/current/sql-createstatistics.html
PostgreSQL Documentation
CREATE STATISTICS
CREATE STATISTICS CREATE STATISTICS — define extended statistics Synopsis CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON …
31 viewsOleg Kovalov, 
postgresources
#index #space https://hakibenita.com/postgresql-unused-index-size
Hakibenita
The Unexpected Find That Freed 20GB of Unused Index Space
How to free space without dropping indexes or deleting data
26 viewsOleg Kovalov, 
postgresources
#query https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/
27 viewsOleg Kovalov, 
postgresources
#query https://info.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements
Crunchydata
Query Optimization in Postgres with pg_stat_statements
"I want to work on optimizing all my queries all day long because it will definitely be worth the time and effort," is a statement that has hopefully never been said. So when it comes to query optimizing, how should you pick your battles?
30 viewsOleg Kovalov, 
postgresources
#trigger https://www.cybertec-postgresql.com/en/postgresql-how-to-write-a-trigger/
CYBERTEC PostgreSQL | Services & Support
PostgreSQL: How to write a trigger
UPDATED 2023: A trigger is a way to automatically respond to events. This is a tutorial on how to manage and program triggers in PostgreSQL.
34 viewsOleg Kovalov, 
postgresources
#config https://www.depesz.com/2021/03/01/starting-with-pg-where-how-can-i-set-configuration-parameters/
28 viewsOleg Kovalov, 
postgresources
#query #index https://blog.crunchydata.com/blog/fuzzy-name-matching-in-postgresql
Crunchy Data
Fuzzy Name Matching in Postgres
The page "Falsehoods Programmers Believe About Names" covers some of the ways names are hard to deal with in programming. This post will ignore most of those complexities, and deal with the problem of matching up loose user input to a database of names.
24 viewsOleg Kovalov, 
postgresources
#text #index https://news.freshports.org/2021/03/08/replacing-a-column-search-with-a-full-text-search-solution/
22 viewsOleg Kovalov, 
postgresources
#perf #concurrency https://buttondown.email/nelhage/archive/notes-on-some-postgresql-implementation-details/
buttondown.email
Notes on some PostgreSQL implementation details
Ranger update Seriously friends he has gotten so large. He knows his name and comes when called, like, 80% of the time. He turned four months old today, just...
22 viewsOleg Kovalov, 
postgresources
#vacuum https://blog.sentry.io/2015/07/23/transaction-id-wraparound-in-postgres
27 viewsOleg Kovalov, 
postgresources
#vacuum https://www.highgo.ca/2021/03/20/how-to-check-and-resolve-bloat-in-postgresql/
Highgo Software Inc. - Enterprise PostgreSQL Solutions
How to check and resolve Bloat in PostgreSQL
Bloating in database is created when tables or indexes are updated, an update is essentially a delete and insert operation. The diskspace used by the delete is available for reuse but it is not reclaimed hence creating the bloat. This blog talks baout how…
28 viewsOleg Kovalov, 
postgresources
#query #perf https://www.foxhound.systems/blog/sql-performance-with-union/
Foxhound Systems
Speeding up SQL queries by orders of magnitude using UNION – Foxhound Systems
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
26 viewsOleg Kovalov, 
postgresources
#storage https://www.cybertec-postgresql.com/en/when-to-use-tablespaces-in-postgresql/
CYBERTEC PostgreSQL | Services & Support
When to use tablespaces in PostgreSQL
This article explains what PostgreSQL tablespaces are, when to use them and how they are different from Oracle tablespaces.
26 viewsOleg Kovalov, 
postgresources
#migration https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/
Strongly Typed
Safe Operations For High Volume PostgreSQL
Safe PostgreSQL operations for a high volume deploys without downtime.
19 viewsOleg Kovalov, 
postgresources
#migration https://gocardless.com/blog/zero-downtime-postgres-migrations-the-hard-parts/
Gocardless
Zero-downtime Postgres migrations - the hard parts
Experience smooth zero downtime Postgres migrations. Master the hard parts of transitioning seamlessly. Unlock success now.
21 viewsOleg Kovalov, 
postgresources
#migration https://blog.nelhage.com/post/rwlock-contention/#sql
Made of Bugs
Reader/reader blocking in reader/writer locks
In writer-priority reader/writer locks, as soon as a single writer enters the
acquisition queue, all future accesses block behind any in-flight reads. If any
readers hold the lock for extended periods of time, this can lead to extreme
pauses and loss of throughput…
28 viewsOleg Kovalov, 
postgresources
#json https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/
ScaleGrid
JSONB PostgreSQL: How To Store & Index JSON Data
In this post, we are going to show you tips and techniques on how to effectively store and index JSON data in PostgreSQL. Learn more about JSONB in Postgres.
26 viewsOleg Kovalov,