I'm also wondering if a re-clustering of the table would work based on
the index that's used.
such that:
CLUSTER core_object USING plugins_plugin_addr_oid_id;
and see if that makes any change in the differences that your seeing.
On 04/13/2010 02:24 PM, Kevin Grittner wrote:
> norn wrote:
>
>
27;some_table';
tablename | attname | n_distinct
---+--+
some_table | some_time | -0.24305
So the column is very distinct (assuming that's what a negative number
means). What I'm looking for is any form of explaination that might
At 01:46 PM 7/13/03 -0700, Steve Wampler wrote:
The following left join should work if I've done my select right, you
might want to play with a left versus right to see which will give you a
better result, but this query should help:
SELECT * FROM attributes_table att LEFT JOIN attributes at
At 11:31 PM 7/13/03 -0300, Chris Bowlby wrote:
Woops, this might not go through via the address I used :> (not
subscribed with that address)..
At 01:46 PM 7/13/03 -0700, Steve Wampler wrote:
The following left join should work if I've done my select right, you
might want to play wit
S.
Be careful here, we've seen that with the P4 Xeon's that are
hyper-threaded and a system that has very high disk I/O causes the
system to be sluggish and slow. But after disabling the hyper-threading
itself, our system flew..
--
Chris Bowlby <[EMAIL PROTECTED]>
Hub.Org N