Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 32EA39FA621 for ; Fri, 10 Nov 2006 08:24:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68066-09 for ; Fri, 10 Nov 2006 08:24:32 -0400 (AST) X-Greylist: delayed 00:18:58.749842 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DAE019FA4A7 for ; Fri, 10 Nov 2006 08:24:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from marvin.harmless.hu (marvin.harmless.hu [195.56.55.204]) by svr4.postgresql.org (Postfix) with ESMTP id 9557B5AF8C7 for ; Fri, 10 Nov 2006 12:05:31 +0000 (GMT) Received: from localhost (marvin-mail [192.168.0.2]) by marvin.harmless.hu (Postfix) with ESMTP id 5EB927BFF07 for ; Fri, 10 Nov 2006 13:05:28 +0100 (CET) X-Virus-Scanned: amavisd-new at harmless.hu Received: from marvin.harmless.hu ([192.168.0.2]) by localhost (marvin.harmless.hu [192.168.0.2]) (amavisd-new, port 10024) with ESMTP id Fxsk73CaZUeW for ; Fri, 10 Nov 2006 13:05:23 +0100 (CET) Received: from marvin.harmless.hu (localhost [127.0.0.1]) by marvin.harmless.hu (Postfix) with ESMTP id DF80B7BFF0B for ; Fri, 10 Nov 2006 13:05:22 +0100 (CET) Date: Fri, 10 Nov 2006 13:05:22 +0100 From: Gergely CZUCZY To: PostgreSQL admin Subject: schemas and tablespaces Message-ID: <20061110120522.GA57650@harmless.hu> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=x-unknown; protocol="application/pgp-signature"; boundary="Dxnq1zWXvFF0Q93v" Content-Disposition: inline User-Agent: mutt-ng/devel-r804 (FreeBSD) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/102 X-Sequence-Number: 23629 --Dxnq1zWXvFF0Q93v Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello I had an issue this day, a project's database gone too large, and it was hard to track it down. before my question, i will describe my setup, thus it may be needed to understand why am i asking whatever i will ask :) So, we have a few databases, each database is related to a developer group. Each group puts their projects into separate schemas into their own database. This approach performed very well, since all of our websites can reuse the same permanent connection, hance they are in the same database, just needs to access a different schema. The issue that happend today was, i've noticed that one of our client's database had gone too big. It was a bit hard for him to track down which project had caused this issue. For this i had the idea to put all projects into separate tablespaces by their schemas at the next upgrade. But as i check the current documentation there were no such feature that all of a schema's sub-elements can be put into a tablespace. You can assign a tablespace to every table, but it's not possible to define a default tablespace for new tables according to which schema are they being created in. Also using this i could track each project's disk usage. Currently, we are using 8.1.4 Are there any solutions for this out there? Or any upcoming solutions in feature versions maybe. Bye, Gergely Czuczy mailto: gergely.czuczy@harmless.hu --=20 Weenies test. Geniuses solve problems that arise. --Dxnq1zWXvFF0Q93v Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) owFVVT1vJEUQNT4gaIngEiSiK3GBBewsNj7fWXs6HdgYcyQEWEJA1DNTs9vnme6h P7zMhQgJgpNApBecRAAJSBcgfgAJCZAT8Q/gF4B41eNdm2S1W139quq9V71fPXdl Y/Pq709+/OiVh18/euqHZ4/Ll7sUo50XnfZnxhY729s7xd6tm3vbxY1il2/u7G/v 73LZ3GrqvaOT081DZyPbWJwMPc8o8ifx1b7Vxt6maqF94HgnxabYV6u8N03oXTDR ODsjY1tjeX124rUNDfviyFauNnY+o4+Ti1wXvTc26rJlpd7mtnVK3aOFrklbMiEk prgwgWo9TEhT7919ruKWBHBJB1ZzZ5HjHLXazxlJtiYTaakDYHyNI4peV6cSrN3S TpUquXGeqRvQAwfpd0KGlqZtqeZQeVPmQ0yY+gnqp6BwudMD4cAy15xhk63ZhygF l4uBdAcQHU4xHH7ryGfs1TkswjR7San33ISWjMbOGNM0vFzPESbEulqsf2N48twC plaopdHZGbeuZ09z71I/pSNJz9+pTzGgTzZ+xRA6trgWuNceGBSqBXegJEfHTHCx rjZVJ8Ky7nFdYFEGFHWYE0MMaLltJxSMrdA2xnGNcskjXEJuDlRBLM8piFiopTsW hE5bSE+VsxYdCctqoQUCSaALChh7cWHVyoTupxAzzZjJKV1VHIIQYBoYSBDHYSDk yYLXJtERtPY9W9EGdhEHQNYtMG1dNJVohiQldnENSf9VawB3yUzZeGtDlWY+pXtR iZU0fsXRUCCGFqa7MJa4Coob4W1kXwlOpUFIPdo3N4mG38LdMZBLyfCmZi1Y0DBz uxIwS6XWAuYVCb0GGVQO5xKuVMXsAmWxoir1c69rntKBAEolJKFLSaiSzwTWrkod vmhRReEEWizlw8IyCXM0rGPy57SOioOCsdxWUCGVBbcsEKP42AvpP7tLX+p1qj5w KWfoEMzc/u9QpubsrxybUJkiFg16QDDCUxIMwpJVc4PHJC9Bo1MbL4NADmWxSGOI YBfn5YGRe6MoY9vZcNl5JeNYVZ5ludAzdHmjDdjnkK+N8lQutfW5wHkxLz09Btuc gp6Loocjpe2QF1tqjDD7053pDQCPRfGpLV4U1yahPGQT5UouxTHhLr3rJQkCVq4T iIts7MlKEfAVcgzPUSkNHAw8UeqY8fi1Ax0+SNWDQXXatNHNaD6Gp1UOvw7/diAp TBdJqaK489q2ep/ZGvCGNY5TOsYPuDZIbSwOZgapXTj3gTfyUnxx98ozG/L/sPpv ubr5/Ysbjw+++fPfp//mv3a/ffTTL2ry2Tu7165vPG4+/47+ufbk5y9vf/jCH789 fP7TNPn1Pw== =DjhE -----END PGP SIGNATURE----- --Dxnq1zWXvFF0Q93v--