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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
Description: Digital signature
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
