Doug,
This thread really should be moved to pgsql-performance mailing list. Thanks,
and good luck tuning Windows.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an app
We tried reducing the memory footprint of the postgres processes, via
shared_buffers (from 3 on Linux to 3000 on Windows), max_fsm_pages
(from 2000250 on Linux to 10 on Windows), max_fsm_relations (from
2 on Linux to 5000 on Windows), and max_connections (from 222 on
Linux to 100 on Win
Doug Knight wrote:
We are running the binary distribution, version 8.2.5-1, installed on
Windows XP Pro 32 bit with SP2. We typically run postgres on linux,
but have a need to run it under windows as well. Our typical admin
tuning for postgresql.conf doesn't seem to be as applicable for windows
We are running the binary distribution, version 8.2.5-1, installed on
Windows XP Pro 32 bit with SP2. We typically run postgres on linux, but
have a need to run it under windows as well. Our typical admin tuning
for postgresql.conf doesn't seem to be as applicable for windows.
Doug
On Sun, 2008-0
On Jan 3, 2008 8:57 PM, Doug Knight <[EMAIL PROTECTED]> wrote:
> All,
> Is there a place where I can find information about tuning postgresql
> running on a Windows XP Pro 32 bit system? I installed using the binary
> installer. I am seeing a high page fault delta and total page faults for one
>
All,
Is there a place where I can find information about tuning postgresql
running on a Windows XP Pro 32 bit system? I installed using the binary
installer. I am seeing a high page fault delta and total page faults for
one of the postgresql processes. Any help would be great.
Doug Knight
WSI Corp