pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gergely CZUCZY <phoemix@harmless.hu>
To: PostgreSQL admin <pgsql-admin@postgresql.org>
Subject: schemas and tablespaces
Date: Fri, 10 Nov 2006 13:05:22 +0100
Message-ID: <20061110120522.GA57650@harmless.hu> (raw)

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

-- 
Weenies test. Geniuses solve problems that arise.

view thread (3+ messages)  latest in thread

Message-ID: <20061110120522.GA57650@harmless.hu>
Permalink:  ../20061110120522.GA57650@harmless.hu/
Also on:    postgresql.org/message-id/20061110120522.GA57650@harmless.hu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: phoemix@harmless.hu
  Subject: Re: schemas and tablespaces
  In-Reply-To: <20061110120522.GA57650@harmless.hu>
  References: <20061110120522.GA57650@harmless.hu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox