| From: | "Daniel J(dot) Luke" <dluke(at)geeklair(dot)net> |
|---|---|
| To: | Larry Rosenman <lrosenman(at)pervasive(dot)com> |
| Cc: | "Dave Dutcher" <dave(at)tridecap(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Getting even more insert performance (250m+rows/day) |
| Date: | 2006-05-24 20:29:25 |
| Message-ID: | 4D7AF15D-0F5D-4AAA-85F7-B06089F826B1@geeklair.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On May 24, 2006, at 4:24 PM, Larry Rosenman wrote:
> Also, is pg_xlog on the same or different spindles from the rest of
> the
> PG Data directory?
It's sitting on the same disk array (but I'm doing 1 transaction
every 5 minutes, and I'm not near the array's sustained write
capacity, so I don't think that's currently limiting performance).
--
Daniel J. Luke
+========================================================+
| *---------------- dluke(at)geeklair(dot)net ----------------* |
| *-------------- http://www.geeklair.net -------------* |
+========================================================+
| Opinions expressed are mine and do not necessarily |
| reflect the opinions of my employer. |
+========================================================+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-05-24 21:32:25 | Re: Getting even more insert performance (250m+rows/day) |
| Previous Message | Larry Rosenman | 2006-05-24 20:24:20 | Re: Getting even more insert performance (250m+rows/day) |