Martin, Can you please re-run the query but instead of using VALUES(x), can you alter the array to have an UNNEST clause :
select mm.uid, mm.modseq, mm.message from mailbox_messages mm where
mm.mailbox=441 and not mm.deleted and mm.uid=any(unnest('{...}'))
Please tell me the performance/query plan on this compared with the
original and with your VALUES() version.
Thanks
Jim
