Sidebar

PostgreSQL

"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL francisco1844 • 1 year ago • 100%
Why is my WAL directory so large? https://www.depesz.com/2023/06/18/why-is-my-wal-directory-so-large/
3
1
"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL RoundSparrow • 1 year ago • 100%
Lemmy PostgreSQL - can someone please help deconstruct this INSERT SQL: INSERT INTO "comment_like"...

`INSERT INTO "comment_like" ("person_id", "comment_id", "post_id", "score") VALUES ($1, $2, $3, $4) ON CONFLICT ("comment_id", "person_id") DO UPDATE SET "person_id" = $5, "comment_id" = $6, "post_id" = $7, "score" = $8 RETURNING "comment_like"."id", "comment_like"."person_id", "comment_like"."comment_id", "comment_like"."post_id", "comment_like"."score", "comment_like"."published"` ~~The server is showing relatively high execution time for this INSERT statement, like 0.4 seconds mean time. Is this form of blended INSERT with UPDATE and RETURNING slower than doing a direct insert?~~ (was misreading data, these are milliseconds, not seconds) Every time a remote federation Upvote on a comment comes in to Lemmy, it executes this statement.

2
3
"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL ascherbaum • 1 year ago • 75%
Call for Papers for PGConf New York 2023 2023.pgconf.nyc

Reminder: the Call for Papers for PGConf New York 2023 ends on Monday! Get your submissions in. #PostgreSQL #Conference #CfP #PGConfNYC

2
0
"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL ascherbaum • 1 year ago • 100%
PostgreSQL Person of the Week interview with: Sharan Foga https://postgresql.life/post/sharan_foga/
3
0
"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL ascherbaum • 1 year ago • 80%
PGConf New York Talk Submissions https://mastodon.social/@ascherbaum/110469842048716169

That's today! 16:00 UTC Let's talk about your unfinished proposal for #pgconfnyc, and polish it up so you can submit it! The CfP ends June 12th #PostgreSQL #CfP #Conference #NewYork

3
0
"Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearPO
PostgreSQL jayknight • 1 year ago • 100%
PostgreSQL and SQL:2023 http://peter.eisentraut.org/blog/2023/04/18/postgresql-and-sql-2023
5
0