Re: Indexes on ramdisk

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Indexes on ramdisk
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD50F@Herge.rcsinc.local
обсуждение исходный текст
Ответ на Indexes on ramdisk  (Emil Briggs <emil@baymountain.com>)
Список pgsql-performance
> It's a quad opteron system. RAID controller is a 4 channel LSILogic
> Megaraid
> 320 connected to 10 15k 36.7G SCSI disks. The disks are configured in
5
> mirrored partitions. The pg_xlog is on one mirror and the data and
indexes
> are spread over the other 4 using tablespaces. These numbers from
> pg_stat_user_tables are from about 2 hours earlier today on this one
> table.
>
>
> idx_scan           20578690
> idx_tup_fetch  35866104841
> n_tup_ins        1940081
> n_tup_upd       1604041
> n_tup_del        1880424

Is your raid controller configured to buffer your writes?  How much RAM
are you packing?  Are you running 64 bit?

Merlin

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Is There Any Way ....
Следующее
От: Alex Turner
Дата:
Сообщение: Re: Indexes on ramdisk