John A Meinel <[EMAIL PROTECTED]> writes:
> I am a little surprised that it is taking 40s to scan only 400k rows,
> though.
Yeah, that seemed high to me too. Table bloat maybe? It would be
interesting to look at the output of "vacuum verbose test" to see
how much dead space there is.
Steve Atkins wrote:
On Fri, Jun 10, 2005 at 01:45:05PM -0400, Clark Slater wrote:
Hi-
Would someone please enlighten me as
to why I'm not seeing a faster execution
time on the simple scenario below?
> [...]
>
Create an index on (productlistid, typeid, partnumber) then
select * from tes
[Kevin Grittner - Fri at 02:49:57PM -0500]
> If you add a column to the person table for "last_food_id" and triggers
> to maintain it when the food table is modified, voila! You have a
> simple and fast way to get the results you want.
Reminds me about the way the precursor software of our produc