Re: [HACKERS] suggestion to improve planer

2009-09-09 Thread Ľubomír Varga
On Wednesday 09 September 2009 14:11:41 Peter Eisentraut wrote: > On Thu, 2009-09-03 at 10:35 +0200, Ľubomír Varga wrote: > > Hi. > > > > I hope, that this is right mailing list. > > > > SELECT date, value FROM t_event > > WHERE t_event.id in (SELECT id FROM t_event > > WHERE date <

Re: [HACKERS] suggestion to improve planer

2009-09-09 Thread Peter Eisentraut
On Thu, 2009-09-03 at 10:35 +0200, Ľubomír Varga wrote: > Hi. > > I hope, that this is right mailing list. > > SELECT date, value FROM t_event > WHERE t_event.id in (SELECT id FROM t_event > WHERE date < '2009-08-25' > ORDER BY date DESC LIMIT 1) > ORDER BY

[HACKERS] suggestion to improve planer

2009-09-03 Thread Ľubomír Varga
Hi. I hope, that this is right mailing list. SELECT date, value FROM t_event WHERE t_event.id in (SELECT id FROM t_event WHERE date < '2009-08-25' ORDER BY date DESC LIMIT 1) ORDER BY date; cost 6.4 SELECT date, value FROM t_event WHERE t_e