Exactly, if turning off fsync gives me 100 commits/sec then I know where my
bottleneck is and I can attack it. Keep in mind though that I already turned
off synchronous commit -- *really* dangerous -- and it didn't have any effect.
-- Les
-Original Message-
From:
SSD is OCZ-VERTEX3 MI. Controller is LSI SAS2 2008 Falcon. I'm working on
installing EDB. Then I can give you some I/O numbers.
-- Les
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Tuesday, May 01, 2012 9:07 AM
To: Walker, James Les
Cc: Thomas Kellerer
to
need a controller that can defer fsync requests from the host because it has
some sort of battery backup that guarantees the full write.
-- Les
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Tuesday, May 01, 2012 9:43 AM
To: Walker, James Les
Cc: Thomas
Kellerer
Sent: Tuesday, May 01, 2012 1:00 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Tuning Postgres 9.1 on Windows
Walker, James Les wrote on 01.05.2012 16:44:
I installed the enterprisedb distribution and immediately saw a 400%
performance increase.
What exactly
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Walker, James Les
Sent: Tuesday, May 01, 2012 3:14 PM
To: 'Thomas Kellerer'; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Tuning Postgres 9.1 on Windows
Yes. I didn't know the proper vernacular :-)
It is very likely that the default
I'm trying to benchmark Postgres vs. several other databases on my workstation.
My workstation is running 64 bit Windows 7. It has 12 gb of RAM and a W3550 @ 3
Ghz. I installed Postgres 9.1 using the windows installer. The data directory
is on a 6Gb/s SATA SSD.
My application is multithreaded