Re: View performance question

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Alex Pilosov <alex(at)pilosoft(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: View performance question
Date: 2001-06-22 16:48:18
Message-ID: web-75996@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Alex,

> please do 'explain select * from yourview'

I can't figure out how to get Explain to output to a file instead of the
screen. Embarassing, I know, but the command seems to subbornly resist
all command-line re-direction.

>
> also make sure all tables are vacuumed

They are.

-Josh

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-22 16:56:34 Re: cache lookup failed ???? What is it ???!!!
Previous Message Porfirio Córdoba 2001-06-22 16:31:51 unregister