From: Josh Berkus <josh@agliodbs.com>
To: Alex Pilosov <alex@pilosoft.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: View performance question
Date: Fri, 22 Jun 2001 09:48:18 -0700
Message-ID: <web-75996@davinci.ethosmedia.com> (raw)
In-Reply-To: <Pine.BSO.4.10.10106221131130.17823-100000@spider.pilosoft.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, alex@pilosoft.com
Subject: Re: View performance question
In-Reply-To: <web-75996@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox