On Freitag, 9. Februar 2007 04:08 Peter Koczan wrote:
Case in point, I use xfs as the filesystem running under postgres,
and after a few days the major database clusters showed ~90%
fragmentation on their respective partitions (which is about a 10 to
1 ratio of file fragments to files). After
Michael Monnerie wrote:
On Freitag, 9. Februar 2007 04:08 Peter Koczan wrote:
Case in point, I use xfs as the filesystem running under postgres,
and after a few days the major database clusters showed ~90%
fragmentation on their respective partitions (which is about a 10 to
1 ratio of file
Moiz Kothari wrote:
What are the reasons of data getting fragmented in postgres?
What do you mean by that?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project
Peter Eisentraut wrote:
Moiz Kothari wrote:
What are the reasons of data getting fragmented in postgres?
What do you mean by that?
I am guessing he means filesystem fragmentation.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support:
Moiz Kothari wrote:
Hi All,
What are the reasons of data getting fragmented in postgres? Do we
have any page which explains different scenarios of data getting
fragmented?
Regards,
Moiz Kothari
I guess there are two types of fragmentation in play with postgres,
internal database
Hi All,
What are the reasons of data getting fragmented in postgres? Do we have any
page which explains different scenarios of data getting fragmented?
Regards,
Moiz Kothari