Skip site navigation (1) Skip section navigation (2)

Problems with PostGreSQL and Windows 2003

From: claudia(dot)amorim(at)pcinformatica(dot)com(dot)br
To: pgsql-performance(at)postgresql(dot)org
Cc: claudiacomput(at)hotmail(dot)com
Subject: Problems with PostGreSQL and Windows 2003
Date: 2007-11-23 23:20:47
Message-ID: 50326.189.5.149.224.1195860047.squirrel@smart (view raw or flat)
Thread:
Lists: pgsql-performance
Hello,


I'm having serious peformance problems with PostGreSQL and Windows Server 2003
Enterprise Edition. The PostgreSQL Server don't starts if I set the shared
buffers high than
1GB. All my programs can use only 3 GB of RAM and I have 8GB of RAM.
When I try to execute a query in a table about 4 milion registers, my
application crashes with an error memory message.

The configuration:

PostGreSQL 8.2.5
O.S: Windows Server 2003 Enterprise Edition
     Service Pack 2

Computer:
dual quad core Intel(R) Xeon(R) CPU E5345 @ 2.33GHz
8GB of RAM
Physical Address Extension
3 HDs in RAID-5


My boot.ini:

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise"
/fastdetect /PAE   /NoExecute=OptOut /3GB


PostGreSQL.conf:


shared_buffers = 1024MB			# min 128kB or max_connections*16kB
					# (change requires restart)
temp_buffers = 32MB			# min 800kB
#max_prepared_transactions = 5		# can be 0 or more
					# (change requires restart)
# Note: increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
work_mem =512MB				# min 64kB
maintenance_work_mem = 256MB		# min 1MB
max_stack_depth = 2MB			# min 100kB

# - Free Space Map -

max_fsm_pages = 409600		# min max_fsm_relations*16, 6 bytes each
					# (change requires restart)
#max_fsm_relations = 1000		# min 100, ~70 bytes each
					# (change requires restart)



#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------


# - Checkpoints -

checkpoint_segments = 128		# in logfile segments, min 1, 16MB each
checkpoint_timeout = 15min		# range 30s-1h
checkpoint_warning = 30s		# 0 is off




#---------------------------------------------------------------------------
# QUERY TUNING
#---------------------------------------------------------------------------


effective_cache_size = 5120MB





Thanks, Cláudia.





Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2007-11-24 08:53:24
Subject: Re: Problems with PostGreSQL and Windows 2003
Previous:From: Tom LaneDate: 2007-11-23 17:41:58
Subject: Re: Performance problem with UNION ALL view and domains

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group