On Oct 20, 2014, at 5:14 AM, Anton Gorlov <[email protected]> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
