On 4:36 pm 08/01/08 Alex Vinogradovs <AVinogradovs@xxxxxxxxxxxxxxxx> wrote: > It's not that I expect a lot of improvement by having non-WAL > indexing Have you tried using a fill factor less than 90%? That is on my list of things to test, but have not done yet.. In particular you need to find a balance where the speed gained justifies the increase in size of the index.. and the potential slowdowns because of larger indexes.
