Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
Дата
Msg-id A76B25F2823E954C9E45E32FA49D70EC1BBF3A4D@mail.corp.perceptron.com
обсуждение исходный текст
Ответ на RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.  (<slapo@centrum.sk>)
Список pgsql-performance
Дерево обсуждения 

From: slapo@centrum.sk [mailto:slapo@centrum.sk] 
Sent: Wednesday, August 07, 2013 11:34 AM
To: Igor Neyman; Pavel Stehule
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.

I got:
"Total runtime: 9.313 ms" in pgAdmin
"Total runtime: 9.363 ms" in psql.
But timing after the query finished was 912.842 ms in psql.
 
Cheers,
 
Peter Slapansky
______________________________________________________________

That proves what Pavel suggested regarding planning time.

Regards,
Igor Neyman

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

Предыдущее
От: Alexis Lê-Quôc
Дата:
Сообщение: Better performance possible for a pathological query?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.