Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum DB in Postgres Vs similar concept in other RDBMS - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Date
Msg-id d86a77ef0705231648t4236032cl8aa0261041d2e49f@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum DB in Postgres Vs similar concept in other RDBMS  ("Alexander Staubo" <alex@purefiction.net>)
List pgsql-general
Tree view
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@purefiction.net> wrote:
On 5/23/07, Dann Corbit < DCorbit@connx.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.

pgsql-general by date:

Previous
From: "Joris Dobbelsteen"
Date:
Subject: Re: Delete with subquery deleting all records
Next
From: Robert Fitzpatrick
Date:
Subject: Re: Searching data across tables, some large