On Wed, Mar 18, 2015 at 12:21 PM, Steven Jones <steven.jones1201@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxxxx -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
