PostGIS vs. Shapefile

[Didrik Pinte]

Le vendredi 11 février 2005 à 10:30 +0100, Daniele Margotti a écrit :
> In /var/log I only have a 0-byte pgsql file (but in my postgresql.conf I
> didn't set any debug option...).
> 
> Inspecting top on the server (which normally is 100% idle), I can see
> that during elaboration of the map (/cgi-bin/mapserv?mode=browse)
> involved processes are "mapserv" and "postmaster", that use 100% CPU
> (sharing it in various %) for about 2 seconds.
> 
> During query, the process "postmaster" monopolizes CPU with 99.9% load,
> for many seconds, during which sometimes appear "mapserv" and "httpd"
> processes: such situation starts when I click with the mouse and ends
> when the page is completely transmitted to the browser (I can see the
> page slowly composing, as if I had a 14.4 Kbps connection, instead of
> being LAN-connected!).
> 
> With shapefile query, the page is instantaneously shown.
> 
>         Daniele

From rom my point of view, the problem can be one of the following

[1] The query in Pg returns a lot of objects (maybe not drawn) so that
the image creation is slow.

[2] You need to increase the memory (shared_buffers, sort_mem) --> see
how to tune postgres.

Didrik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Ceci est une partie de message
	=?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?=
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050211/1c55f0be/attachment.bin