Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow checkpoints - Mailing list pgsql-performance

From Ilya Kosmodemiansky
Subject Re: Very slow checkpoints
Date
Msg-id CAG95seXWcWx8BcN3Ee-weXKhSYPDjTT=FiRg+tMD2yZKjOxZ+g@mail.gmail.com
Whole thread Raw
In response to Very slow checkpoints  (Steven Jones <steven.jones1201@outlook.com>)
Responses Re: Very slow checkpoints  (Steven Jones <steven.jones1201@outlook.com>)
List pgsql-performance
Tree view 
On Wed, Mar 18, 2015 at 12:21 PM, Steven Jones
<steven.jones1201@outlook.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@postgresql-consulting.com

pgsql-performance by date:

Previous
From: Ilya Kosmodemiansky
Date:
Subject: Re: Very slow checkpoints
Next
From: Steven Jones
Date:
Subject: Re: Very slow checkpoints