Re: [GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread Tom Lane
William Yu <[EMAIL PROTECTED]> writes: > Benjamin Arai wrote: >> What is the current maximum number of tables per database? Also, does >> having more tables slow down performance in any way? > For most cases, the answer is no. However, once you get near 6 figure > table counts, pg_catalog ends

Re: [GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread William Yu
Benjamin Arai wrote: What is the current maximum number of tables per database? Also, does having more tables slow down performance in any way? For most cases, the answer is no. However, once you get near 6 figure table counts, pg_catalog ends up being pretty massive. The problem is that the

[GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread Benjamin Arai
What is the current maximum number of tables per database? Also, does having more tables slow down performance in any way? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster