Re: limits?
От | Kynn Jones |
---|---|
Тема | Re: limits? |
Дата | |
Msg-id | c2350ba40806231245m6bcf4211v251f8b8f5a8628ee@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: limits? (Steve Atkins <steve@blighty.com>) |
Ответы |
Re: limits?
Re: limits? Re: limits? |
Список | pgsql-general |
On Mon, Jun 23, 2008 at 2:21 PM, Steve Atkins <steve@blighty.com> wrote:
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".
Actually, the DB I have in mind would certainly be approaching "silly territory." I'm looking at a schema with around 10 thousand tables (or views). Unfortunately, as far as I can tell, http://www.postgresql.org/about/ says nothing about maximum number of tables. I suppose I could always find what this limit is "the hard way", by writing a script that just keeps creating empty tables and see where that goes, but I'd prefer not to do something like this...
Anyway, thanks! (And to Joshua too!)
Kynn
В списке pgsql-general по дате отправления: