From: Scott Marlowe <scott.marlowe@gmail.com>
To: Chris <dmagick@gmail.com>
Cc: Ang Chin Han <ang.chin.han@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Tue, 14 Oct 2008 18:00:23 -0600
Message-ID: <dcc563d10810141700q6faed970q7b63a056b25d91f4@mail.gmail.com> (raw)
In-Reply-To: <48F51EB4.3090908@gmail.com>
References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org>
<200810122214.53558.uwe@oss4u.com>
<20081013090228.248a665f@dawn.webthatworks.it>
<e7e0a2570810131945x1bbf10b8r67c0ac2a340b436f@mail.gmail.com>
<20081014114011.0ebe495a@dawn.webthatworks.it>
<dcc563d10810140556v399ce9ddq94e9c88da2b8a742@mail.gmail.com>
<8c8854360810140647n58abc9bend377e0e234dd39a9@mail.gmail.com>
<BLU142-W253E0943D6748CDC17421DAE310@phx.gbl>
<8c8854360810140828p3b81bba0xac006f5565519981@mail.gmail.com>
<48F51EB4.3090908@gmail.com>
On Tue, Oct 14, 2008 at 4:35 PM, Chris <dmagick@gmail.com> wrote:
>
>> Note this comment:
>> /*
>> * Queries sent to Drupal should wrap all table names in curly brackets.
>> This
>> * function searches for this syntax and adds Drupal's table prefix to all
>> * tables, allowing Drupal to coexist with other systems in the same
>> database if
>> * necessary.
>> */
>> That's an MySQL-ism for working around legacy hosting sites offering
>> only a single MySQL db bogging postgresql down...
>
> No it's not. It's about being able to use a single db for multiple app's.
> Either I do something like that, or I have to [hardcode] change schemas
> after each connection because I only have a single db & a single db user..
> which postgres/oracle[I'm sure others] support but not mysql.
Are you saying you have to reconnect to change schemas? In Oracle and
PostgreSQL both you can change the current schema (or schemas for
postgresql) with a single inline command.
Also, Oracle and PostgreSQL support differing default schemas for
individual users, so you can have connections pooled by user to go to
a certain schema.
> Shared hosts don't give you a lot of resources, so apps build stuff like
> that in to make it easier.
Schemas cost virtually nothing.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, dmagick@gmail.com, ang.chin.han@gmail.com, pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
In-Reply-To: <dcc563d10810141700q6faed970q7b63a056b25d91f4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox