@postgresql.org
[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 i
Of 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
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 mu
On Tue, May 1, 2012 at 9:44 AM, Walker, James Les 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?
yeah -- well it
Les
Cc: Thomas 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 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
On Tue, May 1, 2012 at 8:14 AM, Walker, James Les 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 (which likely isn't doi
On 5/1/2012 8:06 AM, Merlin Moncure wrote:
On Tue, May 1, 2012 at 7:51 AM, Walker, James Les 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* dange
lerer; 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 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 alr
On Tue, May 1, 2012 at 7:51 AM, Walker, James Les 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 have any effect.
ce-ow...@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
On Mon, Apr 30, 2012 at 5:00 PM, Thomas Kellerer 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. power outag
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 (pgsql-performan
On Mon, Apr 30, 2012 at 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 dire
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 6Gb/
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 a
15 matches
Mail list logo
