[Tilesathome] Using RAM-drive for ROMA temp tables

[Florian Lohoff]

On Sat, Dec 06, 2008 at 09:19:30AM +0100, Mathieu Arnold wrote:
> Subject: Re: [Tilesathome] Using RAM-drive for ROMA temp tables
> 
> +--On 6 décembre 2008 08:39:54 +0100 Florian Lohoff <flo at rfc822.org> wrote:
> | So you think there are z12 tiles whose binary table content has more
> | than 128M ? I dont think so - IIRC the largest xml of that binary i saw
> | was ~40MByte and the binary would most likely not exceed 4MByte for
> | that.
> 
> I don't think there are, when my temp_buffers was at 128M, the bigest
> postgresql process was about 250MB, with 384M, it's around 310MB, thus, I
> infered that it needed some more memory.

The more memory you give postgres the more it will use :) At least as
long as the working set is larger than the memory you'll give postgres.
But in the end all tuning advisorys talk about it not beeing necessarily
a good idea to give tons of memory to postgres as the kernel might be
more efficient in caching disk blocks.

Flo
-- 
Florian Lohoff                  flo at rfc822.org             +49-171-2280134
	Those who would give up a little freedom to get a little 
          security shall soon have neither - Benjamin Franklin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20081206/a5fc095d/attachment.pgp>