Postgres Pro
Downloads
Home   >   mailing lists

Re: Memory allocation for postmaster service... - Mailing list pgsql-cygwin

From Kevin Schroeder
Subject Re: Memory allocation for postmaster service...
Date
Msg-id 053901c37d4c$5775f2c0$0200a8c0@WORKSTATION
Whole thread Raw
In response to Memory allocation for postmaster service...  ("Mike Leahy" <mgleahy@fes.uwaterloo.ca>)
List pgsql-cygwin
Tree view
Memory allocation could be the issue, but first try looking at your indexes.  That almost always solves any speed issues for me.  If you haven't yet, try EXPLAIN ANALYZE.
 
Kevin
----- Original Message -----
Sent: Wednesday, September 17, 2003 1:44 PM
Subject: [CYGWIN] Memory allocation for postmaster service...

I’m just wondering if it’s possible to increase the allocation of memory to the postmaster service.  I’m running PosgreSQL with PostGIS, and sometimes running a map query on multiple objects from Mapserver can take a very long time with the CPU running at 100%.  I’m hoping increasing the memory allocation would improve the performance...

 

Kind regards,

Mike

pgsql-cygwin by date:

Previous
From: "Mike Leahy"
Date:
Subject: Memory allocation for postmaster service...
Next
From: "John Pagakis"
Date:
Subject: Re: Problem with stopping postmaster with pg_ctl