Re: LEFT JOIN optimization

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: ksenia(dot)marasanova(at)gmail(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: LEFT JOIN optimization
Date: 2005-09-12 10:41:28
Message-ID: bimai19g2epho64ls43gp5oqko6bpai6mc@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 12 Sep 2005 00:47:57 +0300, Ksenia Marasanova
<ksenia(dot)marasanova(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2005-09-12 10:51:17 Re: Slow update
Previous Message Hilary Forbes 2005-09-12 09:14:25 Slow update