X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id ADEB39DC8AC for ; Tue, 20 Dec 2005 14:26:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31024-01 for ; Tue, 20 Dec 2005 14:26:21 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 21C559DC812 for ; Tue, 20 Dec 2005 14:26:20 -0400 (AST) Received: from mail.ritek.hu (82-131-192-50.vnet.hu [82.131.192.50]) by svr4.postgresql.org (Postfix) with ESMTP id 9E9005AF09C for ; Tue, 20 Dec 2005 18:26:20 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.ritek.hu (Postfix) with ESMTP id A5F1019C147 for ; Tue, 20 Dec 2005 19:26:14 +0100 (CET) Received: from mail.ritek.hu ([127.0.0.1]) by localhost (mail.ritek.hu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25662-10 for ; Tue, 20 Dec 2005 19:26:13 +0100 (CET) Received: from [10.1.2.11] (unknown [10.1.2.11]) by mail.ritek.hu (Postfix) with ESMTP id 4F4C819C143 for ; Tue, 20 Dec 2005 19:26:13 +0100 (CET) Message-ID: <43A84D03.7090002@ritek.hu> Date: Tue, 20 Dec 2005 19:27:15 +0100 From: Antal Attila User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: hu-hu, hu, en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: What's the best hardver for PostgreSQL 8.1? Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ritek.hu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/503 X-Sequence-Number: 16324 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