@benoit@ruby.social
@benoit@ruby.social avatar

benoit

@benoit@ruby.social

Dev backend. Previously RSpec core team. #Ruby #PostgreSQL. Vim fan. | he / him 🏴

This profile is from a federated server and may be incomplete. Browse more on the original instance.

benoit, to PostgreSQL French
@benoit@ruby.social avatar

Yesterday we migrated many #postgresql databases to 16.2. It went smoothly for all of them except one.
The database is used by Sidekiq for 90% of the traffic. We choose a time window outside of working hours, but still we had some traffic, and we didn't turn off pods. The database was inaccessible for 10min. Jobs rescheduled, and quickly auto-scaling was triggered. I was not able to perform ANALYZE. So requests retrying at the same time + huge disk read. 💥

benoit,
@benoit@ruby.social avatar

@esparta 14 to 16 so big upgrade

tenderlove, to random
@tenderlove@mastodon.social avatar

Getting a new computer, and the thought of moving dotfiles has me shook. I hope vim will support XDG someday.

benoit,
@benoit@ruby.social avatar

@tenderlove @AndrewRadev but there is a proposal? https://github.com/vim/vim/commit/c9df1fb35a1866901c32df37dd39c8b39dbdb64a

thisismissem, to PostgreSQL
@thisismissem@hachyderm.io avatar

Anyone have a good guide handy on PostgreSQL transactions encountering deadlocks and being aborted?

benoit,
@benoit@ruby.social avatar

@thisismissem Hello. Do you have a specific question about this? You want to get the source of the deadlock? Why it's being aborted?

benoit, to PostgreSQL French
@benoit@ruby.social avatar

What do you think about "ltree" in ?

https://www.postgresql.org/docs/current/ltree.html

benoit, to random French
@benoit@ruby.social avatar

I'm not a huge fan of this...

I don't know.

benoit, to random French
@benoit@ruby.social avatar

@joeldrapper I am curious. Why this indentation on litteral gem ? Reminds me of the code from @ioquatix

benoit, to rails French
@benoit@ruby.social avatar

I observe devs in my company bringing back the "schema.rb" file from production into the Git repository.

I am uncertain about this practice. Modifying directly the schema.rb file has consistently been problematic for me. Perhaps it's less of an issue if you solely use schema:load, but I remain skeptical.

I would prefer a re-entering migration to rectify the schema, such as using 'create index if not exists.' This way, changes are propagated across all databases in various environments.

categulario, to PostgreSQL Spanish
@categulario@mstdn.mx avatar

