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 14:17:06 |
Message-ID: | BLU139-DS2428650C04752BE87CE8DCD6B0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Another question, how many people are there maintaining this huge database.
We have about 2T of compressed SAS datasets, and now considering load them into a RDBMS database,
according to your experience, it seems a single PostgreSQL instance can't manage such size databases well, it that right?
--------------------------------------------------
From: "Amber" <guxiaobo1982(at)hotmail(dot)com>
Sent: Thursday, August 21, 2008 9:51 PM
To: "Mark Roberts" <mailing_lists(at)pandapocket(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] What's size of your PostgreSQL Database?
>
>
>> 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 :)
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2008-08-21 16:18:42 | psql \df+ [pattern] with overloaded functions |
Previous Message | Amber | 2008-08-21 13:51:31 | Re: What's size of your PostgreSQL Database? |