log_statement_stats to see what it was doing.
This was on a table of roughly 600MB where the domains were randomly
dispersed.
Cheers
Bryce
Tom Lane wrote:
Bryce Ewing writes:
So it seems to me that once the index is in memory everything is fine
with the world, but the loading of the index into
and outer joins from being rearranged ... but if that applies
here, it would also prevent manual rearrangement, unless the OP decides
that this query doesn't express quite what he meant.
regards, tom lane
--
*Bryce Ewing *| Platform Architect
*DDI:* +64 9 950 21
Hi,
I have been trying to fix a performance issue that we have which I have
tracked down to index scans being done on a particular table (or set of
tables):
The following query:
explain analyze select *
FROM inbound.event_20090526 e
LEFT OUTER JOIN inbound.internal_host i ON (e.mta_host_id =
