Re: index build faster on 8G laptop than 30G server

From: Peter Devoy <peter(at)3xe(dot)co(dot)uk>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: index build faster on 8G laptop than 30G server
Date: 2016-04-19 21:37:00
Message-ID: CABoFc_gGPs6vu4C7AkZpCVR9pLpp7LP3CYj2KV+LgMkE+8UGNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I see you are comparing 9.2 and 9.4 -- if you were not already aware
there is a kernel restriction on shared memory on Linux systems which,
if I recall correctly, must be adjusted in versions before 9.3...

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#shared_buffers

Not saying it's the answer but maybe another thing to look at...

All the best

Peter

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Ross 2016-04-19 22:01:18 Re: index build faster on 8G laptop than 30G server
Previous Message Tory M Blue 2016-04-19 21:36:31 Re: index build faster on 8G laptop than 30G server