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

From Tom Lane
Subject Re: [GENERAL] Physical Database Configuration
Date
Msg-id 25768.1056643187@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Physical Database Configuration  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: [GENERAL] Physical Database Configuration
Re: [GENERAL] Physical Database Configuration
List pgsql-hackers
Shridhar Daithankar <shridhar_daithankar@persistent.co.in> writes:
> Well, consider this. Keep in mind that all of them are directories..

I can see no reason that we'd want a level of directory associated with
schemas...

> Well, with above proposal, drop database should be as simple. It's just that 
> it would be more than one `rm -rf`rather than just one.

Right, there would be potentially one per tablespace.  The key point
here is that the tablespace definitions are known cluster-wide, so a
"DROP DATABASE x" command running in database y would still be able
to figure out which subdirectories it needs to zap.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: [GENERAL] Physical Database Configuration
Next
From: Shridhar Daithankar
Date:
Subject: Re: [GENERAL] Physical Database Configuration