| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |
| 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 |
| 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 |