Re: [PERFORM] Hints (was Poor performance using CTE)

2012-12-03 Thread Gavin Flower
On 28/11/12 15:17, Craig Ringer wrote: On 27/11/2012 3:42 PM, Scott Marlowe wrote: Here here! PostgreSQL is well known for its extensibility and this is the perfect place for hints. I agree with the sentiment and your concerns. However, this doesn't solve the CTE problem. Some people are re

Re: [PERFORM] Optimize update query

2012-12-03 Thread Niels Kristian Schjødt
Den 30/11/2012 kl. 17.06 skrev Shaun Thomas : > On 11/30/2012 09:44 AM, Niels Kristian Schjødt wrote: > > Just a note on your iostat numbers. The first reading is actually just a > summary. You want the subsequent readings. > >> The pgsql_tmp dir is not changing at all it's constantly empty (a