From: slapo@xxxxxxxxxx [mailto:slapo@xxxxxxxxxx] Sent: Wednesday, August 07, 2013 11:34 AM To: Igor Neyman; Pavel Stehule Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: RE: 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
