On Oct 20, 2014, at 5:14 AM, Anton Gorlov <stal...@altlinux.ru> wrote:
> postgresql.conf: > max_connections = 100 > shared_buffers = 128MB > temp_buffers = 512MB > work_mem = 64MB > maintenance_work_mem = 32MB > fsync = off > checkpoint_segments = 90 I’d start by bumping shared_buffers. Here’s how I solved a similar issue: https://plus.google.com/106386350930626759085/posts/AKXoRido3U1 In short: 45 minutes to insert 280,000 rows while updating 5 indexes in a 78 million row table TIme required after changing settings 3 minutes — Dan Langille
signature.asc
Description: Message signed with OpenPGP using GPGMail
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
