Search code examples
postgresqlpartitioningpostgresql-9.3

postgres table - Does it require partitioning

We have a usecase where in a year we can be storing 600 MB of data (worst case) in a postgres table. It is a very small table. Does it require any partitioning to be made scalable. Appreciate any inputs!

Solution

  • No. This amount of data will comfortably fit in RAM. Maybe if you were accumulating 600GB of data a year it would be worth thinking about.