pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Chris <dmagick@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Wed, 15 Oct 2008 11:15:34 +1100
Message-ID: <48F53626.3000404@gmail.com> (raw)
In-Reply-To: <dcc563d10810141700q6faed970q7b63a056b25d91f4@mail.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>
	<dcc563d10810141700q6faed970q7b63a056b25d91f4@mail.gmail.com>


> 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.

No I meant you have to change the schema after connecting.

Some hosts only give you one db & one user. Yeh it sucks but that's all 
they give you.

Before anyone says "get a new host".. from the end user POV.. you don't 
know and/or don't care about the technical details, you just want 
something "that works" with what you have. It's not an ideal situation 
to be in but it definitely does happen.

>> 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.

Neither does building a smart(er) app which lets you set a "prefix" for 
all of your tables so they are grouped together.

You'll get a tiny performance hit from doing the replacement of the 
prefix, but it's not going to be significant compared to everything else.

-- 
Postgresql & php tutorials
http://www.designmagick.com/




view thread (68+ messages)  latest in thread

Message-ID: <48F53626.3000404@gmail.com>
Permalink:  ../48F53626.3000404@gmail.com/
Also on:    postgresql.org/message-id/48F53626.3000404@gmail.com

 · 

reply
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: dmagick@gmail.com, scott.marlowe@gmail.com, pgsql-general@postgresql.org
  Subject: Re: Drupal and PostgreSQL - performance issues?
  In-Reply-To: <48F53626.3000404@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