[GENERAL][HACKERS]data fragmentation

From: "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: [GENERAL][HACKERS]data fragmentation
Date: 2003-12-11 21:36:32
Message-ID: BAY8-F8MdlKfreeJa2y0001374e@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

i have a theorical question. i was thought that data fragmentation can cause
a
loss of performance when retrieving data from a database. Some DBMS solved
this
with dbspaces, but postgresql doesn't support this concept.
so, pgsql databases tend to suffer from data fragmentation?
if yes, what is the solution you recommend?

also i was thought that even when DBMS support dbspaces DELETEing records
may
cause data fragmentation anyway.
so, can i think of DELETE statement as a double-edged sword?
it is indifferent in pgsql - it doesn't support dbspaces anyway?

thanks in advance,
Jaime Casanova (el_vigia)

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-11 22:17:59 Re: PHP and autocommit of PostgreSQL 7.4
Previous Message Sai Hertz And Control Systems 2003-12-11 21:33:52 PHP and autocommit of PostgreSQL 7.4