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