Search Postgresql Archives

Re: How many secondary databases can I create?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: signature.pgp
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux