On Oct 20, 2014, at 5:14 AM, Anton Gorlov <stalker AT altlinux DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users