Re: simple query runs 26 seconds

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: simple query runs 26 seconds
Date: 2007-08-26 18:55:00
Message-ID: 22414.1188154500@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <kobruleht2(at)hot(dot)ee> writes:
> My query takes 26 seconds to run.

The time seems entirely spent in fetching rows from table "rid".
Perhaps that table is bloated by lack of vacuuming --- can you
show the output from "vacuum verbose rid"?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-08-26 19:30:11 Re: problem Linking a TTable component to a pgsql view using BCB5
Previous Message HST 2007-08-26 18:30:09 Detecting whether a point is in a box.