#postgresql

...

At 2:23 AM last Tuesday, something went wrong with our database. Backups were a few days old, and so recovery took longer. That’s when I realized our backup system had to be better. Managed databases can

... connection directly from sql code, lol.

Do you tune #postgresql to lower the value of random_page_cost?

Naming things is hard #postgresql

... be a rust rewrite called Postgrs. #postgresql

#PostgreSQL 18 introduces async IO

... #postgresql

... snowflake ID types.

... function returning hardcoded value 42. Select row selects a single row from table having 10k rows. plpgsql being faster than sql is surprising for the second case.

Really #postgresql ? I can insert text value into an integer column?

... in sql file is next level sql skill. #postgresql

... in the table #postgresql #ai #python

... model directly in Postgres process. #python #ai

Activate #python virtual environment right from #postgresql procedure/function.

What if you could just do this? #postgresql #python #ai

... pg_stat_activity #postgresql

... workers.

#postgresql

... Postgres include files.