Re: Harddisk performance degrading over time?
От | Daniel Åkerud |
---|---|
Тема | Re: Harddisk performance degrading over time? |
Дата | |
Msg-id | 000901c0fcb7$34734c40$c901a8c0@automatic100 обсуждение исходный текст |
Ответ на | Re: Harddisk performance degrading over time? (Jason Earl <jdearl@yahoo.com>) |
Ответы |
Re: Harddisk performance degrading over time?
|
Список | pgsql-general |
Oh yeah, vacuuming is not the problem here. Thanks anyway... :) And also, it seems that it is the indexed searches that is suffering the most. The non-indexed searches is less affected. This is not only PostgreSQL but also MySQL. The database is totally restored each test run. Daniel Åkerud > > Actually, the culprit is probably PostgreSQL and not > the ext2 file system. Have you tried vacuuming you > database and running the benchmarks again? PostgreSQL > uses a non-overwriting storage manager, and so vacuum > needs to be run periodically to clear out expired > tuples. > > Jason > > --- Daniel_Åkerud <zilch@home.se> wrote: > > Do the hard disk degrade in performance over time on > > a Linux ext2 filesystem? All my performance test > > programs show 20% worse performance and I have done > > NADA! I just ran them again :( > > > > Do you have to defrag? > > > > --- > > Daniel Åkerud > > > > [ Don't underestimate the power of stupid people in > > large groups] > > > > > __________________________________________________ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ >
В списке pgsql-general по дате отправления: