postgres on Windows - Mailing list pgsql-admin

From Mark Steben
Subject postgres on Windows
Date
Msg-id 20091228194218.069BF63292E@mail.postgresql.org
Whole thread Raw
Responses Re: postgres on Windows  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin

Our 8.3.7 production environment is run on Linux operating systems.  We do, however

Have our developers who keep a local copy of the database on their windows XP machines.

One such developer has asked my help in configuring postgresql.conf to optimize his performance.

 

The 8.3 documentation is very informative about setting Linux SYS 5 parameters and

giving insight to postgres memory consumption parms.  I can’t seem to find a lot of guidelines

for Windows performance.

 

The developer has 3 GB of ram and 130 GB hard drive.  Any insight, guidelines,

Or any reference I can be pointed to would be most appreciated.

 

Thank you,

 

 

 

Mark StebenDatabase Administrator

@utoRevenue®-"Join the Revenue-tion"
95 Ashley Ave., West Springfield, Ma
413-243-4800 x1512 (Phone) 
│ 413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises

 

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Database performance problems
Next
From: Scott Marlowe
Date:
Subject: Re: Database performance problems