Horton

Re: [HACKERS] Not enough memory for complex join

Vadim Mikheev <vadim@krs.ru>

View thread
From: Vadim Mikheev <vadim@krs.ru>
To: phd2@earthling.net
Cc: Hannu Krosing <hannu@trust.ee>, PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Date: 1999-03-05T02:03:00Z
Lists: pgsql-hackers 
Oleg Broytmann wrote:
> 
> Nested Loop  (cost=0.00 size=1 width=18)
>   ->  Nested Loop  (cost=0.00 size=1 width=14)
>         ->  Merge Join  (cost=0.00 size=1 width=10)
>               ->  Seq Scan  (cost=0.00 size=0 width=0)
>                     ->  Sort  (cost=0.00 size=0 width=0)
>                           ->  Seq Scan on districts d  (cost=0.00 size=0 width=4)
>               ->  Seq Scan  (cost=0.00 size=0 width=0)
>                     ->  Sort  (cost=0.00 size=0 width=0)
>                           ->  Seq Scan on shops sh  (cost=0.00 size=0 width=6)
>         ->  Seq Scan on central cn  (cost=0.00 size=0 width=4)
>   ->  Seq Scan on positions p  (cost=0.00 size=0 width=4)
                                            ^^^^^^
vacuum...

Vadim