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 по дате отправления: