Re: What's size of your PostgreSQL Database?

From: "Amber" <guxiaobo1982(at)hotmail(dot)com>
To: "Mark Roberts" <mailing_lists(at)pandapocket(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: What's size of your PostgreSQL Database?
Date: 2008-08-21 13:51:31
Message-ID: BLU139-DS17A8977AD761BFD0695B7CD6B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Sat, 2008-08-16 at 11:42 +0800, Amber wrote:
>> Dear all:
>> We are currently considering using PostgreSQL to host a read only warehouse, we would like to get some experiences, best practices and performance metrics from the user community, following is the question list:
>> 1. What's size of your database?
>> 2. What Operating System are you using?
>> 3. What level is your RAID array?
>> 4. How many cores and memory does your server have?
>> 5. What about your performance of join operations?
>> 6. What about your performance of load operations?
>> 7. How many concurrent readers of your database, and what's the average transfer rate, suppose all readers are doing one table scaning.
>> 8. Single instance or a cluster, what cluster software are you using if you have a cluster?
>>
>> Thank you in advance!
>
> 1. 2.5-3TB, several others that are of fractional sisize.

How many CPU cores and memory does your server have :)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amber 2008-08-21 14:17:06 Re: What's size of your PostgreSQL Database?
Previous Message James Neff 2008-08-21 13:20:35 Re: function SETOF return type with variable columns?