| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, testperf-general(at)pgfoundry(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Subject: | Re: First set of OSDL Shared Mem scalability results, some wierdness ... |
| Date: | 2004-10-08 23:31:41 |
| Message-ID: | 200410081631.41545.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Tom,
> BTW, what is the actual size of the test database (disk footprint wise)
> and how much of that do you think is heavily accessed during the run?
> It's possible that the test conditions are such that adjusting
> shared_buffers isn't going to mean anything anyway.
The raw data is 32GB, but a lot of the activity is incremental, that is
inserts and updates to recent inserts. Still, according to Mark, most of
the data does get queried in the course of filling orders.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sailesh Krishnamurthy | 2004-10-08 23:53:43 | Re: APR 1.0 released |
| Previous Message | Josh Berkus | 2004-10-08 23:08:14 | Re: First set of OSDL Shared Mem scalability results, |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2004-10-09 02:10:19 | Re: First set of OSDL Shared Mem scalability results, some wierdness ... |
| Previous Message | Josh Berkus | 2004-10-08 23:08:14 | Re: First set of OSDL Shared Mem scalability results, |