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" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2008 9:51 PM To: "Mark Roberts" <[EMAIL PROTECTED]> Cc: <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
