Re: planner chooses unoptimal plan on joins with complex key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dmitry,

On Jan 23, 2008 2:48 PM, Dmitry Potapov <fortune.fish@xxxxxxxxx> wrote:
> EXPLAIN ANALYZE SELECT * FROM t1t2_view ORDER BY time_stamp ASC LIMIT 100:
>
> Limit  (cost=13403340.40..13403340.40 rows=1 width=152)

It doesn't look like an EXPLAIN ANALYZE output. Can you provide a real
one (you should have a second set of numbers with EXPLAIN ANALYZE)?

Thanks,

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux