Re: [PERFORM] Slow Query

2015-08-12 Thread Vik Fearing
", > "Vacancy"."DateCreated", "Vacancy"."CustomAccess" > , "Department"."Name" as "Department", list("Occupation"."Name") as > "Occupation", "Vacancy"."PositionNo&q

Re: [PERFORM] subselect requires offset 0 for good performance.

2013-08-08 Thread Vik Fearing
On 08/02/2013 09:37 AM, Vik Fearing wrote: > EXPLAIN ANALYZE > WITH RECURSIVE > x (start_time) AS > ( > SELECT generate_series(1, 100) > ), > t (time, timeround) AS > ( > SELECT time, time - time % 90 AS timeround > FROM (SELECT min(star

Re: [PERFORM] subselect requires offset 0 for good performance.

2013-08-02 Thread Vik Fearing
On 08/02/2013 03:22 AM, Scott Marlowe wrote: > On Thu, Aug 1, 2013 at 5:44 PM, Tom Lane wrote: >> Scott Marlowe writes: >>> I am running 8.4.15 and can try 8.4.17 if some patch has been applied >>> to it to address this issue. I just want to know should I >>> A: upgrade to 8.4.17 >>> or >>> B: cr