Re: PostgreSQL clustering VS MySQL clustering - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 41F01D2B.9030902@coretech.co.nz
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Hervé Piedvache <herve@elma.fr>)
List pgsql-performance
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




pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re:
Next
From: Alex Turner
Date:
Subject: Re: [SQL] OFFSET impact on Performance???