| From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | new monster box CONF suggestion please |
| Date: | 2003-06-12 16:33:34 |
| Message-ID: | OF46F244F1.BEAE0DC8-ON88256D43.0056FD70-88256D43.005B76A1@fds.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Howdy folks. We just received an new monster box, and I would like to
field suggestion on setting up the Conf file for the best performance
**************BOX INFO***************
Compaq
2 x 2GHZ XEON processors
7 gigs RAM
100 gigs HD
*****************************************
**********Expected number of Users and connection type:
200 users with 80% connection via VB front end. 20% Web (PHP)
**********Dbase Usage:
This is a mostly a reporting database, so there will be heavy usage of
aggregates (sum,avg, etc)
*********Data Loading
95% of database is truncated and refreshed nightly from mulitple
datasources.
I have a concern with one particular summary table that takes 20 mins to do
an insert/update from 4 individual talbes on our curent system.
Not sure what other infomation I should provide.
TIA
-patrick
Patrick Hatcher
Macys.Com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2003-06-13 03:49:34 | Adjusting fsm values was Re: [BUGS] db growing out of proportion |
| Previous Message | Andreas Kostyrka | 2003-06-12 09:32:09 | Re: Table Relationships |