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

Re: Query only slow on first run

From: cluster <skrald(at)amossen(dot)dk>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
Subject: Re: Query only slow on first run
Date: 2007-11-28 21:15:59
Message-ID: 474DDA8F.3070801@amossen.dk (view raw or flat)
Thread:
Lists: pgsql-performance
> The indexes don't contain visibility information, so Postgres has to look up
> the row on disk to verify it isn't dead.

I guess this fact drastically decreases the performance. :-(
The number of rows with a random_number will just grow over time while 
the number of questions with status = 1 will always be somewhat constant 
at about 10.000 or most likely much less.

I could really use any kind of suggestion on how to improve the query in 
order to make it scale better for large data sets The 6-7000 ms for a 
clean run is really a showstopper. Need to get it below 70 ms somehow.

In response to

Responses

pgsql-performance by date

Next:From: davidDate: 2007-11-28 21:55:23
Subject: Re: TB-sized databases
Previous:From: Steinar H. GundersonDate: 2007-11-28 20:34:42
Subject: Re: Query only slow on first run

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