Re: Inserting 8MB bytea: just 25% of disk perf used?

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: <fkater(at)googlemail(dot)com>, "'Aidan Van Dyk'" <aidan(at)highrise(dot)ca>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Date: 2010-01-14 21:33:11
Message-ID: A38C3E0C3DBF441795FC63DFC0C62EF1@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----Mensaje original-----
> De: fkater(at)googlemail(dot)com

> Nevertheless: If your explanation covers all what can be said
> about it then replacing the hard disk by a faster one should
> increase the performance here (I'll try to check that out).
>

Moving the pg_xlog directory to the OS drive should make a difference and it
will cost you zero.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-01-14 21:43:29 Re: New server to improve performance on our large and busy DB - advice?
Previous Message fkater@googlemail.com 2010-01-14 21:28:07 Re: Inserting 8MB bytea: just 25% of disk perf used?