deleted_by_author

    •
    benoit,
    @benoit@ruby.social avatar

    @categulario the request was started long time ago ?

    sebsauvage, to random French
    @sebsauvage@framapiaf.org avatar

    Je réserve un billet de train pour quelqu'un sur l'appli SNCF quand tout à coup...

    Je croyais que c'était terminé cette arnaque ? 😠

    benoit,
    @benoit@ruby.social avatar

    @sebsauvage c'est quoi le dessous de ces offres ?

    benoit, to random French
    @benoit@ruby.social avatar

    Many question on PostgreSQL's Slack could be answered by just typing the same question in a search engine and follow the first link. 😒

    benoit, to PostgreSQL French
    @benoit@ruby.social avatar

    I am wondering if it could be a good idea to have something similar to n_tup_upd but per queries in pg_stat_statements ? Like in pg_stat_all_tables.

    #postgresql

    benoit, to PostgreSQL
    @benoit@ruby.social avatar

    This week nearly full of #PostgreSQL was great. I still miss obvious stuff when looking at queries perf issues but I am an everlasting student. 😄

    I love the community and the database.

    benoit, to random French
    @benoit@ruby.social avatar

    It's interesting to see the discussions on the Twitter or elsewhere about the new gems that will probably be default soon in Rails and already existing OSS contributors that do similar things since multiple years.

    I am wondering how those new librairies could benefit virtuously from the previous one:

    • Hiring partially previous maintainer to work on the new one?
    • Cleary extract concept and refere to previous implementation if maintainer and licence is ✅
    benoit, to PostgreSQL French
    @benoit@ruby.social avatar

    The last 2 week were full of SQL and PostgreSQL RDS. Sometimes it was difficult but always very interesting. I learn a lot and I really love the community and this piece of technology.
    Still some frustrations but at least I know some caveats about the #postgresql.

    benoit,
    @benoit@ruby.social avatar

    @ferki Few points

    https://ruby.social/@benoit/111130458599065037

    And we finally found one query leading to that.

    We had also a big freeze on one of our DB after an upgrade. We had to do a full analyze, then kill queries that were waiting because of BufferIO or DataFileRead.
    We didn't understand what happen. Bad statistic? Query that block I/O 🤷

    benoit, to random French
    @benoit@ruby.social avatar

    https://www.linkedin.com/posts/juliette-audema-46270a82_je-suis-soulag%C3%A9e-de-vous-annoncer-que-mon-activity-7107347918273040384-YKV7/

    scudery, to random French
    @scudery@piaille.fr avatar

    OK le gang de la #Daronnie.
    C'est dur de faire des repas et de faire manger des enfants par ce temps.
    Il faut pourtant qu'ils avalent des calories.

    Quels sont vos pro tips?

    Je commence :

    🔸melon-pastèque
    🔸smoothies
    🔸wraps froids avec du fromage frais, du jambon de dinde et de la salade / du céleri
    🔸hoummous de pois chiches en boîte
    🔸si on cuit des trucs, c'est au micro ondes

    #DaronnieTocToc

    benoit,
    @benoit@ruby.social avatar

    @scudery

    • quiches (déclinaisons infinies)
    • taboulé à leurs goûts ou à composer à table
    • lasagnes ou tu peux un peu tout planquer
    • changer le format des repas. Faire un apéro avec des légumes à croquer avec des formes cool, du fromage, des mix type humus (avec déclinaison haricots rouges, lentilles corail, etc) ou simplement rajouter des pics en bois pour manger en général
    • tomates cerises au four (dans un peu d'eau et d'huile d'olive) avec du riz à côté
    benoit, to PostgreSQL
    @benoit@ruby.social avatar

    Recently I worked a lot on performance issue on a db. Few things to remember.

    • Learn to read explain + use tools like the one from Dalibo
    • Planner can take wrong decisions
    • Create a snapshot with production data and tests index/settings/etc
    • Use psql
    • When testing indexes, remove the one used to see if the new one is used
    • PgAnalyze is a good tool
    • Keep a logbook of your work
    • Write a script with the queries that should be fast
      1/2
    benoit, to PostgreSQL French
    @benoit@ruby.social avatar

    Indexing email column with hashtext for smaller index.

    https://youtu.be/m8ogrogKjXo?t=773

    benoit,
    @benoit@ruby.social avatar

    @louis I will try and publish the result

    benoit, to random French
    @benoit@ruby.social avatar

    How do we hide/mute people on Slack ? 😅

    benoit, to random
    @benoit@ruby.social avatar

    Les priorités à droite en agglomération, encore une idée qui devrait disparaître pour permettre aux enfants de plus prendre la route.
    Je comprendrais jamais ces économies de panneaux, alors que tous les mois ces carrefours sont des sources d'accidents.

    benoit,
    @benoit@ruby.social avatar

    @Di4na Ici y a des dos d'ânes en plus. Mais ça change pas grand chose.

    hunleyd, to random
    @hunleyd@fosstodon.org avatar

    Memory Management - Stormatics https://stormatics.tech/blogs/postgresql-memory-management

    benoit,
    @benoit@ruby.social avatar

    @hunleyd I find hard to deal with that. Especially with cold cache that make random queries slow sometimes.

    Thanks for the article

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • Leos
  • tsrsr
  • DreamBathrooms
  • mdbf
  • magazineikmin
  • khanakhh
  • Youngstown
  • everett
  • slotface
  • tacticalgear
  • rosin
  • thenastyranch
  • kavyap
  • PowerRangers
  • tester
  • ethstaker
  • vwfavf
  • GTA5RPClips
  • Durango
  • osvaldo12
  • cisconetworking
  • hgfsjryuu7
  • InstantRegret
  • cubers
  • modclub
  • normalnudes
  • ngwrru68w68
  • anitta
  • All magazines
    •