| From: | bruc(at)stone(dot)congenomics(dot)com (Robert E(dot) Bruccoleri) |
|---|---|
| To: | hannu(at)tm(dot)ee (Hannu Krosing) |
| Cc: | bruc(at)acm(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs |
| Date: | 2001-01-17 15:30:46 |
| Message-ID: | 200101171530.KAA65999@stone.congenomics.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear Hannu,
>
> "Robert E. Bruccoleri" wrote:
> >
> > explain select count(*) from comparisons_4 where code = 80003;
> > NOTICE: QUERY PLAN:
> >
> > Aggregate (cost=15659.29..15659.29 rows=1 width=0)
> > -> Seq Scan on comparisons_4 (cost=0.00..15640.81 rows=7391 width=0)
> >
> > EXPLAIN
>
> What is the type of field "code" ?
int4
Do you think that should make a difference?
+----------------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383 |
| President, Congenomics, Inc. | Fax: 609 737 7528 |
| 114 W Franklin Ave, Suite K1,4,5 | email: bruc(at)acm(dot)org |
| P.O. Box 314 | URL: http://www.congen.com/~bruc |
| Pennington, NJ 08534 | |
+----------------------------------+------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-17 15:31:21 | Re: Mysterious 7.0.3 error |
| Previous Message | Thomas Lockhart | 2001-01-17 15:26:18 | Re: Re: tinterval - operator problems on AIX |