should force a
vacuum and analyze if the insert batch is large.
HTH,
Shrirang Chitnis
The information contained in this message, including any attachments, is
attorney privileged and/or confidential information intended only for the use
of the individual or entity named as addressee. The
= 392210)
but second query has context.parent_key
WHERE (contexts.parent_key = 392210 OR contexts.parent_key IN
(392210,392210,395073,1304250))
Is the contexts.context_key an indexed field? contexts.parent_key certainly
seems to be.
HTH,
Shrirang Chitnis
Sr. Manager, Applications Development
that, please post the EXPLAIN ANALYZE
for the query.
Thanks,
Shrirang Chitnis
Sr. Manager, Applications Development
HOV Services
Office: (866) 808-0935 Ext: 39210
shrirang.chit...@hovservices.com
www.hovservices.com
The information contained in this message, including any attachments, is
attorney
... and of course proper configuration of autovacuum. I have
seen query results within a few ms. on similar amount of data on a 2GB RHEL
RAID 5 system, so it should not have been an issue.
HTH,
Shrirang Chitnis
