Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance degradation of inserts when database size grows - Mailing list pgsql-performance

From Leonardo Francalanci
Subject Re: Performance degradation of inserts when database size grows
Date
Msg-id 163903.24886.qm@web29019.mail.ird.yahoo.com
Whole thread Raw
In response to Performance degradation of inserts when database size grows  (Andrey Vorobiev <andrey.o.vorobiev@gmail.com>)
List pgsql-performance
Tree view 

>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?

pgsql-performance by date:

Previous
From: Aren Cambre
Date:
Subject: Re: Postgres refusing to use >1 core
Next
From: Aren Cambre
Date:
Subject: Re: Postgres refusing to use >1 core