From: | Michelle Konzack <linux4michelle(at)freenet(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How many secondary databases can I create? |
Date: | 2004-11-14 18:26:48 |
Message-ID: | 20041114182648.GH2913@freenet.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-14 18:39:14 | Re: shrinking physical space used |
Previous Message | Michelle Konzack | 2004-11-14 18:18:15 | Re: How many secondary databases can I create? |