| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Execution variability |
| Date: | 2007-06-28 14:08:06 |
| Message-ID: | 20070628140806.GD5300@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vincenzo Romano escribió:
> The values are here below. I suppose that the "hashed"
> ones imply a default value.
Correct (widely known as "commented out")
> By the way, it seems that the problem arises with only one query,
> while the other ones behave almost the same all the time.
Let's see the EXPLAIN ANALYZE. Does it involve the big table?
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"There is evil in the world. There are dark, awful things. Occasionally, we get
a glimpse of them. But there are dark corners; horrors almost impossible to
imagine... even in our worst nightmares." (Van Helsing, Dracula A.D. 1972)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce McAlister | 2007-06-28 14:41:39 | Re: AutoVacuum Behaviour Question |
| Previous Message | Alvaro Herrera | 2007-06-28 14:00:40 | Re: AutoVacuum Behaviour Question |