May be I should first try to partition the table by date and see if that helps.
Thanks, - Gummi On Thu, Feb 2, 2012 at 8:30 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Thu, Feb 2, 2012 at 10:41 AM, Gudmundur Johannesson > <gudmundur.johannes...@gmail.com> wrote: > > Do you think I should try using the latest build of the source for 9.2 > since > > index-only-scan is "ready" according to > > > http://www.depesz.com/index.php/2011/10/08/waiting-for-9-2-index-only-scans/ > > ? > > hm, interesting. > > You are simply welcome to try that and we would definitely like to see > your results. I looked around and didn't see any binaries for the > development snapshots for windows to test. That means you have to > compile postgres in order to test 9.2 at this point in time. Testing > and feedback of index only scan feature would be very much > appreciated. > > Generally speaking, postgresql source tree is very high quality -- > stuff should mostly work. The biggest annoyance is that you get lots > of catalog version bumps when pulling new versions of the sources > forcing a dump/reload. > > merlin >
