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