Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3AF582E003C for ; Fri, 23 Nov 2007 19:21:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65306-05 for ; Fri, 23 Nov 2007 19:20:38 -0400 (AST) Received: from pcinformatica.com.br (ns2.pcinformatica.com.br [201.24.152.2]) by postgresql.org (Postfix) with ESMTP id DBBBF2E003B for ; Fri, 23 Nov 2007 19:20:51 -0400 (AST) Received: (qmail 11814 invoked by uid 88); 23 Nov 2007 23:20:47 -0000 Received: from 127.0.0.1 by smart (envelope-from , uid 89) with qmail-scanner-1.25 (uvscan: v4.4.00/v4400. Clear:RC:1(127.0.0.1):. Processed in 0.41251 secs); 23 Nov 2007 23:20:47 -0000 X-Qmail-Scanner-Mail-From: claudia.amorim@pcinformatica.com.br via smart X-Qmail-Scanner: 1.25 (Clear:RC:1(127.0.0.1):. Processed in 0.41251 secs) X-Qmail-Util: Version 0.6.3 Received: from unknown (HELO 201.24.152.6) (127.0.0.1) by 0 with SMTP; 23 Nov 2007 23:20:47 -0000 Received: from 189.5.149.224 (SquirrelMail authenticated user claudia.amorim@pcinformatica.com.br) by smart with HTTP; Fri, 23 Nov 2007 21:20:47 -0200 (BRST) Message-ID: <50326.189.5.149.224.1195860047.squirrel@smart> Date: Fri, 23 Nov 2007 21:20:47 -0200 (BRST) Subject: Problems with PostGreSQL and Windows 2003 From: claudia.amorim@pcinformatica.com.br To: pgsql-performance@postgresql.org Cc: claudiacomput@hotmail.com User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.126 tagged_above=0 required=5 tests=AWL=-0.942, BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: * X-Archive-Number: 200711/282 X-Sequence-Number: 27697 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.