Re: [pgadmin-support] Is the "x ms" info reliable?

2015-01-19 Thread Richard D Levine
hink that pgAdmin is counting the time to traverse the result set, but that's purely speculation. From: Guillaume Lelarge To: Richard D Levine Cc: Dave Page , hushthatb...@hushmail.com, "pgadmin-support@postgresql.org" , pgadmin-support

Re: [pgadmin-support] Is the "x ms" info reliable?

2015-01-19 Thread Richard D Levine
When I have pgAdmin, my app, and PG all running on the same machine, pgAdmin reported query times are one or two orders of magnitude slower than times for the same query reported by turning on statement logging. From: Dave Page To: hushthatb...@hushmail.com Cc: "pgadmin-support@post

Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

2013-08-16 Thread Richard D Levine
I can find no reference in any Postgres or EnterpriseDB documentation to MATERIALIZED VIEW. Are you using pgAdmin with a different DB engine? I'm confused. I would also love to have materialized views. |> | From: | |> >-