Re: Vacuum DB in Postgres Vs similar concept in other RDBMS

From: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
To: "Alexander Staubo" <alex(at)purefiction(dot)net>
Cc: "Dann Corbit" <DCorbit(at)connx(dot)com>, "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Date: 2007-05-23 23:48:18
Message-ID: d86a77ef0705231648t4236032cl8aa0261041d2e49f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was just wondering if Vacuum Db in postgresql is somehow superior to the
ones that we have in other RDBMS.

On 5/23/07, Alexander Staubo <alex(at)purefiction(dot)net> wrote:
>
> On 5/23/07, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
> > In SQL*Server it is called "UPDATE STATISTICS"
> >
> > http://msdn2.microsoft.com/en-us/library/ms187348.aspx
>
> No -- MS SQL Server's "update statistics" is the equivalent of
> "analyze", not "vacuum."
>
> Alexander.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message km 2007-05-23 23:54:26 Timestamp with time zone: why not?
Previous Message Robert Fitzpatrick 2007-05-23 23:48:10 Re: Searching data across tables, some large