What's size of your PostgreSQL Database?

From: "Amber" <guxiaobo1982(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What's size of your PostgreSQL Database?
Date: 2008-08-16 03:42:50
Message-ID: BLU139-DS51281C5343F36DF190DB1CD6C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-general

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!

In response to


Browse pgsql-general by date

  From Date Subject
Next Message Stefan Berglund 2008-08-16 06:30:10 Windows Installation Problem
Previous Message Tom Lane 2008-08-16 02:31:47 Re: Re: pg_restore fails on Windows