pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@coretech.co.nz>
To: Hervé Piedvache <herve@elma.fr>
Cc: Bruno Almeida do Lago <teolupus@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Fri, 21 Jan 2005 10:05:47 +1300
Message-ID: <41F01D2B.9030902@coretech.co.nz> (raw)
In-Reply-To: <200501202000.03853.herve@elma.fr>
References: <005701c4ff1b$42c0ada0$e883f40a@br.gedasgrp>
	<200501202000.03853.herve@elma.fr>

Hervé Piedvache wrote:
> 
> 
> Dealing about the hardware, for the moment we have only a bi-pentium Xeon 
> 2.8Ghz with 4 Gb of RAM ... and we saw we had bad performance results ... so 
> we are thinking about a new solution with maybe several servers (server 
> design may vary from one to other) ... to get a kind of cluster to get better 
> performance ...
>
The poor performance may not necessarily be:

i) attributable to the hardware or,
ii) solved by clustering.

I would recommend determining *why* you got the slowdown. A few possible
reasons are:

i) not vacuuming often enough, freespacemap settings too small.
ii) postgresql.conf setting very non optimal.
iii) index and/or data design not optimal for PG.

My suspicions would start at iii).

Other posters have pointed out that 250000000 records in itself is not
necessarily a problem, so this sort of data size is manageable.

regards

Mark






view thread (131+ messages)  latest in thread

Message-ID: <41F01D2B.9030902@coretech.co.nz>
Permalink:  ../41F01D2B.9030902@coretech.co.nz/
Also on:    postgresql.org/message-id/41F01D2B.9030902@coretech.co.nz

 · 

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: markir@coretech.co.nz, herve@elma.fr, teolupus@gmail.com
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <41F01D2B.9030902@coretech.co.nz>

* 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