| From: | "Kevin Schroeder" <kschroeder(at)mirageworks(dot)com> |
|---|---|
| To: | <pgsql-cygwin(at)postgresql(dot)org> |
| Subject: | Re: Memory allocation for postmaster service... |
| Date: | 2003-09-17 18:48:33 |
| Message-ID: | 053901c37d4c$5775f2c0$0200a8c0@WORKSTATION |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin |
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 -----
From: Mike Leahy
To: pgsql-cygwin(at)postgresql(dot)org
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Schroeder | 2003-09-17 22:09:30 | Re: Memory allocation for postmaster service... |
| Previous Message | Mike Leahy | 2003-09-17 18:44:03 | Memory allocation for postmaster service... |