-
The tables are tiny, non-sharded... low tens of millions of rows per table. Absolutely nothing special being done with them.
I do know sharding techniques, and partitioning stuff... but I've not yet seen any reason to use those things here. The database is still less than 100GB in size.
Velocio-
And do you run the cluster yourself etc, or managed solution like RDS? What kind of set up are we talking?
Also interested in what kind of approach you're using towards fulltext search?We are running RDS postgres flavour ... I have no idea what's considered a large vs a small DB.
I really like postgres, especially the jsonb stuff, and have learnt a lot about it in the last two years. If there's a complicated reporting query they want, then it's always me writing them.For fulltext right now I am running a trigger that processes the relevant fields into a ts_vector. Not sure if that's a good or shit approach.
pascalo
@Velocio Out of professional curiosity, how large are the tables you're running? We're using postgres but I am not quite clear of what the upper limits are. I am sure you have loads more data than us. Do you shard it etc?