[GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb

2010-06-07 Thread Amber
Hi , The installer has an error dealing with directory separator char on windows platform, it seems the installer causes the server looking for configuration file path with /, it should be \. Hoping Enterprisedb engineers can see this message.

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
8. We have a master and a replica. We have plans to move to a cluster/grid Soon(TM). It's not an emergency and Postgres can easily handle and scale to a 3TB database on reasonable hardware ($30k). I'd like to know what's your progress of choosing the cluster/grid solution, we are also

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
Yahoo has a 2PB Postgres single instance Postgres database (modified engine), but the biggest pure Pg single instance I've heard of is 4TB. The 4TB database has the additional interesting property in that they've done none of the standard scalable architecture changes (such as partitioning,

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-09-10 Thread Amber
: Joshua Drake [EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 11:27 PM To: Amber [EMAIL PROTECTED] Cc: Mark Roberts [EMAIL PROTECTED]; pgsql-general@postgresql.org Subject: Re: [GENERAL] What's size of your PostgreSQL Database? On Wed, 10 Sep 2008 23:17:40 +0800 Amber [EMAIL PROTECTED] wrote

[GENERAL] PostgreSQL TPC-H test result?

2008-09-09 Thread Amber
I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html saying that PostgreSQL can't give the correct result of the some TPC-H queries, I wonder is there any official statements about this, because it will affect our plane of using PostgreSQL as an

Re: [GENERAL] PostgreSQL TPC-H test result?

2008-09-09 Thread Amber
@postgresql.org Subject: Re: [GENERAL] PostgreSQL TPC-H test result? On Tue, Sep 09, 2008 at 07:59:49PM +0800, Amber wrote: I read something from http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/TPCH/index.html Given that the point of that study is to prove something about performance

[GENERAL] PostgreSQL process architecture question.

2008-09-09 Thread Amber
We know PostgreSQL uses one dedicated server process to serve one client connection, what we want to know is whether PostgreSQL use multiple threads inside agents processes to take advantage of multiple CPUs. In our site we have only a few concurrent connections, so what occurs inside agent

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-08-21 Thread Amber
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

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-08-21 Thread Amber
? -- From: Amber [EMAIL PROTECTED] Sent: Thursday, August 21, 2008 9:51 PM To: Mark Roberts [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] What's size of your PostgreSQL Database? On Sat, 2008-08-16 at 11:42 +0800

Re: [GENERAL] What's size of your PostgreSQL Database?

2008-08-17 Thread Amber
7. How many concurrent readers of your database, and what's the average transfer rate, suppose all readers are doing one table scaning. Concurrent but idle connections in production are around 600. Active connections at a time are in the dozens. I can read at about 60 to 70 Megs a second

[GENERAL] What's size of your PostgreSQL Database?

2008-08-15 Thread Amber
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