From: | Herve Lefebvre <aegir(at)rocketmail(dot)com> |
---|---|
To: | PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux] |
Date: | 1998-07-24 14:22:04 |
Message-ID: | 19980724142204.22444.rocketmail@web1.rocketmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---Marc Fournier <marc(dot)fournier(at)acadiau(dot)ca> wrote:
>
> On Thu, 23 Jul 1998, The Web Administrator wrote:
>
> > Nope.. Oracle has a background process which re-allocates free
space..It does get
> > fragmented, and the only real way to unfrag is to export (dump)
and import.No Vacuum,
> > at least on 7.3.2
>
> So, essentially, our VACUUM command provides functionality that
> Oracle *doesn't* have, right?
I don't think any fragmentation occurs under Oracle, if dataspaces are
allocated on raw-devices (wich is a functionnality PG doesn't have).
When you allocate dataspaces on raw devices, Oracle manage it's own
"file system", it's own cache-memory for this device, wich allows
a different cahce-strategy than the OS have.
--
H.Lefebvre
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-07-24 14:24:37 | Re: [GENERAL] How about this LOGO? |
Previous Message | The Hermit Hacker | 1998-07-24 14:04:39 | Re: [GENERAL] How about this LOGO? |