Subscribe
Sign in
  1. Discussions
  2. 1TB+ databases in PostgreSQL: yey or nay?

1TB+ databases in PostgreSQL: yey or nay?

Carlota Soto
1 reply
Do you have experience running big (1TB or more) production DBs in RDS PostgreSQL (or PG in general)? What should I be worried about?

Replies

Rakshith Ravi
PATR
PATR
Indexes. You definitely need to worry about indexes. Our "select count(*)" queries went from 7mins to < 1 second with just the addition of an index. I cannot stress how important indexes are at that scale. If you already have the db populated and running on prod, you can add an index in postgres without locking the entire table. Just add the index concurrently and you'll be fine.
Share