From: | "Medora Schauer" <mschauer(at)fairfield(dot)com> |
---|---|
To: | "Medora Schauer" <mschauer(at)fairfield(dot)com>, "Joe Conway" <mail(at)joeconway(dot)com> |
Cc: | "postgresql" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Odd performance results - more info |
Date: | 2003-08-05 18:18:29 |
Message-ID: | 906E2C446A276048A1BE283F17BCB12CB137DE@encounter.fairind.fairfield.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>
> > Medora Schauer wrote:
> > > I would greatly appreciate it if someone could run this
> > code in their
> > > environment and let me know if you get results similiar to mine.
> > > The INT test results in execution times of 11 - 50+ secs
> increasing
> > > each time the test is run. The FLOAT test execution times are
> > > consistently < 3 secs regardless of how many times it is run.
> >
> > Without actually trying the code, I'd bet that an index is
> > getting used
> > for the float8 case, but not in the int8 case:
> >
>
> I've already verifed that the index is used in both cases.
>
I stand corrected. A sequential scan was being used in the INT8 case.
When I changed it to INT4 I got better results. I got confused cuz
I had changed the types so often.
Thanks for your help,
Medora
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2003-08-05 21:40:16 | Re: Some vacuum & tuning help |
Previous Message | Medora Schauer | 2003-08-05 17:58:23 | Re: Odd performance results - more info |