Re: [HACKERS] Re: order by and index path
| От | Bruce Momjian |
|---|---|
| Тема | Re: [HACKERS] Re: order by and index path |
| Дата | |
| Msg-id | 199810151604.MAA15195@candle.pha.pa.us обсуждение |
| Ответ на | Re: order by and index path (jwieck@debis.com (Jan Wieck)) |
| Ответы |
Re: [HACKERS] Re: order by and index path
|
| Список | pgsql-hackers |
> could return at max 8999 tuples and > > WHERE key > 50 AND key < 70 > > has a maximum of 998 result tuples. This would be the > information required to make the right decision for the case > where all rows selected are wanted. > > We do not have this statistical information. So the whole > thing is at this time academic. But we do have statistical information in pg_statistic if you run vacuum analyze. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-hackers по дате отправления: