| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Andriy I Pilipenko <bamby(at)marka(dot)net(dot)ua> |
| Cc: | hackers(at)postgresql(dot)org |
| Subject: | Re: [BUGS] General Bug Report: Bug in optimizer |
| Date: | 1999-03-18 16:29:56 |
| Message-ID: | 36F12A04.1D6739BE@krs.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Andriy I Pilipenko wrote:
>
> Why I need to vacuum immediately after creating table?
Oh, sorry, I missed this -:)
Nevertheless, using index for
select * from table1 where field1 = 1;
is bug!
>
> Here is another example from live system:
>
> statserv=> explain select * from ctime where ctg=-1;
> NOTICE: QUERY PLAN:
>
> Seq Scan on ctime (cost=3646.86 size=8412 width=54)
As well as this one.
Should be fixed easy... Could someone address this? -:)
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-03-18 17:07:13 | Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer |
| Previous Message | Andriy I Pilipenko | 1999-03-18 15:22:14 | Re: [BUGS] General Bug Report: Bug in optimizer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hoelc | 1999-03-18 16:41:00 | delete data |
| Previous Message | Andriy I Pilipenko | 1999-03-18 15:22:14 | Re: [BUGS] General Bug Report: Bug in optimizer |