Re: Asking advice on speeding up a big table

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Asking advice on speeding up a big table
Дата
Msg-id cone.1145118123.188398.47312.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Asking advice on speeding up a big table  (felix@crowfix.com)
Список pgsql-general
felix-accts-pgsql@crowfix.com writes:

> I have made some minor changes and speeded things up to around 15-20
> lookups/sec, good enough, but not exciting :-)


hmm let me understand this.
You went from 1 query 3 to 4 seconds to 45 to 60 queries in the same amount
of time... 45 to 60 times faster.. and that is not something to be excited
about. :)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 21 bit number for sequence
Следующее
От: "Claudio Alejandro Ulloa Heinsohn"
Дата:
Сообщение: Update from diferents conditions