| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Orhan Aglagul <oaglagul(at)cittio(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2007-05-09 00:30:42 |
| Message-ID: | 1178670642.7497.45.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2007-05-08 at 17:59, Orhan Aglagul wrote:
> Hi Everybody,
>
> I was trying to see how many inserts per seconds my application could
> handle on various machines.
>
> Here is the data:
>
>
>
> Time for 10000 inserts
>
> Fsync=on
>
> Fsync=off
>
> Pentium M 1.7
>
> ~17 sec
>
> ~6 sec
>
> Pentium 4 2.4
>
> ~13 sec
>
> ~11 sec
>
> Dual Xeon
>
> ~65 sec
>
> ~1.9 sec
>
>
>
In addition to my previous post, if you see that big a change between
fsync on and off, you likely have a drive subsystem that is actually
reporting fsync properly.
The other two machines are lying. Or they have a battery backed caching
raid controller
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Orhan Aglagul | 2007-05-09 01:12:16 | Re: |
| Previous Message | Scott Marlowe | 2007-05-09 00:22:45 | Re: |