Re: limits?
От
Kynn Jones
Тема
Re: limits?
Дата
Msg-id
c2350ba40806231245m6bcf4211v251f8b8f5a8628ee@mail.gmail.com
Ответ на
Re: limits? (Steve Atkins)
Список
Дерево обсуждения
limits? "Kynn Jones" <kynnjo@gmail.com>
Re: limits? Steve Atkins <steve@blighty.com>
Re: limits? Mark Roberts <mailing_lists@pandapocket.com>
Re: limits? "Kynn Jones" <kynnjo@gmail.com>
Re: limits? Tom Lane <tgl@sss.pgh.pa.us>
Re: limits? Robert Treat <xzilla@users.sourceforge.net>
Re: limits? "Rodrigo E. De León Plicet" <rdeleonp@gmail.com>
Re: limits? Thomas Kellerer <spam_eater@gmx.net>
Re: limits? Tino Wildenhain <tino@wildenhain.de>
Re: limits? "Joshua D. Drake" <jd@commandprompt.com>
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 по дате отправления
