Skip to main content

All Questions

Filter by
Sorted by
Tagged with
13 votes
1 answer
8k views

Debug query on big table that is sometimes slow

I have a web API that is backed by a Postgres database, and the performance is generally very good. I monitor the performance of both the database and the application as a whole. Most of my queries (...
Jason Whitehorn's user avatar
3 votes
1 answer
975 views

Faster alter table column type in RDS Postgres?

has anyone figured out faster way of doing postgres 14 column type change in RDS? We currently have a table that is running out of int4 space and multiple columns needs to be converted to int8. Table ...
anttik's user avatar
  • 31