| From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
|---|---|
| To: | Thuy Nguyen <ntcacthuyvn(at)yahoo(dot)com> |
| Subject: | Re: Ask about large database? |
| Date: | 2007-01-18 08:48:53 |
| Message-ID: | 45AF3475.2030901@theendofthetunnel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 18.01.2007 09:03, Thuy Nguyen wrote:
> I am look for RDBMS solution for my web application, size of my database may be about 10GB-->500GB. How PostgreSQL work well or how must I config it?
> My application process data locally; one database has only one connection (not a server-client model).
> Please tell me your suggestions!
PostgreSQL will work just fine in that situation, though it will really
show its power when you have a large amount of concurrent connections /
transactions.
You always need to configure PostgreSQL for a given workload.
See:
http://powerpostgresql.com/PerfList
http://powerpostgresql.com/Downloads/annotated_conf_80.html
http://powerpostgresql.com/PlanStats
and related documentation.
--
Regards,
Hannes Dorbath
| From | Date | Subject | |
|---|---|---|---|
| Next Message | deepak pal | 2007-01-18 10:04:33 | how to show serial number of record |
| Previous Message | Hannes Dorbath | 2007-01-18 08:28:13 | Get SQL dump from readonly FS |