Re: [PERFORM] Prepared statements slow in 9.2 still (bad query plan)

2012-11-01 Thread Daniel Burbridge
been collected subj has approx 350,000 distinct values, prop 88 and obj around 150,000 Dan -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: 28 October 2012 15:06 To: Daniel Burbridge Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Prepared statements slow

[PERFORM] Prepared statements slow in 9.2 still (bad query plan)

2012-10-28 Thread Daniel Burbridge
I have a problem with prepared statements choosing a bad query plan - I was hoping that 9.2 would have eradicated the problem :( Taken from the postgresql log: <2012-10-23 15:21:03 UTC acme_metastore 13798 5086b49e.35e6> LOG: duration: 20513.809 ms execute S_6: