Search Postgresql Archives

Re: Tablespace limit feature

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 4 Nov 2014 17:00:54 +0000 (UTC), Alejandro Carrillo
(fasterzip@xxxxxxxx) wrote about "Re:  Tablespace limit
feature" (in
<1781968257.697829.1415120454794.JavaMail.yahoo@xxxxxxxxxxxxxxxxxxxxxxxxxxx>):

> I need to limit the tablespace file because I need to control the
> hard disk space used in a tablespace. Anybody knows how to do this?
> Or if it this in the PostgreSQL roadmap?

The way I handle this is to allocate each tablespace its own logical
volume or partition and to mount it as /var/db/<tablespace>.  This
causes the filesystem itself to limit the amount of disk space the
tablespace can use.
- -- 
Regards,

Dave  [RLU #314465]
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
david.w.noon@xxxxxxxxxxxxxx (David W Noon)
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlRZCzIACgkQogYgcI4W/5Q9PQCfXAnKwoRTOUmRZVJsjVn2ysZH
brgAnRudOLOUGSuIVmY7xiRqSZCWL6l/
=v2yc
-----END PGP SIGNATURE-----


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux