Oh - this is with a seperate transaction per command. fsync is on.
Alex Turner netEconomist On Apr 1, 2005 4:17 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > 1250/sec with record size average is 26 bytes > 800/sec with record size average is 48 bytes. > 250/sec with record size average is 618 bytes. > > Data from pg_stats and our own job monitoring > > System has four partitions, two raid 1s, a four disk RAID 10 and a six > disk RAID 10. > pg_xlog is on four disk RAID 10, database is on RAID 10. > > Data is very spread out because database turnover time is very high, > so our performance is about double this with a fresh DB. (the data > half life is probably measurable in days or weeks). > > Alex Turner > netEconomist > > On Apr 1, 2005 1:06 PM, Marc G. Fournier <[EMAIL PROTECTED]> wrote: > > > > Just curious, but does anyone have an idea of what we are capable of? I > > realize that size of record would affect things, as well as hardware, but > > if anyone has some ideas on max, with 'record size', that would be > > appreciated ... > > > > Thanks ... > > > > ---- > > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > > Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: > > 7615664 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 8: explain analyze is your friend > > > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
