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 |