> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general