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@xxxxxxxxxxx -- Weenies test. Geniuses solve problems that arise.
Attachment:
pgpQNNEoPBO44.pgp
Description: PGP signature
