| From: | Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Execution variability |
| Date: | 2007-06-29 07:12:59 |
| Message-ID: | 200706290913.00091.vincenzo.romano@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 28 June 2007 16:08:06 Alvaro Herrera wrote:
> 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?
I need to check.
The "bad guy" is a function and I have to get the body out in order to
make the PG explain it.
--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis Gasparin | 2007-06-29 07:14:40 | Re: AutoVacuum Behaviour Question |
| Previous Message | Richard Huxton | 2007-06-29 06:49:04 | Re: Strange duplicate key violation error |