Re: Question about difference in performance of 2 queries on large table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question about difference in performance of 2 queries on large table
Дата
Msg-id 15476.1072716487@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question about difference in performance of 2 queries on large table  (Sean Shanny <shannyconsulting@earthlink.net>)
Ответы Re: Question about difference in performance of 2 queries  (Sean Shanny <shannyconsulting@earthlink.net>)
Re: Question about difference in performance of 2 queries  (Sean Shanny <shannyconsulting@earthlink.net>)
Re: Question about difference in performance of 2 queries  (Sean Shanny <shannyconsulting@earthlink.net>)
Список pgsql-performance
Дерево обсуждения 
Please show EXPLAIN ANALYZE output for your queries, not just EXPLAIN.
Also it would be useful to see the pg_stats rows for the date_key and
content_key columns.

            regards, tom lane

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

Предыдущее
От: Sean Shanny
Дата:
Сообщение: Question about difference in performance of 2 queries on large table
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: Question about difference in performance of 2 queries