Re: [HACKERS] Not enough memory for complex join - Mailing list 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