[rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)

[Vivek Khera]

>>>>> "JH" == Justin Hawkins <justin at internode.com.au> writes:

JH> Postgres doesn't actually seem to think this is a particularly
JH> stressful query:

JH> Limit  (cost=531.38..531.45 rows=1 width=212)

JH> But it is - execution time is: 47218.74 ms !!!

 [...]

JH> If I alter the above query to say (main.Status = 'open') instead of
JH> 'new' OR 'open', the query drops to about 125ms :-)

Since the quantity of data has changed drastically, have you
re-computed the analyzer stats by running "vacuum analyze" on your
database?  What is the execution plan from postgres for the above
queries (both before and after "analyze")?