Re: Improving speed of copy

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема Re: Improving speed of copy
Дата
Msg-id Pine.LNX.4.21.0209201838590.599-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответ на Re: Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-hackers
On Fri, 20 Sep 2002, Shridhar Daithankar wrote:

> In select test where approx. 15 rows where reported with query on index field, 
> mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues 
> eclipse the result..

I don't know about anyone else but I find this aspect strange. That's 1 second
(approx.) per row retrieved. That is pretty dire for an index scan. The
data/index must be very non unique.


-- 
Nigel J. Andrews



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Win32 rename()/unlink() questions
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Win32 rename()/unlink() questions