pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Robert Treat <xzilla@users.sourceforge.net>
To: Vitaly Belman <vitalib@012.net.il>
Cc: Jochem van Dieten <jochemd@oli.tudelft.nl>
Cc: Marty Scholes <marty@outputservices.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL caching
Date: 26 May 2004 09:13:58 -0400
Message-ID: <1085577239.29461.1927.camel@camel> (raw )
In-Reply-To: <1371146711781.20040525225305@012.net.il >
References: <20792805375.20040521203337@012.net.il >
<40B36848.1090403@oli.tudelft.nl >
<1371146711781.20040525225305@012.net.il >
On Tue, 2004-05-25 at 15:53, Vitaly Belman wrote:
> >>
> >> QUERY PLAN
> >> ----------
> >> Limit (cost=2337.41..2337.43 rows=10 width=76) (actual
> >> time=7875.000..7875.000 rows=10 loops=1)
> >> -> Sort (cost=2337.41..2337.94 rows=214 width=76) (actual
> >> time=7875.000..7875.000 rows=10 loops=1)
> >> Sort Key: bv_books.vote_avg
> >> -> Nested Loop (cost=0.00..2329.13 rows=214 width=76)
> >> (actual time=16.000..7844.000 rows=1993 loops=1)
> >> -> Index Scan using i_bookgenres_genre_id on
> >> bv_bookgenres (cost=0.00..1681.54 rows=214 width=4) (actual
> >> time=16.000..3585.000 rows=1993 loops=1)
> >> Index Cond: (genre_id = 5830)
> >> -> Index Scan using bv_books_pkey on bv_books
> >> (cost=0.00..3.01 rows=1 width=76) (actual time=2.137..2.137 rows=1
> >> loops=1993)
> >> Index Cond: (bv_books.book_id = "outer".book_id)
> >> Total runtime: 7875.000 ms
>
A question and two experiments... what version of postgresql is this?
Try reindexing i_bookgenres_genre_id and capture the explain analyze for
that. If it doesn't help try doing set enable_indexscan = false and
capture the explain analyze for that.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
view thread (26+ messages) latest in thread
Message-ID: <1085577239.29461.1927.camel@camel>
Permalink: ../1085577239.29461.1927.camel@camel/
Also on: postgresql.org/message-id/1085577239.29461.1927.camel@camel
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: xzilla@users.sourceforge.net, vitalib@012.net.il, jochemd@oli.tudelft.nl, marty@outputservices.com
Subject: Re: PostgreSQL caching
In-Reply-To: <1085577239.29461.1927.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox