Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
| От | Sergey Konoplev |
|---|---|
| Тема | Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10) |
| Дата | |
| Msg-id | CAL_0b1t3gMOLwERY6NW6AEJbSsmvwQhvy+9EGGUDHKL+w4+nUA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Seq Scan cost shown to be (cost=10000000000.00..10000000001.10) (Amit Langote <amitlangote09@gmail.com>) |
| Ответы |
Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
|
| Список | pgsql-general |
On Mon, May 27, 2013 at 12:42 AM, Amit Langote <amitlangote09@gmail.com> wrote: > I set enable_seqscan=off and also accidentally dropped the only index [...] > Seq Scan on testdata (cost=10000000000.00..10000000001.10 rows=2 width=71) [...] > Although, I suspect the (dropped index + enable_seqscan) causes this, > is the cost shown in explain output some kind of default max or > something like that for such abnormal cases? When you set enable_xxx=off, it not actually disables the xxx operation, it sets the start cost to the high value (10000000000). -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@gmail.com
В списке pgsql-general по дате отправления: