Re: [PERFORM] Large number of tables slow insert

2008-08-23 Thread DiezelMax
Each INDEX create a delay on INSERT. Try to measure performance w/o any indexes. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Large number of tables slow insert

2008-08-24 Thread DiezelMax
Does all INSERTs are made by one application? Maybe PREPARED STATEMENTS will help you? What about optimization on application level? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-perfor