Re: index build faster on 8G laptop than 30G server - Mailing list pgsql-general

From Peter Devoy
Subject Re: index build faster on 8G laptop than 30G server
Date
Msg-id CABoFc_gGPs6vu4C7AkZpCVR9pLpp7LP3CYj2KV+LgMkE+8UGNA@mail.gmail.com
Whole thread Raw
In response to Re: index build faster on 8G laptop than 30G server  (John R Pierce <pierce@hogranch.com>)
List 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


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: index build faster on 8G laptop than 30G server
Next
From: Bill Ross
Date:
Subject: Re: index build faster on 8G laptop than 30G server