| From: | "tobbe" <tobbe(at)tripnet(dot)se> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Performance for relative large DB |
| Date: | 2005-08-23 12:14:24 |
| Message-ID: | 1124799264.282119.167760@g47g2000cwa.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi.
The company that I'm working for are surveying the djungle of DBMS
since we are due to implement the next generation of our system.
The companys buissnes is utilizing the DBMS to store data that are
accessed trough the web at daytime (only SELECTs, sometimes with joins,
etc). The data is a collection of bjects that are for sale. The data
consists of basic text information about theese togheter with some
group information, etc.
The data is updated once every night.
There are about 4 M posts in the database (one table) and is expected
to grow with atleast 50% during a reasonable long time.
How well would PostgreSQL fit our needs?
We are using Pervasive SQL today and suspect that it is much to small.
We have some problems with latency. Esp. when updating information,
complicated conditions in selects and on concurrent usage.
Best Regards
Robert Bengtsson
Project Manager
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2005-08-23 13:52:46 | Re: pgbench |
| Previous Message | John A Meinel | 2005-08-23 09:48:20 | Re: extremly low memory usage |