ANALYZE for a schema

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: ANALYZE for a schema
Date: 2006-04-08 21:44:17
Message-ID: e19b2b$2aum$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have multi company database where each company is stored in different
schema.

When I create incrementally new companis and add data to it ANALYZE command
takes a lot of time: every time it analyzes the previous company data also.

How to run ANALYZE command for a single schema ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank 2006-04-08 21:53:19 pl/perl error
Previous Message Greg Stark 2006-04-08 20:36:59 Re: Debian package for freeradius_postgresql module