pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Antal Attila <atesz@ritek.hu>
To: pgsql-performance@postgresql.org
Subject: What's the best hardver for PostgreSQL 8.1?
Date: Tue, 20 Dec 2005 19:27:15 +0100
Message-ID: <43A84D03.7090002@ritek.hu> (raw)

Hi!

What do you suggest for the next problem?
We have complex databases with some 100million rows (2-3million new 
records per month). Our current servers are working on low resposibility 
in these days, so we have to buy new hardver for database server. Some 
weeks ago we started to work with PostgreSQL8.1, which solved the 
problem for some months.
There are some massive, hard query execution, which are too slow (5-10 
or more minutes). The parallel processing is infrequent (rarely max. 4-5 
parallel query execution).
So we need high performance in query execution with medium parallel 
processability.
What's your opinion what productions could help us? What is the best or 
only better choice?
The budget line is about 30 000$ - 40 000$.

Regards, Atesz



view thread (54+ messages)  latest in thread

Message-ID: <43A84D03.7090002@ritek.hu>
Permalink:  ../43A84D03.7090002@ritek.hu/
Also on:    postgresql.org/message-id/43A84D03.7090002@ritek.hu

 · 

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: atesz@ritek.hu
  Subject: Re: What's the best hardver for PostgreSQL 8.1?
  In-Reply-To: <43A84D03.7090002@ritek.hu>

* 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