Re: databases limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: fabio(at)gashost(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: databases limit
Date: 2003-02-06 05:30:03
Message-ID: 9513.1044509403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> On Wed, Feb 05, 2003 at 18:48:44 -0200,
> Fabio Angeluci Martins <famartins(at)gashost(dot)com> wrote:
>> What/Where i need set/configure to limit the numbers of databases which a
>> normal user can create?

> Either a user can create as many databases as they want or they can't create
> any.

I have a feeling that what the questioner really means is "how can I
limit the resources consumed by any one database user?" In which case
the problem is a lot bigger than limiting the number of times you can do
CREATE DATABASE. What about creating a lot of tables in a single
database? Or attaching a lot of indexes to a table? Or inserting a
huge number of rows in one table? Or running queries that take forever
and chew up all the CPU cycles?

Postgres doesn't really attempt to deal with any of these problems.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-02-06 05:51:28 Re: How do I create an array?
Previous Message Tom Lane 2003-02-06 05:24:31 Re: How do I create an array?

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-02-06 07:00:50 Re: Status report: regex replacement
Previous Message Tom Lane 2003-02-06 04:07:52 Re: Status report: regex replacement