Database limits

Started by Q Beukesalmost 20 years ago2 messagesgeneral
Jump to latest
#1Q Beukes
pgsql-general@list.za.net

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

Hey,

What ways are there to limit the sizes of a database?

Thx
Q Beukes

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQEVAwUBRF8oErEDZDQ16UzTAQJbsAf+L8+RijP+DFuVWwlHoVRCM5rmCGXo6bsi
dRoeCA3TYgJp25CIPKUXhuL5yBcXUWw5RofNMFeqQyd7n9hIjAiD8VoWxrUGOuIt
cfFH+zdvQAojMoprpEqrt3yx9U0A8pE8l+7Xld+hPJepOzTBOYnf+sna1U4ur+wj
8zPZmoJQrCmGtGzDUtpGn/h42wtlrmoRFLj0rVYRbG1u7wy/l542Qgi7SNXBydYI
jKi5bsriqYGQlcNK83va5ZRuNtmckt22eOdThPUaOjcSewyGW07zK27qBcEjUDUS
TZXEJBGVCq4ybF/OnTcFg98uSsbfYXLzY/+glOXtRPExjLdCgQAPxA==
=6zs+
-----END PGP SIGNATURE-----

#2A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: Q Beukes (#1)
Re: Database limits

am 08.05.2006, um 13:14:26 +0200 mailte Q Beukes folgendes:

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

Hey,

What ways are there to limit the sizes of a database?

You can use filesystem-quotas for your data-partition and/or you can ask
the information_schema about the size of your tables and so.
http://www.postgresql.org/docs/8.1/interactive/functions-admin.html

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===