Postgres Pro
Downloads
Home   >   mailing lists

Re: LEFT JOIN optimization - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: LEFT JOIN optimization
Date
Msg-id bimai19g2epho64ls43gp5oqko6bpai6mc@email.aon.at
Whole thread Raw
In response to Re: LEFT JOIN optimization  (Ksenia Marasanova <ksenia.marasanova@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Hilary Forbes
Date:
Subject: Slow update
Next
From: Richard Huxton
Date:
Subject: Re: Slow update