Postgres Pro
Downloads
Home   >   mailing lists

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

From Igor Neyman
Subject Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC1BBF3A4D@mail.corp.perceptron.com
Whole thread Raw
In response to RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.  (<slapo@centrum.sk>)
List pgsql-performance
Tree view 

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 by date:

Previous
From: Alexis Lê-Quôc
Date:
Subject: Better performance possible for a pathological query?
Next
From: Tom Lane
Date:
Subject: Re: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.