Re: PostgreSQL win32 fragmentation issue
От | Joshua D. Drake |
---|---|
Тема | Re: PostgreSQL win32 fragmentation issue |
Дата | |
Msg-id | 1165077364.18923.5.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: PostgreSQL win32 fragmentation issue ("Matthew T. O'Connor" <matthew@zeut.net>) |
Список | pgsql-hackers |
> Or more specifically do you have any idea what it means in terms of > performance? And why do you say that you *have to* defrag under > windows, isn't this only a performance issue and not necessarily a huge > one at that? Also, as a solution, I would think that CLUSTER might help. Yes it is a performance issue. And all performance issues if they can not be resolved within the database or application, eventually become an outage. A CLUSTER may, but that puts us back to an outage. A CLUSTER is an exclusive lock. Usually for long periods of time. Joshua D. Drake > > Matt > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-hackers по дате отправления: