Re: PostgreSQL win32 fragmentation issue
От | Tom Lane |
---|---|
Тема | Re: PostgreSQL win32 fragmentation issue |
Дата | |
Msg-id | 12796.1165120575@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: PostgreSQL win32 fragmentation issue (Mark Kirkwood <markir@paradise.net.nz>) |
Ответы |
Re: PostgreSQL win32 fragmentation issue
Re: PostgreSQL win32 fragmentation issue |
Список | pgsql-hackers |
Mark Kirkwood <markir@paradise.net.nz> writes: > A related point comes to mind, consider the single "tablespace" file for > example: It may have no fragmentation from a *file* perspective, but > supposing you have several busy relations being inserted or updated then > pages (or groups of pages) for these could be "fragmented" throughout > the tablespace file. +1 ... what was said upthread sounds to me like those other databases are just hiding the fragmentation issue within their huge-files-you-can't-see-into. I would very much like to see some proof of performance problems before we worry about this. regards, tom lane
В списке pgsql-hackers по дате отправления: