Re: Performance degradation of inserts when database size grows

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Andrey Vorobiev <andrey(dot)o(dot)vorobiev(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance degradation of inserts when database size grows
Date: 2011-05-22 06:38:20
Message-ID: 163903.24886.qm@web29019.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>1. How does database size affect insert performance?
>2. Why does number of written buffers increase when database size grows?

It might be related to indexes. Indexes size affect insert performance.

>3. How can I further analyze this problem?

Try without indexes?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nick Raj 2011-05-22 11:43:44 Logfile
Previous Message Aren Cambre 2011-05-22 03:32:30 Re: Postgres refusing to use >1 core