RoundSparrow@lemmy.mlM · edit-21 year agoprimary SELECT for post listing while logged-in and parenthesis around JOIN statements... maybe the background analyze statistics + incoming federation INSERT is causing the periods of crashing....plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareprimary SELECT for post listing while logged-in and parenthesis around JOIN statements... maybe the background analyze statistics + incoming federation INSERT is causing the periods of crashing....plus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
Anark Karabey@monero.townEnglish · 1 year agoHow to move psql database from 13 to 15 for lemmy 0.18.4plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareHow to move psql database from 13 to 15 for lemmy 0.18.4plus-squareAnark Karabey@monero.townEnglish · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoHow to connect to the database if Lemmy is in a docker container? - Lemmyplus-squarelemmy.mlexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkHow to connect to the database if Lemmy is in a docker container? - Lemmyplus-squarelemmy.mlRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · edit-21 year agoEvery Block List / Subscribe List is identifiable as a Listplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareEvery Block List / Subscribe List is identifiable as a Listplus-squareRoundSparrow @ BT@bulletintree.comM · edit-21 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · edit-21 year agoCommunity Retention Policyplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareCommunity Retention Policyplus-squareRoundSparrow @ BT@bulletintree.comM · edit-21 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · 1 year agoPostgreSQL usage in Lemmy is many JOINplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarePostgreSQL usage in Lemmy is many JOINplus-squareRoundSparrow @ BT@bulletintree.comM · 1 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · edit-21 year agoForest for the Trees, Lemmy PostgreSQL / Diesel ORMplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareForest for the Trees, Lemmy PostgreSQL / Diesel ORMplus-squareRoundSparrow @ BT@bulletintree.comM · edit-21 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · 1 year agolemmy comment INSERT activitymessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarelemmy comment INSERT activityRoundSparrow @ BT@bulletintree.comM · 1 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · 1 year agoLemmy admins: PostgreSQL 15.4 Released!plus-squarewww.postgresql.orgexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkLemmy admins: PostgreSQL 15.4 Released!plus-squarewww.postgresql.orgRoundSparrow @ BT@bulletintree.comM · 1 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · 1 year agoLemmy PostgreSQL backup pg_dump, compressed, excluded activity tablesplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy PostgreSQL backup pg_dump, compressed, excluded activity tablesplus-squareRoundSparrow @ BT@bulletintree.comM · 1 year agomessage-square0fedilink
RoundSparrow @ BT@bulletintree.comM · 1 year agoHOT updates in PostgreSQL for better performance - building slack space into tablesplus-squarewww.cybertec-postgresql.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkHOT updates in PostgreSQL for better performance - building slack space into tablesplus-squarewww.cybertec-postgresql.comRoundSparrow @ BT@bulletintree.comM · 1 year agomessage-square0fedilink