programming.dev
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
codeinabox to PostgreSQLEnglish · 6 days ago

When upserts don't update but still write: Debugging Postgres performance at scale

www.datadoghq.com

external-link
message-square
0
link
fedilink
  • cross-posted to:
  • [email protected]
6
external-link

When upserts don't update but still write: Debugging Postgres performance at scale

www.datadoghq.com

codeinabox to PostgreSQLEnglish · 6 days ago
message-square
0
link
fedilink
  • cross-posted to:
  • [email protected]
When upserts don't update but still write: Debugging Postgres performance at scale | Datadog
www.datadoghq.com
external-link
When a high-volume upsert doubled disk writes, Datadog engineers traced the issue to Postgres WAL behavior and rewrote the query to eliminate hidden costs.

cross-posted from: https://lemmy.bestiver.se/post/1006496

Comments

alert-triangle
You must log in or # to comment.

PostgreSQL

postgresql

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

The world’s most advanced open source relational database

Project
  • About (history)
  • Docs
  • Donate to PostgreSQL
  • Wiki
  • Planet PostgreSQL
  • IRC
  • Mailing lists:
    • pgsql-announce
    • pgsql-hackers (developers)
    • pgsql-general
    • pgsql-jobs
  • User Groups
Events
  • SEAPUG Summer BBQ, 6 July in Seattle
  • SFBA PostgreSQL Meetup, 12 July
  • Chicago PostgreSQL Meetup, 19 July
  • PGDay UK 2023, 12 September in London
  • PGConf 2023, 3-5 October in New York City
  • PGDay Israel 2023, 19 October
  • PGConf.EU 2023, 12-15 December in Prague
Podcasts
  • postgres.fm (feed)
Related Fediverse communities
  • c/SQL on programming.dev
  • #sql on Mastodon
  • #postgresql on Mastodon
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 1 user / day
  • 6 users / week
  • 13 users / month
  • 85 users / 6 months
  • 289 local subscribers
  • 2.11K subscribers
  • 184 Posts
  • 117 Comments
  • Modlog
  • mods:
  • Ategon
  • starman
  • Jason Novinger
  • BE: 0.19.13
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org