On Wed, Jan 9, 2013 at 9:49 AM, Alex Vinnik <alvinnik.g@xxxxxxxxx> wrote: > Guys, thanks a lot for your input. It is very valuable for us. We plan to > fix a separate dev server similar to production one, copy all data there and > try you suggestions as we really don't want to do it on production server. I > also noticed that IOPS jumps to 100% when running this query. So it is a bit > scary to make those changes in production directly. Will report back on the > progress and findings. nothing wrong with that, but keep in mind you can tweak 'effective_cache_size' for a single session with 'set' command; merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
