Tag Info

New answers tagged

2

1. Why Statistics IO show higher reads than Profiler? No idea, sorry. There are often differences because they are measuring different things as alluded to in the knowledge base article. There is no additional documentation on this that I am aware of. You might be able to infer some things through detailed testing, but there's really no guarantee whatever ...


1

Erwin, since this was our discussion in the comment thread from before, I decided to poke at it a little further... I have a very simple query from a reasonably sized table. I typically have sufficient work_mem, but in this case I used the commands SET work_mem = 64; to set a very small work_mem and SET work_mem = default; to set my work_mem back to ...


4

As @Chris commented correctly on the referenced question: a little investigation seems to indicate that the recheck condition is always printed in the EXPLAIN, but is actually only performed when work_mem is small enough that the bitmap becomes lossy. Thoughts? http://www.postgresql.org/message-id/464F3C5D.2000700@enterprisedb.com While this is ...



Top 50 recent answers are included