Discover and read the best of Twitter Threads about #postgresql

Most recents (3)

1) Oh man, computer stuff is hard. A small #postgresql thread:

After spending weeks optimizing an ETL process to be 3x faster, an index-only scan got 3x slower compared to a replica that hadn't undergone the new ETL process. Main clue: (shared) buffer hits were up by 10x.
2) My initial suspicion was vacuum issues or index corruption, but no amount of `VACUUM FULL` or recreating the indexes was helping. So I had to dig deeper.

Enter dynamic tracing with perf: wiki.postgresql.org/wiki/Profiling…
3) After some studying of the PostgreSQL source, I decided that ReadBufferExtended would be a good function to trace in order to figure out the big increase in buffer hits/allocs.

github.com/postgres/postg…
Read 12 tweets
J'ai pu [enfin] mettre à jour les données #osm de map-beta.graou.info qui datent de dimanche dernier du coup — on parle ici des données cartographiques hors SNCF — enjoy 🙂

Mini thread sur la méthodo pour fabriquer son extraction #OSM vectorielle chez soi ⬇️
Le combo @Mapbox + @OpenMapTiles est déroutant de facilité et souplesse (rendu côté navigateur, facile de changer le style, très bien documenté, et tout est #opensource).
MAIS les données vectorielles distribuées par #openmaptiles sont soit vieilles, soit chères. Mais...
@OpenMapTiles ils sont sympas : ils vendent des fichiers tous faits pour pas s'embêter, mais si tu veux les fabriquer toi-même, ils expliquent et donnent leur méthode + outils pour le faire. Great job guys !

Tout est là : github.com/openmaptiles/o… il suffit de suivre la doc !
Read 11 tweets
So, my thread on how to choose databases for your web apps starts in 20 minutes time. Hope y'all are ready ?However, this time i would love it to be an interactive session where we can learn from each other about database preferences for specific web apps and the use case
#thread
This is what we want to talk about today. Take a really good look at the image below. Study it well. Also notice the words at the 3 vertexes of the triangle. CONSISTENCY, AVAILABILITY & PARTITION-TOLERANCE (Big English - but fear not, we shall demystify all and it'll all be easy)
If we also look at the image in the previous tweet on this thread we can see some popular databases placed at certain sides of the triangle. It is important to note also the positioning of some of a particular point on each side. We shall discuss this in more detail soon. #thread
Read 48 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just three indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!