Dan Harris wrote: > > On Jul 14, 2005, at 9:42 AM, John A Meinel wrote:
... Did you try doing this to see how good the planners selectivity estimates are? >> Well, postgres is estimating around 500 rows each, is that way off? Try >> just doing: >> EXPLAIN ANALYZE SELECT incidentid FROM k_b WHERE id = 107; >> EXPLAIN ANALYZE SELECT incidentid FROM k_r WHERE id = 94; These should be fast queries. John =:->
signature.asc
Description: OpenPGP digital signature
