> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Joshua D. Drake > Sent: Friday, June 08, 2007 10:49 PM > To: Alvaro Herrera > Cc: Matthew T. O'Connor; Jim C. Nasby; Michael Paesold; Tom Lane; Andrew > Hammond; Peter Eisentraut; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Autovacuum launcher doesn't notice death of > postmaster immediately > > Alvaro Herrera wrote: > > Matthew T. O'Connor escribió: > > > >> Ok, but I think the question posed is that in say a virtual hosting > >> environment there might be say 1,000 databases in the cluster. > > That is uhmmm insane... 1000 databases?
Not in a test environment. We have several hundred databases here. Of course, only a few dozen (or at most ~100) are of any one type, but I can imagine that under certain circumstances 1000 databases would not be unreasonable. [snip] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match