[PERFORM] how to tune this query.

ified_Date = g.p_LastModified))   -- Luckys

Re: [PERFORM] slow cursor

This is one thing that I always try to avoid, a single INSERT INTO...SELECT ...FROM or single UPDATE is always faster compared to looping the same within a cursor, unless its inevitable.   regards, Luckys.  On 4/17/06, Sriram Dandapani <[EMAIL PROTECTED]> wrote: Hi   I have a curso

Re: [PERFORM]

It'd be helpful if posted with the EXPLAIN of the slow running queries on the respective table.   cool. L.   On 4/9/06, Doron Baranes <[EMAIL PROTECTED]> wrote: Hi   I am new at postgres and I'm having performance issues. I am running on postgres 7.4.6 on a pineapp with 512MB RAM. I did a databa