Postgres Pro
Downloads
Home   >   mailing lists

ANALYZE for a schema - Mailing list pgsql-general

From Andrus
Subject ANALYZE for a schema
Date
Msg-id e19b2b$2aum$1@news.hub.org
Whole thread Raw
Responses Re: ANALYZE for a schema  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
 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.

pgsql-general by date:

Previous
From: DB Subscriptions
Date:
Subject: [ANN] PostgreSqlClient 2.0 Beta 1 released.
Next
From: amrit@health2.moph.go.th
Date:
Subject: Cannot connect Postgresql 8.1 64 bit