On Tue, May 17, 2011 at 8:45 AM, Andrey Vorobiev <andrey.o.vorobiev@xxxxxxxxx> wrote: > 1. How does database size affect insert performance? Well, if your database gets bigger, then your indexes will become deeper, requiring more time to update. But I'm not sure that's your problem here. > 2. Why does number of written buffers increase when database size grows? It normally doesn't. > 3. How can I further analyze this problem? Are you actually inserting more user data into these tables, so that they have more and more rows as time goes by, or are the data files getting larger out of proportion to the amount of useful data in them? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
