Re: Large number of tables slow insert

Just a guess, but have you tried increasing max_fsm_relations ? This
probably shouldn't matter but you'll want this to be larger than the sum of
all your tables and indexes and it doesn't take that much memory to increase
it.

My next suggestion would be to log in as the superuser and 'vacuum analyze'
the system tables. Perhaps it is simply the system table access that has
gotten inefficient with this many tables / indexes.

On Sat, Aug 23, 2008 at 6:48 PM, Loic Petit <tls(dot)wydd(at)free(dot)fr> wrote:

> What I described in the last mail is what I try to do.
> But I said earlier that I only do about 3-4 inserts / seconds because of my
> problem.
> So it's about one insert each 30 minutes for each table.
>