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.
- Re: [PERFORM] Partition table in 9.0.x? Jeff Janes
- Re: [PERFORM] Partition table in 9.0.x? AJ Weber
- Re: [PERFORM] Partition table in 9.0... Jeff Janes
- Re: [PERFORM] Partition table i... AJ Weber
- Re: [PERFORM] Partition tab... Jeff Janes
- Re: [PERFORM] Partition tab... Tom Lane
- Re: [PERFORM] Partition tab... AJ Weber
- Re: [PERFORM] Partition tab... Jeff Janes
- Re: [PERFORM] Simple join doesn't use index Merlin Moncure
- Re: [PERFORM] Simple join doesn't use index Jeff Janes
- Re: [PERFORM] Simple join doesn't use index Alex Vinnik
- Re: [PERFORM] Simple join doesn't use index Merlin Moncure
- Re: [PERFORM] Simple join doesn't use index Alex Vinnik
- Re: [PERFORM] Simple join doesn't use in... Filip RembiaĆkowski
- Re: [PERFORM] Simple join doesn't us... Alex Vinnik
- Re: [PERFORM] Simple join doesn... Filip RembiaĆkowski
- Re: [PERFORM] Simple join d... Dan Fairs
- Re: [PERFORM] Simple join doesn... Ben Chobot
- Re: [PERFORM] Simple join d... Alex Vinnik
- Re: [PERFORM] Simple join d... Merlin Moncure
- Re: [PERFORM] Simple join d... Alex Vinnik