Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8F57364FEBD for ; Tue, 14 Oct 2008 21:16:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73044-01-6 for ; Tue, 14 Oct 2008 21:16:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.190]) by postgresql.org (Postfix) with ESMTP id 24FCD64FE71 for ; Tue, 14 Oct 2008 21:15:40 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y8so1392843tia.5 for ; Tue, 14 Oct 2008 17:15:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=saqtS+wNCKCOZ7cvJWFVq7adIObD0icCbIJ5YTnIWMI=; b=YZVpapVAd71SCirMzKq7rV8ozsPMa+9Imdw59VUTJAWCCHVg74+eH7hjlXYFUB6mql kEEogeFWGTO+UKncQDF/SwuploQ/m/U5MCSSdlF8aK20yp88aOOVoYv+uTV8CAAV5RhI yKJOTZQgy/Nea6IJVo0NGvh8OddHtVOo3SBcg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=jZOOrDiG+bEtrrCRODKpBkXkRiLG1YfGvoPhOP8KRg9YeIdRp6q2kytiWuECOU7AVB gOMXHaPYAys3dEWZ1iao0SAYuAsrNsK/pYxvyloDP4X3H0dxdPTcm5lHhpngBbfrDGLP uDqcJ+k9K9DmAdGfxwCpUV59DJRLsDOOXsQTE= Received: by 10.110.105.10 with SMTP id d10mr170693tic.18.1224029738508; Tue, 14 Oct 2008 17:15:38 -0700 (PDT) Received: from ?192.168.0.70? (office.squiz.net [203.206.128.174]) by mx.google.com with ESMTPS id u8sm2068514tia.8.2008.10.14.17.15.36 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 14 Oct 2008 17:15:37 -0700 (PDT) Message-ID: <48F53626.3000404@gmail.com> Date: Wed, 15 Oct 2008 11:15:34 +1100 From: Chris User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: Scott Marlowe CC: pgsql-general@postgresql.org Subject: Re: Drupal and PostgreSQL - performance issues? References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org> <200810122214.53558.uwe@oss4u.com> <20081013090228.248a665f@dawn.webthatworks.it> <20081014114011.0ebe495a@dawn.webthatworks.it> <8c8854360810140647n58abc9bend377e0e234dd39a9@mail.gmail.com> <8c8854360810140828p3b81bba0xac006f5565519981@mail.gmail.com> <48F51EB4.3090908@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/583 X-Sequence-Number: 138832 > 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/