| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Vacuuming static tables. |
| Date: | 2006-05-10 22:09:58 |
| Message-ID: | 200605101509.58905@hal.medialogik.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On May 10, 2006 11:24 am, "Daniel T. Staal" <DStaal(at)usa(dot)net> wrote:
>
> I have the query written to file to create these, so they are all off
> exactly the same query.
>
> Daniel T. Staal
Well, I don't see what the problem is, but as you said, it's executing
exactly the same plan, so I think it has to to be a disk access issue;
either a caching effect or something else is hammering the disk during the
slow query.
Perhaps someone more knowledgeable will have some insight.
--
"There are more instances of the abridgment of the freedom of the people by
the gradual and silent encroachment of those in power, than by violent and
sudden usurpation." -- James Madison
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luis Silva | 2006-05-10 22:44:54 | difference between := and = |
| Previous Message | Verena Ruff | 2006-05-10 19:20:59 | Re: error handling |