Jason Novinger@programming.devM · 1 year agoPostgreSQL Operator for Kubernetescloudnative-pg.ioexternal-linkmessage-square0fedilinkarrow-up110arrow-down10
arrow-up110arrow-down1external-linkPostgreSQL Operator for Kubernetescloudnative-pg.ioJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agohydradatabase/hydra: Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes.plus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up18arrow-down10
arrow-up18arrow-down1external-linkhydradatabase/hydra: Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes.plus-squaregithub.comJason Novinger@programming.devM · 1 year agomessage-square0fedilink
starman@programming.devMEnglish · 1 year agoPostgreSQL 16plus-squarewww.postgresql.orgexternal-linkmessage-square2fedilinkarrow-up122arrow-down10
arrow-up122arrow-down1external-linkPostgreSQL 16plus-squarewww.postgresql.orgstarman@programming.devMEnglish · 1 year agomessage-square2fedilink
Jason Novinger@programming.devM · 1 year agoSubqueries and performance in PostgreSQL - CYBERTECplus-squarewww.cybertec-postgresql.comexternal-linkmessage-square1fedilinkarrow-up114arrow-down10
arrow-up114arrow-down1external-linkSubqueries and performance in PostgreSQL - CYBERTECplus-squarewww.cybertec-postgresql.comJason Novinger@programming.devM · 1 year agomessage-square1fedilink
agilob@programming.devEnglish · edit-21 year agoLesser Known PostgreSQL Featuresplus-squarehakibenita.comexternal-linkmessage-square3fedilinkarrow-up19arrow-down10
arrow-up19arrow-down1external-linkLesser Known PostgreSQL Featuresplus-squarehakibenita.comagilob@programming.devEnglish · edit-21 year agomessage-square3fedilink
Jason Novinger@programming.devM · 1 year agoFun with PostgreSQL puzzles: Surface Area and 3D Slicesplus-squarewww.crunchydata.comexternal-linkmessage-square0fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1external-linkFun with PostgreSQL puzzles: Surface Area and 3D Slicesplus-squarewww.crunchydata.comJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoThe Unexpected Find That Freed 20GB of Unused Index Spaceplus-squarehakibenita.comexternal-linkmessage-square0fedilinkarrow-up137arrow-down10
arrow-up137arrow-down1external-linkThe Unexpected Find That Freed 20GB of Unused Index Spaceplus-squarehakibenita.comJason Novinger@programming.devM · 1 year agomessage-square0fedilink
bahmanm@lemmy.ml · 1 year agoMemory context: how PostgreSQL allocates memoryplus-squarewww.cybertec-postgresql.comexternal-linkmessage-square0fedilinkarrow-up19arrow-down10
arrow-up19arrow-down1external-linkMemory context: how PostgreSQL allocates memoryplus-squarewww.cybertec-postgresql.combahmanm@lemmy.ml · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoPostGIS 3.4.0 releasedplus-squarepostgis.netexternal-linkmessage-square0fedilinkarrow-up111arrow-down10
arrow-up111arrow-down1external-linkPostGIS 3.4.0 releasedplus-squarepostgis.netJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoIntroducing pg_later: Asynchronous Queries for Postgresplus-squaretembo.ioexternal-linkmessage-square0fedilinkarrow-up15arrow-down11
arrow-up14arrow-down1external-linkIntroducing pg_later: Asynchronous Queries for Postgresplus-squaretembo.ioJason Novinger@programming.devM · 1 year agomessage-square0fedilink
ruffsl@programming.devEnglish · 1 year agoFix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square1fedilinkarrow-up110arrow-down11
arrow-up19arrow-down1external-linkFix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmyplus-squaregithub.comruffsl@programming.devEnglish · 1 year agomessage-square1fedilink
Jason Novinger@programming.devM · 1 year agoZero-Downtime PostgreSQL Cutoversplus-squaretech.instacart.comexternal-linkmessage-square0fedilinkarrow-up112arrow-down11
arrow-up111arrow-down1external-linkZero-Downtime PostgreSQL Cutoversplus-squaretech.instacart.comJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoWhen Did Postgres Become Cool?plus-squarewww.crunchydata.comexternal-linkmessage-square3fedilinkarrow-up120arrow-down11
arrow-up119arrow-down1external-linkWhen Did Postgres Become Cool?plus-squarewww.crunchydata.comJason Novinger@programming.devM · 1 year agomessage-square3fedilink
daq@lemmy.daqfx.comEnglish · edit-21 year agoPostgreSQL Optimizationsplus-squaremessage-squaremessage-square11fedilinkarrow-up16arrow-down10
arrow-up16arrow-down1message-squarePostgreSQL Optimizationsplus-squaredaq@lemmy.daqfx.comEnglish · edit-21 year agomessage-square11fedilink
RoundSparrow@lemmy.ml · edit-21 year agoCan I accomplish this in a single SQL statement?plus-squaremessage-squaremessage-square6fedilinkarrow-up17arrow-down10
arrow-up17arrow-down1message-squareCan I accomplish this in a single SQL statement?plus-squareRoundSparrow@lemmy.ml · edit-21 year agomessage-square6fedilink
bahmanm@lemmy.ml · 1 year agoWhy is my WAL directory so large?plus-squarewww.depesz.comexternal-linkmessage-square0fedilinkarrow-up16arrow-down10
arrow-up16arrow-down1external-linkWhy is my WAL directory so large?plus-squarewww.depesz.combahmanm@lemmy.ml · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.ml · edit-21 year agoLemmy server mass update of comment reply (child) count with PostgreSQL ltree structureplus-squaremessage-squaremessage-square11fedilinkarrow-up123arrow-down11
arrow-up122arrow-down1message-squareLemmy server mass update of comment reply (child) count with PostgreSQL ltree structureplus-squareRoundSparrow@lemmy.ml · edit-21 year agomessage-square11fedilink
Jason Novinger@programming.devM · 1 year ago[Podcast] Postgres FM | Shardingplus-squarepostgres.fmexternal-linkmessage-square0fedilinkarrow-up18arrow-down10
arrow-up18arrow-down1external-link[Podcast] Postgres FM | Shardingplus-squarepostgres.fmJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoPostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3 Releasedplus-squarewww.postgresql.orgexternal-linkmessage-square0fedilinkarrow-up110arrow-down10
arrow-up110arrow-down1external-linkPostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3 Releasedplus-squarewww.postgresql.orgJason Novinger@programming.devM · 1 year agomessage-square0fedilink
Jason Novinger@programming.devM · 1 year agoGitHub - zknill/sqledge: Replicate postgres to SQLite on the edgeplus-squaregithub.comexternal-linkmessage-square1fedilinkarrow-up19arrow-down10
arrow-up19arrow-down1external-linkGitHub - zknill/sqledge: Replicate postgres to SQLite on the edgeplus-squaregithub.comJason Novinger@programming.devM · 1 year agomessage-square1fedilink