From: Emil Briggs <emil@baymountain.com>
To: pgsql-performance@postgresql.org
Subject: Re: Indexes on ramdisk
Date: Tue, 4 Oct 2005 23:41:23 -0400
Message-ID: <200510042341.23264.emil@baymountain.com> (raw)
In-Reply-To: <33c6269f0510042023t24175e33vf84d9af609a8ccd7@mail.gmail.com>
References: <200510042109.01849.emil@baymountain.com>
<33c6269f0510042023t24175e33vf84d9af609a8ccd7@mail.gmail.com>
> Talk about your IO system a bit. There might be obvious ways to improve.
>
> What System/Motherboard are you using?
> What Controller Cards are you using?
> What kind of Disks do you have (SATA, SCSI 7.6k 10k 15k)
> What denominations (9, 18, 36, 72, 143, 80, 160, 200 240Gig)?
> What kind of RAIDs do you have setup (How many drives what stripe sizes,
> how many used for what).
> What levels of RAID are you using (0,1,10,5,50)?
>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: emil@baymountain.com
Subject: Re: Indexes on ramdisk
In-Reply-To: <200510042341.23264.emil@baymountain.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox