| From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
|---|---|
| To: | pankaj naug <pankajnaug(at)yahoo(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: subselect query time and loops problem |
| Date: | 2005-04-10 17:29:04 |
| Message-ID: | 1113154144.7444.49.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sun, 2005-04-10 at 07:54 -0700, pankaj naug wrote:
> [quoting Tom]
> >Evidently one has been analyzed much more recently than the other,
> because the estimated row counts are wildly different.
>
> Both the explain/analyse queries has been run at the same time.
in that case, is the data the same?
if so, what about STATISTICS settings for relevant columns?
just to make things clear, have both databases have been
ANALYZEd or VACUUM ANALYZEd recently ? (in case your
'explain/analyse' only refers to a EXPLAIN ANALYZE)
gnari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-04-11 02:06:04 | Re: [GENERAL] Problems with Set Returning Functions (SRFs) |
| Previous Message | Tom Lane | 2005-04-10 16:27:55 | Re: pg 8.0.1-r3 killls pgadmin3 and phppgadmin |