| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | <emil(at)baymountain(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Indexes on ramdisk |
| Date: | 2005-10-05 14:55:36 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD50F@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Turner | 2005-10-05 15:03:03 | Re: Indexes on ramdisk |
| Previous Message | Kevin Grittner | 2005-10-05 13:51:43 | Re: Is There Any Way .... |