arsham/Build a large index on postgres

Created March 4, 2016 17:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/arsham/256bb638c2d28cc61895.js"></script>
Save arsham/256bb638c2d28cc61895 to your computer and use it in GitHub Desktop.

Download ZIP

If you are going to build a large index or do some other large query that can benefit from access to more RAM, set work_mem larger for your session

Raw

Build a large index on postgres

	set work_mem = '56GB';
	commit;
	-- Do your work here.
	-- Then be a good neighbour.
	set work_mem = default;
	commit;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment