From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Rob Schall <rschall(at)callone(dot)net>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Differences in identical queries |
Date: | 2007-03-02 16:51:08 |
Message-ID: | 45E855FC.3050006@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rob Schall wrote:
> I noticed the rows bit. I wasn't quite sure why it thought it would get
> so many back. Even after doing a analyze. I will alter the table stats
> and see if that helps.
>
> As for the values in orignum, they are all 10 digit numbers
> (nxx,npa,num). I probably could have stored them as a char, etc, but I
> didn't think that would help the cause at all. They are all over the
> board as far what the numbers are set to, but long story short, they are
> call detail numbers. So if they are our customer, then one of the
> numbers i tossed in anitmp (one of the customer's numbers) could have
> hundreds of entries. Not sure if this is what you were asking me.
Well, it must be thinking it'll get a lot of matches for your 40 rows,
so increasing the stats might well help.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2007-03-02 17:20:02 | Re: Thanks to all |
Previous Message | Martijn van Oosterhout | 2007-03-02 16:47:17 | Re: psql client quits after 1st command |