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

Re: Tablespaces

From: Richard Huxton <dev(at)archonet(dot)com>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespaces
Date: 2004-02-26 11:25:23
Message-ID: 200402261125.23730.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
On Thursday 26 February 2004 10:07, Gavin Sherry wrote:
>
> CREATE TABLESPACE tbl1 LOCATION '/var/'
>
> which will result in something like '/var/123443' is a bad idea. Then
> again, the user should know better. Comments?

The LOCATION should have the same owner and permissions as $PGDATA - that 
should catch mistyping.

Unless you're running as root, of course. In which case you clearly know 
better than everyone else, so off you go!

> Comments? Questions? Suggestions?

Presumably I'm using this to deal with performance/space issues, so there 
clearly needs to be something in the pg_stat_xxx system to show figures based 
on tablespace - not sure what you'd measure though - disk I/O, number of 
nodes?

Perhaps something in contrib/ too - tablespace_disk_usage.pl or some such.
-- 
  Richard Huxton
  Archonet Ltd

In response to

Responses

pgsql-hackers by date

Next:From: Hans-Jürgen SchönigDate: 2004-02-26 11:25:24
Subject: Re: Tablespaces
Previous:From: Shridhar DaithankarDate: 2004-02-26 10:38:50
Subject: Re: Tablespaces

pgsql-hackers-win32 by date

Next:From: Hans-Jürgen SchönigDate: 2004-02-26 11:25:24
Subject: Re: Tablespaces
Previous:From: Shridhar DaithankarDate: 2004-02-26 10:38:50
Subject: Re: Tablespaces

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