Re: How many secondary databases can I create? - Mailing list pgsql-general

From Michelle Konzack
Subject Re: How many secondary databases can I create?
Date
Msg-id 20041114182648.GH2913@freenet.de
Whole thread Raw
In response to Re: How many secondary databases can I create?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Hello Joshua,

Am 2004-11-13 21:40:10, schrieb Joshua D. Drake:
> Dawid Kuroczko wrote:

> >1) One pgsql per user -- in other words each user runs its own copy of
> >pgsql -- waste of memory (each user having its own shared mem, etc),
> >but can enforce quota limits, etc.  Hard to keep all those copies of
> >pgsql running.
> >
> Hello,
>
> We use this version as it allows us to provide the best security
> and flexibility to the customer

This is right, but how many $USER do you have and what Computer ?

And I think, the database is only accessible local without TCP ?

If you have 100 $USER und 100 postmasers running and $USER wish
to connect via TCP how do you manage the Ports ?

I am searching a solution to split up a ~800 GByte big database...
and currently it increase around 100 MByte/day. (running with 9 x
SCSI-HDD 147 GByte in Raid-5 on a Quad-Athlon with only 4 GByte of
memory and not 8 GByte as I like)

> Sincerely,
>
> Joshua D. Drake

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)

Attachment

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: How many secondary databases can I create?
Next
From: Tom Lane
Date:
Subject: Re: shrinking physical space used