Re: Very slow checkpoints

From: Ilya Kosmodemiansky <ilya(dot)kosmodemiansky(at)postgresql-consulting(dot)com>
To: Steven Jones <steven(dot)jones1201(at)outlook(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Very slow checkpoints
Date: 2015-03-18 12:17:14
Message-ID: CAG95seXWcWx8BcN3Ee-weXKhSYPDjTT=FiRg+tMD2yZKjOxZ+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Mar 18, 2015 at 12:21 PM, Steven Jones
<steven(dot)jones1201(at)outlook(dot)com> wrote:
> - typical DW - relatively constant periodic data loads - i.e. heavy write
> - we receive large CSV files ~ 5-10Gb every 15 minutes spread out across
> 5-7 minutes
> - DB size is ~2.5Tb; rotating load of 30 days keeps the database stable

And an important addition: how your autovacuum is configured?

--
Ilya Kosmodemiansky,

PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik(at)postgresql-consulting(dot)com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steven Jones 2015-03-18 12:19:09 Re: Very slow checkpoints
Previous Message Ilya Kosmodemiansky 2015-03-18 12:13:36 Re: Very slow checkpoints