pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLimiting database size
9+ messages / 8 participants
[nested] [flat]
* Limiting database size
@ 2002-06-07 19:11 Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
2002-06-17 16:52 ` Re: Limiting database size Jeff Boes <jboes@nexcerpt.com>
2002-06-18 08:11 ` Re: Limiting database size Ulrich Sprick <nospam.ulrich.sprick@gmx.de>
0 siblings, 3 replies; 9+ messages in thread
From: Maurício Sessue Otta @ 2002-06-07 19:11 UTC (permalink / raw)
To: pgsql-sql
Hi, is there any way to limit the database size??
[]'s Mauricio
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
@ 2002-06-07 21:42 ` Josh Berkus <josh@agliodbs.com>
2002-06-25 19:48 ` Re: Limiting database size Eric <emayo@pozicom.net>
2 siblings, 1 reply; 9+ messages in thread
From: Josh Berkus @ 2002-06-07 21:42 UTC (permalink / raw)
To: Maurício Sessue Otta <mauricio@cristorei.com.br>; pgsql-sql
Mauricio,
> Hi, is there any way to limit the database size??
First, this is a question for PGSQL-NOVICE or PGSQL-GENERAL, not this mailing
list.
Second -- sort of. You can put the database on its own hard drive partition.
Then the database will crash when it runs out of space -- so I'm not sure
that helps you.
Of course, with other RDBMSs, which have administrative settings for size
limits, the database shuts down when you're out of space. So I'm not sure
how useful the whole idea is.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
@ 2002-06-25 19:48 ` Eric <emayo@pozicom.net>
2002-06-26 18:12 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 9+ messages in thread
From: Eric @ 2002-06-25 19:48 UTC (permalink / raw)
To: pgsql-sql
I like the idea of putting it on a hard disk or partition of fixed size and
waiting for the DB to simply crash.
hahaha
"Josh Berkus" <josh@agliodbs.com> wrote in message
news:200206071442.36850.josh@agliodbs.com...
> Mauricio,
>
> > Hi, is there any way to limit the database size??
>
> First, this is a question for PGSQL-NOVICE or PGSQL-GENERAL, not this
mailing
> list.
>
> Second -- sort of. You can put the database on its own hard drive
partition.
> Then the database will crash when it runs out of space -- so I'm not sure
> that helps you.
>
> Of course, with other RDBMSs, which have administrative settings for size
> limits, the database shuts down when you're out of space. So I'm not sure
> how useful the whole idea is.
>
> --
> -Josh Berkus
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh@agliodbs.com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
2002-06-25 19:48 ` Re: Limiting database size Eric <emayo@pozicom.net>
@ 2002-06-26 18:12 ` Josh Berkus <josh@agliodbs.com>
2002-06-26 23:07 ` Re: Limiting database size terry <tg5027@citlink.net>
2002-06-26 23:41 ` Re: Limiting database size Thomas Swan <tswan@idigx.com>
0 siblings, 2 replies; 9+ messages in thread
From: Josh Berkus @ 2002-06-26 18:12 UTC (permalink / raw)
To: Eric <emayo@pozicom.net>; pgsql-sql
Eric,
> I like the idea of putting it on a hard disk or partition of fixed size and
> waiting for the DB to simply crash.
> hahaha
Yeah. <grin> It's what MS SQL Server does, though. As I said, I think the
whole concept of limiting database size in MB is fundamentally flawed. I
mean, what's the database supposed to do when it runs out of space?
-Josh
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
2002-06-25 19:48 ` Re: Limiting database size Eric <emayo@pozicom.net>
2002-06-26 18:12 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
@ 2002-06-26 23:07 ` terry <tg5027@citlink.net>
1 sibling, 0 replies; 9+ messages in thread
From: terry @ 2002-06-26 23:07 UTC (permalink / raw)
To: pgsql-sql
>> Yeah. <grin> It's what MS SQL Server does, though. As I
>> said, I think the whole concept of limiting database size in
>> MB is fundamentally flawed. I mean, what's the database
>> supposed to do when it runs out of space?
Display a window that says:
"Management has determined that this database shall not exceed
XXXmb. If your business function requires more disk space - take
it up with your manager."
Limiting database size is not a problem for developers, unless
they are unable/unwilling to explain to their management that
disks are a whole lot less expensive than terminating a database
application that depends them.
But then, M$ never takes any responsibility for the amount of
disk space it wastes.....
terry
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
2002-06-25 19:48 ` Re: Limiting database size Eric <emayo@pozicom.net>
2002-06-26 18:12 ` Re: Limiting database size Josh Berkus <josh@agliodbs.com>
@ 2002-06-26 23:41 ` Thomas Swan <tswan@idigx.com>
1 sibling, 0 replies; 9+ messages in thread
From: Thomas Swan @ 2002-06-26 23:41 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: Eric <emayo@pozicom.net>; pgsql-sql
Josh Berkus wrote:
>Eric,
>
>>I like the idea of putting it on a hard disk or partition of fixed size and
>>waiting for the DB to simply crash.
>>hahaha
>>
>>
>Yeah. <grin> It's what MS SQL Server does, though. As I said, I think the
>whole concept of limiting database size in MB is fundamentally flawed. I
>mean, what's the database supposed to do when it runs out of space?
>
Refuse updates, deletes, and inserts (from anything other than a DB
superuser). However you should be able to select data. Once the
database has exceeded its bounds, it would revert to read only status
and wait for administrative intervention such as enlarging the quota
(allocatable size) or altering the database to reduce its size.
Adding the checks wouldn't break existing databases if you defaulted the
checks to off.
This could also significantly help in hosting situations by preventing a
client for exceeding a specified quota and taking over the allocated
area for the postgres database.
Thinking about it, it seems like a good safety feature (aside from good
partitioning and system layout to begin with).
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
@ 2002-06-17 16:52 ` Jeff Boes <jboes@nexcerpt.com>
2 siblings, 0 replies; 9+ messages in thread
From: Jeff Boes @ 2002-06-17 16:52 UTC (permalink / raw)
To: pgsql-sql
On Fri, 07 Jun 2002 16:37:03 -0400, Maurício Sessue Otta wrote:
> Hi, is there any way to limit the database size??
You can limit a table's size (row count) by means of a rule or trigger.
I don't think there's any good way to control the overall size (in bytes)
of a database.
--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
@ 2002-06-18 08:11 ` Ulrich Sprick <nospam.ulrich.sprick@gmx.de>
2 siblings, 0 replies; 9+ messages in thread
From: Ulrich Sprick @ 2002-06-18 08:11 UTC (permalink / raw)
To: pgsql-sql
Hi Mauricio
Novell, and i think windows and unix as well, have the disk quota feature.
The disk size assigned to a user can be limited. There should also be
warning levels in order to get the sysadmin noticed about a user running out
of space before it's too late. Try on a os related newsgroup, they should
know better!
ulli
"Maurício Sessue Otta" <mauricio@cristorei.com.br> schrieb im Newsbeitrag
news:005a01c20e57$3dbdfcc0$8359e6c8@cristorei.com.br...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0057_01C20E3E.0C7EE840
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi, is there any way to limit the database size??
>
> []'s Mauricio
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Limiting database size
@ 2002-06-07 21:06 Tulio Oliveira <tulio@telecontrol.com.br>
0 siblings, 0 replies; 9+ messages in thread
From: Tulio Oliveira @ 2002-06-07 21:06 UTC (permalink / raw)
To: Maurício Sessue Otta <mauricio@cristorei.com.br>; pgsql-sql
Hello, Mr. Bruce da Silva LEE,
Put the Database directory into a pre-sized partition.
Regards,
--
Tulio Oliveira
Internet DBA
Telecontrol Networking
--------- Mensagem Original --------
De: Maurício Sessue Otta <mauricio@cristorei.com.br>
Para: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Assunto: [SQL] Limiting database size
Data: 07/06/02 17:36
> Hi, is there any way to limit the database size??
>
> []'s Mauricio
>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2002-06-26 23:41 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-07 19:11 Limiting database size Maurício Sessue Otta <mauricio@cristorei.com.br>
2002-06-07 21:42 ` Josh Berkus <josh@agliodbs.com>
2002-06-25 19:48 ` Eric <emayo@pozicom.net>
2002-06-26 18:12 ` Josh Berkus <josh@agliodbs.com>
2002-06-26 23:07 ` terry <tg5027@citlink.net>
2002-06-26 23:41 ` Thomas Swan <tswan@idigx.com>
2002-06-17 16:52 ` Jeff Boes <jboes@nexcerpt.com>
2002-06-18 08:11 ` Ulrich Sprick <nospam.ulrich.sprick@gmx.de>
2002-06-07 21:06 Re: Limiting database size Tulio Oliveira <tulio@telecontrol.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox