Re: Large number of tables slow insert

On Sat, Aug 23, 2008 at 6:09 PM, <tls(dot)wydd(at)free(dot)fr> wrote:
> On this smaller test, the indexes are over the allowed memory size (I've got
> over 400.000 readings per sensor) so they are mostly written in disk.

They're always written to disk. Just sometimes they're not read.
Note that the OS caches files as well as pgsql, and I'm not sure what
you mean by "allowed memory size" but only the shared_buffers would
hold onto something after it's been operated on. work_mem won't.

> And on the
> big test, I had small indexes (< page_size) because I only had about 5-10 rows
> per table, thus it was 3000*8kb = 24mb which is lower than the allowed memory.

> btw which is the conf parameter that contains the previously read indexes ?

Not sure what you're asking. It's all automatic as far as OS and
postgresql caching goes.