Re: [HACKERS] Large databases, performance

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>, "pankaj M(dot) Tolani" <pankaj(at)pspl(dot)co(dot)in>
Subject: Re: [HACKERS] Large databases, performance
Date: 2002-10-03 16:53:32
Message-ID: latopug1vl51769nkn3rj2ltdhjvqrbfof@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance pgsql-sql

On Thu, 03 Oct 2002 21:47:03 +0530, "Shridhar Daithankar"
<shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
>I believe that was vacuum analyze only.

Well there is

VACUUM [tablename];

and there is

ANALYZE [tablename];

And

VACUUM ANALYZE [tablename];

is VACUUM followed by ANALYZE.

Servus
Manfred

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2002-10-03 16:57:51 Re: foreach in sql functions
Previous Message Hans-Jürgen Schönig 2002-10-03 16:51:05 Re: [HACKERS] Large databases, performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-10-03 16:57:43 Re: Trigger regression test output
Previous Message Hans-Jürgen Schönig 2002-10-03 16:51:05 Re: [HACKERS] Large databases, performance

Browse pgsql-performance by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2002-10-03 16:58:26 unsubscribe
Previous Message Hans-Jürgen Schönig 2002-10-03 16:51:05 Re: [HACKERS] Large databases, performance

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-10-03 17:09:38 Re: drop constraint primary key
Previous Message Hans-Jürgen Schönig 2002-10-03 16:51:05 Re: [HACKERS] Large databases, performance