Skip site navigation (1) Skip section navigation (2)

Re: Query only slow on first run

From: cluster <skrald(at)amossen(dot)dk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query only slow on first run
Date: 2007-11-28 20:16:08
Message-ID: fikia6$26ql$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
>> I'm wondering why --- doesn't seem like it should take 6400msec to fetch
>> 646 rows, unless perhaps the data is just horribly misordered relative
>> to the index.   Which may in fact be the case ...

Hmm, actually I still don't understand why it takes 6400 ms to fetch the 
rows. As far as I can see the index used is "covering" so that real row 
lookups shouldn't be necessary. Also, only the the random_numbers 
induces by questions with status = 1 should be considered - and this 
part is a relatively small subset.

In general, I don't understand why the query is so I/O dependant as it 
apparently is.

In response to

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2007-11-28 20:34:42
Subject: Re: Query only slow on first run
Previous:From: MatthewDate: 2007-11-28 17:34:37
Subject: Re: TB-sized databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group