On Mon, 2008-06-23 at 11:21 -0700, Steve Atkins wrote: > > > http://www.postgresql.org/about/ has some of the theoretical limits. > > In real use you're unlikely to hit any limits, theoretical or > practical, but if you start to use a silly number of tables and so > on > you're likely to hit performance issues eventually. I'm not sure > where > that threshold would be, but it's higher than "thousands". > > Cheers, > Steve I'm just a developer (my DBA would have more details on the settings that needed adjusting), but I will attest to it being reasonably easy to hit database limits. For us, it was related to having a reasonably small number of (large) aggregate tables that are partitioned (inherited with check constraints) by week. The real problem wasn't the absolute limit of tables (IIRC) as much as accessing the data in a parallel manner from the parent tables in bulk update transactions (the parallel was probably what pushed it over the top). The limit is absurdly high, and by the time you hit it, you'll probably have a really good idea of how to overcome it. Really, there's lots of "challenges" you'll overcome before that time (IMO). Of course all this is anecdotal, and you should take it with a grain of salt. :) -Mark
