Skip site navigation (1) Skip section navigation (2)

Re: Tablespaces

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Tablespaces
Date: 2004-02-27 09:00:29
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA40184CFEE@m0114.s-mxs.net (view raw or flat)
Thread:
Lists: pgsql-hackers
> > Ahh. I forgot to detail my ideas on this. It seems to me that we cannot
> > drop a table space until the directory is empty.

Agreed.

> 
> How would it get to be empty?  Are you thinking of some sort of "connect
> database to tablespace" and "disconnect database from tablespace"
> commands that would respectively create and delete the per-database
> subdirectory?  That seems moderately reasonable to me.  We could then

I would only allow the drop if the directory only contains empty db oid 
directories.

Andreas

Responses

pgsql-hackers by date

Next:From: Zeugswetter Andreas SB SDDate: 2004-02-27 09:14:12
Subject: Re: Thread safe connection-name mapping in ECPG. Is it required?
Previous:From: Michael MeskesDate: 2004-02-27 07:41:05
Subject: Re: CVS HEAD compile warning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group