...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Merlin Moncure
Sent: Monday, April 30, 2012 6:04 PM
To: Thomas Kellerer
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Tuning Postgres 9.1 on Windows
On Mon, Apr 30, 2012 at 5:00 PM, Thomas Kellerer spam_ea
On Tue, May 1, 2012 at 7:51 AM, Walker, James Les jawal...@cantor.com wrote:
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
; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Tuning Postgres 9.1 on Windows
On Tue, May 1, 2012 at 7:51 AM, Walker, James Les jawal...@cantor.com wrote:
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
On 5/1/2012 8:06 AM, Merlin Moncure wrote:
On Tue, May 1, 2012 at 7:51 AM, Walker, James Lesjawal...@cantor.com wrote:
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
On Tue, May 1, 2012 at 8:14 AM, Walker, James Les jawal...@cantor.com wrote:
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.
It looks like the ssd doesn't have a nv cache and the raid card is a
simple sas hba
Kellerer; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Tuning Postgres 9.1 on Windows
On Tue, May 1, 2012 at 8:14 AM, Walker, James Les jawal...@cantor.com wrote:
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
On Tue, May 1, 2012 at 9:44 AM, Walker, James Les jawal...@cantor.com wrote:
I installed the enterprisedb distribution and immediately saw a 400%
performance increase. Turning off fsck made it an order of magnitude better.
I'm now peaking at over 400 commits per second. Does that sound right?
Walker, James Les wrote on 01.05.2012 16:44:
I installed the enterprisedb distribution and immediately saw a 400%
performance increase.
What exactly is the enterprisedb distribution?
Are you talking about the the Advanced Server?
I would be very surprised if the code base would differ so
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
On 4/30/2012 8:49 AM, Walker, James Les wrote:
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
On Mon, Apr 30, 2012 at 8:49 AM, Walker, James Les jawal...@cantor.com wrote:
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
Merlin Moncure wrote on 30.04.2012 23:43:
Trying turning off fsync in postgrsql.conf to be sure.
This is a dangerous advise.
Turning off fsync can potentially corrupt the database in case of a system
failure (e.g. power outage).
--
Sent via pgsql-performance mailing list
On Mon, Apr 30, 2012 at 5:00 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
Merlin Moncure wrote on 30.04.2012 23:43:
Trying turning off fsync in postgrsql.conf to be sure.
This is a dangerous advise.
Turning off fsync can potentially corrupt the database in case of a system
failure (e.g.
14 matches
Mail list logo
