| From: | Pierre Frédéric Caillaud <lists(at)peufeu(dot)com> |
|---|---|
| To: | "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Inserting 8MB bytea: just 25% of disk perf used? |
| Date: | 2010-01-14 23:19:56 |
| Message-ID: | op.u6jpripycke6l8@soyouz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 14 Jan 2010 22:28:07 +0100, fkater(at)googlemail(dot)com
<fkater(at)googlemail(dot)com> wrote:
> Pierre Frédéric Caillaud:
>
>> > 4 Core CPU 3 Ghz, WinXP, 1 TB SATA disk.
>>
>> Big CPU and slow disk...
>>
>> You should add another disk just for the WAL -- disks are pretty cheap
>> these days.
>> Writing the WAL on a second disk is the first thing to do on a
>> configuration like yours, if you are limited by writes.
>> It also reduces the fsync lag a lot since the disk is only doing WAL.
>
> Good idea -- where can I set the path to WAL?
At install, or use a symlink (they exist on windows too !...)
http://stackoverflow.com/questions/1901405/postgresql-wal-on-windows
I've no idea of the other needed NTFS tweaks, like if there is a
noatime/nodiratime ?...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2010-01-15 00:46:09 | Re: New server to improve performance on our large and busy DB - advice? (v2) |
| Previous Message | Dave Crooke | 2010-01-14 22:35:53 | Re: New server to improve performance on our large and busy DB - advice? (v2) |