| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Alex <alex(at)meerkatsoft(dot)com>, Frank Finner <postgresql(at)finner(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG vs MySQL |
| Date: | 2004-03-29 17:26:12 |
| Message-ID: | 40685C34.8090709@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I also wonder how well the pg_hba.conf method will scale. What happens
> if there are hundreds of client databases or thousands of entries in
> pg_hba.conf?
Although I personally would like to see a pg_hba table instead of the
file, I would have to seariously question your implementation if you had
hundreds of databases on a single machine.
If you need separate data spaces for each customer but the application
uses the same schema, use namespaces within a single database.
Sincerely,
Joshua D. Drake
> --
> Mike Nolan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
| Attachment | Content-Type | Size |
|---|---|---|
| jd.vcf | text/x-vcard | 640 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Diogo Biazus | 2004-03-29 17:53:01 | Re: Problem with memory in C function |
| Previous Message | Alexander Blüm | 2004-03-29 16:40:47 | pl/pgsql perform and execute return wrong values... |