Re: Sanity check requested

Поиск
Список
Период
Сортировка
Искать
От
Ang Chin Han
Тема
Re: Sanity check requested
Дата
Msg-id
3F179CF6.5070400@bytecraft.com.my
Ответ на
Re: Sanity check requested (Shridhar Daithankar)
Список
Дерево обсуждения
Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Josh Berkus <josh@agliodbs.com>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Joe Conway <mail@joeconway.com>
Re: Sanity check requested Vincent van Leeuwen <pgsql.spam@vinz.nl>
Re: Sanity check requested "Nick Fankhauser" <nickf@ontko.com>
Re: Sanity check requested Rod Taylor <rbt@rbt.ca>
Re: Sanity check requested Josh Berkus <josh@agliodbs.com>
Re: Sanity check requested "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Clearing rows periodically Martin Foster <martin@ethereal-realms.org>
Re: Clearing rows periodically Paul Thomas <paul@tmsl.demon.co.uk>
Re: Clearing rows periodically Andrew Sullivan <andrew@libertyrms.info>
Re: Clearing rows periodically Tom Lane <tgl@sss.pgh.pa.us>
Re: Sanity check requested Ang Chin Han <angch@bytecraft.com.my>
File systems (RE: Sanity check requested) "Nick Fankhauser" <nickf@ontko.com>
Re: File systems (RE: Sanity check requested) Tom Lane <tgl@sss.pgh.pa.us>
Re: Sanity check requested "scott.marlowe" <scott.marlowe@ihs.com>
Shridhar Daithankar wrote:
> On 17 Jul 2003 at 10:41, Nick Fankhauser wrote:
> 
>>I'm using ext2. For now, I'll leave this and the OS version alone. If I
> 
> 
> I appreciate your approach but it almost proven that ext2 is not the best and 
> fastest out there.

Agreed.

> IMO, you can safely change that to reiserfs or XFS. Or course, testing is 
> always recommended.

We've been using ext3fs for our production systems. (Red Hat Advanced 
Server 2.1)

And since your (Nick) system is based on Debian, I have done some rough 
testing on Debian sarge (testing) (with custom 2.4.20) with ext3fs, 
reiserfs and jfs. Can't get XFS going easily on Debian, though.

I used a single partition mkfs'd with ext3fs, reiserfs and jfs one after 
the other on an IDE disk. Ran pgbench and osdb-x0.15-0 on it.

jfs's has been underperforming for me. Somehow the CPU usage is higher 
than the other two. As for ext3fs and reiserfs, I can't detect any 
significant difference. So if you're in a hurry, it'll be easier to 
convert your ext2 to ext3 (using tune2fs) and use that. Otherwise, it'd 
be nice if you could do your own testing, and post it to the list.

-- 
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 
GNU/Linux
   2:30pm  up 204 days,  5:35,  5 users,  load average: 5.50, 5.18, 5.13
В списке pgsql-performance по дате отправления
От: Martin Foster
Дата:
Сообщение: Clearing rows periodically
От: Paul Thomas
Дата:
Сообщение: Re: Clearing rows periodically
FAQ