🤖robot.villas
PostsTagsStatsStatusAbout

© 2025 - 2026 Nat Welch. All rights reserved.

#postgresql

230 posts

  • @voodootikigod Optimizing PostgreSQL for Scale: An In-Depth Guide for Developers #PostgreSQL #Database #Developer

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/voodootikigod/posts/22450143

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/voodootikigod/posts/22450143

    Don't have an account? Find a server at joinmastodon.org

    Aug 15, 2023
  • @java_sql_and_jooq The Performance Impact of SQL's FILTER Clause #SQL #Performance #PostgreSQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405852

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405852

    Don't have an account? Find a server at joinmastodon.org

    Feb 6, 2023
  • @kai_wern Some useful psql commands to know #PostgreSQL #Database #DevTips

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432623

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432623

    Don't have an account? Find a server at joinmastodon.org

    Oct 24, 2022
  • @neil_panchal How to install PostgreSQL in a custom directory #PostgreSQL #Database #DevOps

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/neil_panchal/posts/22441275

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/neil_panchal/posts/22441275

    Don't have an account? Find a server at joinmastodon.org

    Oct 8, 2022
  • @chris_kiehl How to Influence Query Planning in Postgresql #Postgresql #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/chris_kiehl/posts/22386999

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/chris_kiehl/posts/22386999

    Don't have an account? Find a server at joinmastodon.org

    Sep 18, 2022
  • @kai_wern Writing PostgreSQL extension in Rust With pgrx #Rust #PostgreSQL #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432676

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432676

    Don't have an account? Find a server at joinmastodon.org

    Jul 20, 2022
  • @hoverbear PostgreSQL Aggregates with Rust #Rust #PostgreSQL #OpenSource

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/hoverbear/posts/22427180

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/hoverbear/posts/22427180

    Don't have an account? Find a server at joinmastodon.org

    Feb 9, 2022
  • @vsevolod_solovyov PostgreSQL archiver failure #PostgreSQL #Database #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22449975

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22449975

    Don't have an account? Find a server at joinmastodon.org

    Nov 8, 2021
  • @kai_wern What you need to know about PostgreSQL timezone #PostgreSQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432813

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432813

    Don't have an account? Find a server at joinmastodon.org

    Jul 20, 2021
  • @stonecharioteer_on_tech A Weekend With PostgreSQL #PostgreSQL #Database #DevTools

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stonecharioteer_on_tech/posts/22459930

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stonecharioteer_on_tech/posts/22459930

    Don't have an account? Find a server at joinmastodon.org

    Jun 28, 2021
  • @stonecharioteer_on_tech TIL: Breaking PostgreSQL at Scale and LeetCode Problem Patterns #PostgreSQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stonecharioteer_on_tech/posts/22460238

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stonecharioteer_on_tech/posts/22460238

    Don't have an account? Find a server at joinmastodon.org

    Apr 7, 2021
  • @dba_stackexchange Is it possible to have a temporary, on-the-fly PostgreSQL table which only ever lives in RAM? #PostgreSQL #Database #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414586

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414586

    Don't have an account? Find a server at joinmastodon.org

    Feb 10, 2021
  • @vsevolod_solovyov Pitfalls of JSONB indexes in PostgreSQL #PostgreSQL #Database #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450011

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450011

    Don't have an account? Find a server at joinmastodon.org

    Jun 23, 2020
  • @vsevolod_solovyov Unexpected indexes on PostgreSQL 12 #PostgreSQL #Database #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450020

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450020

    Don't have an account? Find a server at joinmastodon.org

    May 14, 2020
  • @vsevolod_solovyov ORM database migration tools #PostgreSQL #Database #SoftwareDevelopment

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450024

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/vsevolod_solovyov/posts/22450024

    Don't have an account? Find a server at joinmastodon.org

    May 4, 2020
  • @kai_wern Essential Date Functions for Grouping in PostgreSQL #PostgreSQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432918

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kai_wern/posts/22432918

    Don't have an account? Find a server at joinmastodon.org

    Apr 14, 2020
  • @will_jessops_writings Error installing libv8 on Mac OS Catalina #Ruby #PostgreSQL #MacOs

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/will_jessops_writings/posts/22451062

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/will_jessops_writings/posts/22451062

    Don't have an account? Find a server at joinmastodon.org

    Feb 17, 2020
  • @hoverbear Hierarchical Structures in PostgreSQL #PostgreSQL #Database #OpenSource

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/hoverbear/posts/22427256

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/hoverbear/posts/22427256

    Don't have an account? Find a server at joinmastodon.org

    Jan 19, 2020
  • @dba_stackexchange Can I change the wal_level from logical to replica? If so are any impact on the replication process? #Database #SQL #PostgreSQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414613

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414613

    Don't have an account? Find a server at joinmastodon.org

    Jan 10, 2020
  • @alex_edwards Using PostgreSQL JSONB with Go #Go #PostgreSQL #WebDev

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/alex_edwards/posts/22373273

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/alex_edwards/posts/22373273

    Don't have an account? Find a server at joinmastodon.org

    May 14, 2019
  • @dba_stackexchange AWS RDS postrgres massive disk use, small tables #Database #PostgreSQL #CloudComputing

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22576256

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22576256

    Don't have an account? Find a server at joinmastodon.org

    Aug 17, 2018
  • @tin_rabzelj N+1 Queries in GraphQL Using PostgreSQL Window Functions #GraphQL #PostgreSQL #SoftwareEngineering

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/tin_rabzelj/posts/22444753

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/tin_rabzelj/posts/22444753

    Don't have an account? Find a server at joinmastodon.org

    Jul 23, 2018
  • @kracekumar Return Postgres data as JSON in Python #Python #PostgreSQL #Json

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kracekumar/posts/22381482

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kracekumar/posts/22381482

    Don't have an account? Find a server at joinmastodon.org

    Feb 3, 2017
  • @nerderati PostgreSQL Tables Can Only Have 1600 Columns, Ever. #PostgreSQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/nerderati/posts/22441431

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/nerderati/posts/22441431

    Don't have an account? Find a server at joinmastodon.org

    Jan 3, 2017
  • @makandra_dev_cards Case sensitivity in PostgreSQL #PostgreSQL #Database #DevTips

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/makandra_dev_cards/posts/22437869

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/makandra_dev_cards/posts/22437869

    Don't have an account? Find a server at joinmastodon.org

    Aug 1, 2016
  • @kris_jenkins_blog Extending Esqueleto for Type-Safe Postgresql Queries #PostgreSQL #Programming #Databases

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kris_jenkins_blog/posts/22405862

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/kris_jenkins_blog/posts/22405862

    Don't have an account? Find a server at joinmastodon.org

    Jul 28, 2015
  • @chris_dones_blog Fast pagination on PostgreSQL #PostgreSQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/chris_dones_blog/posts/22410773

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/chris_dones_blog/posts/22410773

    Don't have an account? Find a server at joinmastodon.org

    Oct 28, 2014
  • @travis_jeffery Using PostgreSQL's Hstore with Rails #PostgreSQL #Rails #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/travis_jeffery/posts/22462000

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/travis_jeffery/posts/22462000

    Don't have an account? Find a server at joinmastodon.org

    Feb 20, 2012
  • @revsys_blog Why isn't PostgreSQL using my index? #PostgreSQL #Database #Performance

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/revsys_blog/posts/22454254

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/revsys_blog/posts/22454254

    Don't have an account? Find a server at joinmastodon.org

    Sep 16, 2008
  • @revsys_blog PostgreSQL version 8.3 Released #PostgreSQL #Database #OpenSource

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/revsys_blog/posts/22454319

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/revsys_blog/posts/22454319

    Don't have an account? Find a server at joinmastodon.org

    Feb 4, 2008
« Newer