Re: [PERFORM] Tuning Postgres 9.1 on Windows

2012-04-30 Thread Merlin Moncure
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

Re: [PERFORM] Tuning Postgres 9.1 on Windows

2012-04-30 Thread Thomas Kellerer
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

Re: [PERFORM] Tuning Postgres 9.1 on Windows

2012-04-30 Thread Merlin Moncure
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

Re: [PERFORM] Tuning Postgres 9.1 on Windows

2012-04-30 Thread Andy Colson
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/

[PERFORM] Tuning Postgres 9.1 on Windows

2012-04-30 Thread Walker, James Les
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