Pavlo Golub from CYBERTEC with his talk "Getting Started with pgwatch: Features, Installation, and Use Cases" #postgreql #pgconfde
Viktoriia Hrechukha from Umka Software during her talk "Embedding Workloads as a New Stress Test for Postgres" #postgreql #pgconfde
Anton Borisov from Fresha talks about "Swapping the Elephant Without Breaking the Room" #postgreql #pgconfde

want to quickly check the permissions on your #postgreql DB? simply run these 5 easy to remember commands:
\du
\l+ (db name)
\dn+
\dp
\ddp

(and then cross reference the list of 9 characters next to each username against the manual)

(about sums up my confusion this evening)

Bruce Momjian: Postgres Blog

Levei um tempão para tentar otimizar a performance do portal, e era só criar um índice duplo para atender o ORDER BY

O resultado da busca caiu de 1500 milissegundo para 5 milissegundos 🙏
#postgreql

PostgreSQL in #WASM allows you to run a #PostgreQL instance in the browser, Node.js, or Bun. Finally a proper, dependency-less database server for your browser :) #linktuesday

https://github.com/electric-sql/pglite

GitHub - electric-sql/pglite: Embeddable Postgres with real-time, reactive bindings.

Embeddable Postgres with real-time, reactive bindings. - electric-sql/pglite

GitHub
Last weekend I volunteered at the #postgreql booth at #fosdem, today I posted a blog post about my experiences at https://proopensource.it/blog/fosdem-2023.html
ProOpenSource OÜ Blog | FOSDEM 2023

ProOpenSource OÜ Blog | FOSDEM 2023
Here we go, finally I set up again a instance of #pgwatch2 with #grafana for have a better look at my #postgreql server 🤘