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.
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.wydd@xxxxxxx> 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.
