Re: Reliability recommendations

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Reliability recommendations
Дата
Msg-id 43FF403D.8090305@commandprompt.com
обсуждение исходный текст
Ответ на Re: Reliability recommendations  ("Craig A. James" <cjames@modgraph-usa.com>)
Ответы Re: Reliability recommendations
Re: Reliability recommendations
Список pgsql-performance
> I find this strains credibility, that this major manufacturer of PC's
> would do something deceptive that hurts performance, when it would be
> easily detected and widely reported.  Can anyone cite a specific
> instances where this has happened?  Such as, "I bought Dell model XYZ,
> which was advertised to have these parts and these specs, but in fact
> had these other parts and here are the actual specs."
I can :)

Feb 20 07:33:52 master kernel: [4294682.803000]   Vendor: MegaRAID
Model: LD 0 RAID1   51G  Rev: 196T
Feb 20 07:33:52 master kernel: [4294682.803000]   Type:
Direct-Access                      ANSI SCSI revision: 02
Feb 20 07:33:52 master kernel: [4294682.818000] tg3.c:v3.31 (June 8, 2005)
Feb 20 07:33:52 master kernel: [4294682.818000] ACPI: PCI Interrupt
0000:0a:01.0[A] -> GSI 17 (level, low) -> IRQ 17
Feb 20 07:33:52 master kernel: [4294683.510000] eth0: Tigon3
[partno(BCM95700A6) rev 7104 PHY(5411)] (PCI:66MHz:64-bit)
10/100/1000BaseT Ethernet 00:0f:1f:6e:01:f
Feb 20 07:33:52 master kernel: [4294683.510000] eth0: RXcsums[1]
LinkChgREG[1] MIirq[1] ASF[0] Split[0] WireSpeed[0] TSOcap[0]
Feb 20 07:33:52 master kernel: [4294683.510000] eth0: dma_rwctrl[76ff000f]
Feb 20 07:33:52 master kernel: [4294683.510000] ACPI: PCI Interrupt
0000:0a:02.0[A] -> GSI 18 (level, low) -> IRQ 18
Feb 20 07:33:52 master kernel: [4294684.203000] eth1: Tigon3
[partno(BCM95700A6) rev 7104 PHY(5411)] (PCI:66MHz:64-bit)
10/100/1000BaseT Ethernet 00:0f:1f:6e:01:f
Feb 20 07:33:52 master kernel: [4294684.203000] eth1: RXcsums[1]
LinkChgREG[1] MIirq[1] ASF[0] Split[0] WireSpeed[0] TSOcap[0]
Feb 20 07:33:52 master kernel: [4294684.203000] eth1: dma_rwctrl[76ff000f]
Feb 20 07:33:52 master kernel: [4294686.228000] SCSI device sda:
106168320 512-byte hdwr sectors (54358 MB)
Feb 20 07:33:52 master kernel: [4294686.228000] SCSI device sda:
106168320 512-byte hdwr sectors (54358 MB)
Feb 20 07:33:52 master kernel: [4294686.228000]
/dev/scsi/host0/bus2/target0/lun0: p1 p2 < p5 > p3
Feb 20 07:33:52 master kernel: [4294686.243000] Attached scsi disk sda
at scsi0, channel 2, id 0, lun 0
Feb 20 07:33:52 master kernel: [4294686.578000] ACPI: CPU0 (power
states: C1[C1])
Feb 20 07:33:52 master kernel: [4294686.655000] Attempting manual resume
Feb 20 07:33:52 master kernel: [4294686.659000] swsusp: Suspend
partition has wrong signature?
Feb 20 07:33:52 master kernel: [4294686.671000] kjournald starting.
Commit interval 5 seconds
Feb 20 07:33:52 master kernel: [4294686.671000] EXT3-fs: mounted
filesystem with ordered data mode.
Feb 20 07:33:52 master kernel: [4294687.327000] md: md driver 0.90.1
MAX_MD_DEVS=256, MD_SB_DISKS=27
Feb 20 07:33:52 master kernel: [4294688.633000] Adding 3903784k swap on
/dev/sda5.  Priority:-1 extents:1
Feb 20 07:33:52 master kernel: [4294688.705000] EXT3 FS on sda3,
internal journal
Feb 20 07:33:52 master kernel: [4294692.533000] lp: driver loaded but no
devices found
Feb 20 07:33:52 master kernel: [4294692.557000] mice: PS/2 mouse device
common for all mice
Feb 20 07:33:52 master kernel: [4294695.263000] device-mapper:
4.4.0-ioctl (2005-01-12) initialised: dm-devel@redhat.com
Feb 20 07:33:52 master kernel: [4294695.479000] kjournald starting.
Commit interval 5 seconds
Feb 20 07:33:52 master kernel: [4294695.479000] EXT3 FS on sda1,
internal journal
Feb 20 07:33:52 master kernel: [4294695.479000] EXT3-fs: mounted
filesystem with ordered data mode.
Feb 20 07:33:52 master kernel: [4294695.805000] Linux agpgart interface
v0.101 (c) Dave Jones
Feb 20 07:33:52 master kernel: [4294696.071000] piix4_smbus
0000:00:0f.0: Found 0000:00:0f.0 device
Feb 20 07:33:52 master kernel: [4294696.584000] pci_hotplug: PCI Hot
Plug PCI Core version: 0.5


processor       : 0
vendor_id       : GenuineIntel
cpu family      : 15
model           : 2
model name      : Intel(R) Xeon(TM) MP CPU 2.20GHz
stepping        : 6
cpu MHz         : 2194.056
cache size      : 512 KB
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 2
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips        : 4325.37



This machine... if you run it in raid 5 will only get 7-9 megabytes a
second READ! performance. That is with 6 SCSI drives.
If you run it in RAID 10 you get a more reasonable 50-55 megabytes per
second.

I don't have it sitting in front of me or I would give you an exact
model number.

This machine also uses the serverworks chipset which is known to be a
catastrophe.

Joshua D. Drake




>
> Dell seems to take quite a beating in this forum, and I don't recall
> seeing any other manufacturer blasted this way.  Is it that they are
> deceptive, or simply that their "servers" are designed to be office
> servers, not database servers?
>
> There's nothing wrong with Dell designing their servers for a
> different market than ours; they need to go for the profits, and that
> may not include us.  But it's not fair for us to claim Dell is being
> deceptive unless we have concrete evidence.
>
> Craig
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq


--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Reliability recommendations
Следующее
От: "Eric Lauzon"
Дата:
Сообщение: Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf