Re: [GENERAL] Physical Database Configuration - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [GENERAL] Physical Database Configuration
Date
Msg-id 146801c33c59$2bee0180$2800a8c0@mars
Whole thread Raw
In response to Re: [GENERAL] Physical Database Configuration  (nolan@celery.tssi.com)
List pgsql-hackers
> > Tablespaces
> >   databases
> >    schemas
> >     objects
> >
> > with each of them implemented as a directory and data files under it. If
we
> > could get a quota check propogated in both direction, that would be
pretty
> > good, may be a warning when things start getting close to limit.

Database do not exist inside tablespaces, as they are not relations.  Only
tables, views, sequences and indexes will live in tablespaces.  Even then, I
probably won't bother allowing it for sequences and views since they don't
occupy much space.

A database can specify a DEFAULT tablespace, as can a schema, but they do
not live in tablespaces themselves.

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [GENERAL] Physical Database Configuration
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Tablespaces (was Re: [GENERAL] Physical Database Configuration )