Postgres Pro
Downloads
Home   >   mailing lists

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

From Dann Corbit
Subject Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Date
Msg-id D425483C2C5C9F49B5B7A41F894415470100069C@postal.corporate.connx.com
Whole thread Raw
In response to Vacuum DB in Postgres Vs similar concept in other RDBMS  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Responses Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
List pgsql-general
Tree view

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_gci1213646,00.html

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.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

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: the future of pljava development
Next
From: "Joshua D. Drake"
Date:
Subject: Re: the future of pljava development