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
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
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
-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
[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
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
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
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
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