Take the tour ×  I have a few million rows in my database
already. I didn't know about the PostgreSQL UUID data type when
I designed my schema.  One of the tables has 16M rows (about
3.5M to 4 M records per shard), growing at about 500K records
per day. I still have the luxury of taking the production system
down for a few hours if required. I won't have this luxury in
one or two weeks.  My question is, will it be worthwhile to do
so? I'm wondering about JOIN performance, disk space use (full
gzip'd dump is 1.25 GiB), things of that nature.  Table schema
is:  # \d twitter_interactions                 Table
"public.twitter_interactions"          Column          |
Type             | Modifiers   interaction_id          |
character(36)               | not null  status_text
| character varying(1024)     | not null  screen_name
| character varying(40)       | not null  twitter_user_id
| bigint                      |   replying_to_screen_name |
character varying(40)       |