From: André Volpato <andre.volpato@ecomtecnologia.com.br>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres not using array
Date: Thu, 21 Aug 2008 17:05:12 -0300
Message-ID: <48ADCA78.2090605@ecomtecnologia.com.br> (raw)
In-Reply-To: <29595.1219345818@sss.pgh.pa.us>
References: <48AC8292.5000708@ecomtecnologia.com.br>
<48AD735D.6040403@ecomtecnologia.com.br>
<23465.1219328880@sss.pgh.pa.us>
<48AD80FA.30100@ecomtecnologia.com.br>
<29595.1219345818@sss.pgh.pa.us>
Tom Lane escreveu:
>> We are guessing that a dual core 3.0GHz will beat up a quad core 2.2,
>> at least in this environmnent with less than 4 concurrent queryes.
>
> The most you could hope for from that is less than a 50% speedup. I'd
> suggest investing some tuning effort first. Some rethinking of your
> schema, for example, might buy you orders of magnitude ... with no new
> hardware investment.
I think we almost reached the tuning limit, without changing the schema.
You are right, the whole design must be rethinked.
But this question about single vs multi cores has bitten me.
We will rethink the investiment in new hardware too. The databases that are
used less often will be managed to a single core server.
--
[]´s, ACV
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: andre.volpato@ecomtecnologia.com.br
Subject: Re: Postgres not using array
In-Reply-To: <48ADCA78.2090605@ecomtecnologia.com.br>
* 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