From: Matthew Nuzum <mattnuzum@gmail.com>
To: NbForYou <nbforyou@hotmail.com>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Process Time X200
Date: Fri, 10 Mar 2006 09:48:22 -0600
Message-ID: <f3c0b4080603100748o2bccc29ag968009149a91df8f@mail.gmail.com> (raw)
In-Reply-To: <BAY107-DAV40A47C6BFCB846618C36BDBED0@phx.gbl>
References: <BAY107-DAV18040C8CE1ECE56E895A9EDBED0@phx.gbl>
<20060310085943.GA8913@winnie.fuhr.org>
<BAY107-DAV40A47C6BFCB846618C36BDBED0@phx.gbl>
On 3/10/06, NbForYou <nbforyou@hotmail.com> wrote:
> Hey Michael, you sure know your stuff!
>
> Versions:
>
> PostgreSQL 7.3.9-RH running on the webhost.
> PostgreSQL 8.0.3 running on my homeserver.
>
> So the only solution is to ask my webhost to upgrade its postgresql?
> The question is will he do that? After all a license fee is required for
> commercial use. And running a webhosting service is a commercial use.
>
> thanks for replying and going through the effort of creating the database
> and populating it.
>
> Nick
>
You can look at the explain analyze output of the query from pg 7.3,
figure out why the plan is bad and tweak your query to get optimum
performance.
Yes, I agree with the other statements that say, "upgrade to 7.4 or
8.x if you can" but if you can't, then you can still work on it.
--
Matthew Nuzum
www.bearfruit.org
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: mattnuzum@gmail.com, nbforyou@hotmail.com, mike@fuhr.org
Subject: Re: Process Time X200
In-Reply-To: <f3c0b4080603100748o2bccc29ag968009149a91df8f@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