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

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(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 21:19:37
Message-ID: D425483C2C5C9F49B5B7A41F894415470100069C@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In SQL*Server it is called "UPDATE STATISTICS"

http://msdn2.microsoft.com/en-us/library/ms187348.aspx

Oracle tuning is a lot more fiddly:

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci121
3646,00.html

________________________________

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Harpreet
Dhaliwal
Sent: Wednesday, May 23, 2007 10:49 AM
To: Postgres General
Subject: [GENERAL] Vacuum DB in Postgres Vs similar concept in other
RDBMS

Hi,

I was wondering if Vacuum DB concept in Postgres is really novel and
there's no concept like this in other RDBMS like oracle or sql server.
If at all other RDBMS have such a concept implemented, how good or bad
it is as compared to postgres's vacuum db concept.

Any type of pointers would be highly appreciated.

Thanks,
~Harpreet

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Staubo 2007-05-23 21:27:24 Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Previous Message Chris Browne 2007-05-23 21:17:31 Re: the future of pljava development