Horton

Re: LEFT JOIN optimization

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: ksenia.marasanova@gmail.com
Cc: pgsql-performance@postgresql.org
Date: 2005-09-12T10:41:28Z
Lists: pgsql-performance 
On Mon, 12 Sep 2005 00:47:57 +0300, Ksenia Marasanova
<ksenia.marasanova@gmail.com> wrote:
>   ->  Seq Scan on user_  (cost=0.00..7430.63 rows=12763 width=245)
>(actual time=360.431..1120.012 rows=12763 loops=1)

If 12000 rows of the given size are stored in more than 7000 pages, then
there is a lot of free space in these pages.  Try VACUUM FULL ...

Servus
 Manfred