Re: Trying to figure out why these queries are so slow

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Trying to figure out why these queries are so slow
Дата
Msg-id AANLkTinxM6N3P2-oK+wPxX_g=1-jM8A94rBP8UhTh+TQ@mail.gmail.com
обсуждение исходный текст
Ответ на Trying to figure out why these queries are so slow  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Tue, Oct 5, 2010 at 10:33 PM, Thomas Guettler <hv@tbz-pariv.de> wrote:
> Hi,
>
> just a guess: Counting is slow, since it needs to check all rows. Explained here:
>

Actually counting was pretty fast. As I said when I created a table
using the subquery that went pretty fast. The update was the slow
part.

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

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Trying to figure out why these queries are so slow
Следующее
От: "Vishnu S."
Дата:
Сообщение: Re: Data Not replicating