| From: | "Harvey, Allan AC" <HarveyA(at)OneSteel(dot)com> |
|---|---|
| To: | "Tim Perrett" <hello(at)timperrett(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PGSQL with high number of database rows? |
| Date: | 2007-04-03 23:09:06 |
| Message-ID: | E97A5BB7699CAD48BE2711E712471165536AE0@ntlmsg03.onesteel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tim,
> massive, around 20,000 new rows in one of the tables per day.
As an example...
I'm doing about 4000 inserts spread across about 1800 tables per minute.
Pisses it in with fsync off and the PC ( IBM x3650 1 CPU, 1 Gig memory ) on a UPS.
Allan
The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Gerhardt | 2007-04-03 23:22:24 | Re: UPDATE on two large datasets is very slow |
| Previous Message | Steve Gerhardt | 2007-04-03 23:06:06 | Re: UPDATE on two large datasets is very slow |