[OSM-talk] Database server running out of memory (Was: Platform performance update & pladge)

[Petter Reinholdtsen]

[Andy Robinson]
> The database server is for some unknown reason running out of memory
> (I think it has 1GB physical). This causes the machine to swap using
> the hard drive which of course significantly affects performance.

This reminds me of a problem I ran into with the perl driver for
postgresql.  It was implemented to download the entire result of a
select statement before returning it to the perl program, and when I
tried to extract a list of GPS points for a 1 GiB database, the
machine naturally started trashing.  Could it be a similar problem
with the driver used by client programs on the server?

I solved my problem by changing the SQL calls to use a cursor and thus
only fetch a few rows at the time into the perl driver.

Friendly,
-- 
Petter Reinholdtsen