Re: Re: Harddisk performance degrading over time?
От | Daniel Åkerud |
---|---|
Тема | Re: Re: Harddisk performance degrading over time? |
Дата | |
Msg-id | 003c01c0fe39$d6668d90$c901a8c0@automatic100 обсуждение исходный текст |
Ответ на | Re: Harddisk performance degrading over time? (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-general |
OK, so now I know it wasn't that. The strange thing is just that, that looking at all the test values collected, it seems like only indexed inserts and indexed selects has gotten slower for BOTH PostgreSQL and MySQL, Never mind... as long as it is maximally slow now ;) *kidding* Daniel Åkerud > ext2 doesn't need to be defrag'ed either. You CAN, but it shouldn't need it > unless you are doing something very strange. > > Ole Gjerde > > ----- Original Message ----- > From: "Bruce Momjian" <pgman@candle.pha.pa.us> > To: "Daniel Åkerud" <zilch@home.se> > Cc: "Jason Earl" <jdearl@yahoo.com>; "PostgreSQL-general" > <pgsql-general@postgresql.org> > Sent: Sunday, June 24, 2001 10:57 PM > Subject: Re: Harddisk performance degrading over time? > > > > > 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. > > > > I know the BSD filesystems are self-defragmenting. I don't know if the > > ext2 filesystems are the same. Surely someone must know. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: