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
= 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
... 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
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
