Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-30 Thread Ron Mayer
Tom Lane wrote: > > Exactly. VACUUM sucks (ahem) in all ways but one: it pushes the > maintenance costs associated with MVCC out of the foreground query code > paths and into an asynchronous cleanup task. AFAIK we are the only DBMS > that does it that way. Personally I believe it's a fundamenta

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-26 Thread Robert Treat
On Wednesday 23 May 2007 20:33, Ron Johnson wrote: > On 05/23/07 19:17, Chris Browne wrote: > > [EMAIL PROTECTED] ("Harpreet Dhaliwal") writes: > >> I was just wondering if Vacuum Db in postgresql is somehow superior > >> to the ones that we have in other RDBMS. > > > > The thing that is more akin

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Tom Lane
Ron Johnson <[EMAIL PROTECTED]> writes: >> [EMAIL PROTECTED] ("Harpreet Dhaliwal") writes: >>> I was just wondering if Vacuum Db in postgresql is somehow superior >>> to the ones that we have in other RDBMS. > So it's not "near-zero cost", it's "deferred cost". Exactly. VACUUM sucks (ahem) in al

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/23/07 19:17, Chris Browne wrote: > [EMAIL PROTECTED] ("Harpreet Dhaliwal") writes: >> I was just wondering if Vacuum Db in postgresql is somehow superior >> to the ones that we have in other RDBMS. > > The thing that is more akin to VACUUM, in O

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Chris Browne
[EMAIL PROTECTED] ("Harpreet Dhaliwal") writes: > I was just wondering if Vacuum Db in postgresql is somehow superior > to the ones that we have in other RDBMS. The thing that is more akin to VACUUM, in Oracle's case, is the rollback segment. In Oracle, Rollback segments are areas in your databas

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Harpreet Dhaliwal
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 <[EMAIL PROTECTED]> wrote: On 5/23/07, Dann Corbit <[EMAIL PROTECTED]> wrote: > In SQL*Server it is called "UPDATE STATISTICS" > > http://msdn2.microsoft.com

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Alexander Staubo
On 5/23/07, Dann Corbit <[EMAIL PROTECTED]> 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. ---(end of broad

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Dann Corbit
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: [EMAIL PROTECTED] [mai

Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-23 Thread Alexander Staubo
On 5/23/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: 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