Re: [HACKERS] \dt and disk access
| От | Bruce Momjian |
|---|---|
| Тема | Re: [HACKERS] \dt and disk access |
| Дата | |
| Msg-id | 7e7657a02909c3a0f4de85df08f9d98a обсуждение исходный текст |
| Ответ на | [HACKERS] \dt and disk access (Bruce Momjian <maillist@candle.pha.pa.us>) |
| Список | pgsql-hackers |
> > Permission to put this in 6.1p1? > > By all means... Thomas says no for 6.1p1. I have no opinion on this. However, I don't want to rush out a fix until I have heard from Paul M. Aoki and Vadim, and gotten their opinion for the most efficient way to fix this. > > My next question is what is considered a 'small SELECT result'? If > I have a 32Meg machine, that 'small' would be different, I would assume, > then a 128Meg machine. I think the sort is used by ORDER BY and joins where this is not an existing index. > With that in mind, how about some sort of 'switch', similar to > -B, that allows you to stipulate total RAM of a machine (or virtual memory?), > or something similar to that? I am not sure how to do this. There is sysctl() and getconf(), but neither of them is standard on all platforms. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
В списке pgsql-hackers по дате отправления: