Re: configuring new server / many slow disks?

От: Axel Rau
Тема: Re: configuring new server / many slow disks?
Дата: ,
Msg-id: 834DBEC9-864E-49B0-BE65-E5A6F0378EA3@Chaos1.DE
(см: обсуждение, исходный текст)
Ответ на: Re: configuring new server / many slow disks?  (Richard Huxton)
Ответы: Re: configuring new server / many slow disks?  (Scott Marlowe)
Список: pgsql-performance

Скрыть дерево обсуждения

configuring new server / many slow disks?  (Axel Rau, )
 Re: configuring new server / many slow disks?  (Axel Rau, )
 Re: configuring new server / many slow disks?  (Richard Huxton, )
  Re: configuring new server / many slow disks?  (Axel Rau, )
   Re: configuring new server / many slow disks?  (Scott Marlowe, )

Am 09.03.2007 um 12:42 schrieb Richard Huxton:

> Axel Rau wrote:
>> Hi performers,
>> after following this list for a while, I try to configure a
>> database server with a limited budget.
>> Planned are 2 databases
>> - archiveopteryx -  http://www.archiveopteryx.org/sql-schema.html
>> - ERDB - https://www.chaos1.de/svn-public/repos/network-tools/ERDB/
>> trunk/database/ERD.pdf In peak times I expect something like
>> - 50 inserts
>> - 20 updates
>> - 200 selects
>> per second.
>
> Presumably with multiple clients, not just one extremely busy one?
Multiple clients do mainly selects (the IMAP users), few mailservers
are busy and do mainly inserts and updates.
> How big do you expect the databases to get?
Up to 1 TB. The 1st DB is an IMAP message store, which keeps Mime
message parts as byteas in one table (bodyparts).

> That'll affect the next point.
>
>> Current configuration is:
>> - Tyan S3992G3NR
>> - 2 x Opteron 2212 (2GHz)
>> - 8 GB RAM (DDR2-667)
>
> Depending on the amount of data you've got to deal with, it might
> be worth trading disks/cpu for more RAM.
>
>> - ARC-1261ML with 1GB and BBU
>
> OK, so you can turn write-caching on. That should let you handle
> more updates than you need. You probably don't need so much RAM on
> board either, unless each update has a lot of data in it.
updates not, but inserts may have 10-20 MBs.
>
>> - 16 Seagate ST3250820NS (250GB, 7200 rpm, 8GB, with perpendicular
>> recording)
>> 1 raid 1 for OS (FreeBSD) and WAL
>> 1 raid 0 with 7 raid 1 for tablespace
>> Can I expect similar performance as 5 drives at 10k rpm (same costs)?
>
> The main question is whether you're going to need to hit the disks
> often. If you can get to the stage where the working-set of your
> DBs are  all in RAM you could sacrifice some disks. If not, disk I/
> O dominates.
Because of the table with the blobs, I need the many disks.
Perhaps this table would be worth of on an own table space / raid 10
set.
>
>> Should I revert to a single-CPU to prevent from oscillating cache
>> updates between CPUS?
>> Anybody experience about NUMA stuff with FreeBSD?
>
> Sorry - I know nothing about FreeBSD.
>
> That any use - I didn't bother to reply before because I couldn't
> help with the BSD stuff, and it's always guesswork with these sorts
> of questions.
> --
Axel
---------------------------------------------------------------------
Axel Rau, ☀Frankfurt , Germany                       +49 69 9514 18 0




В списке pgsql-performance по дате сообщения:

От: Scott Marlowe
Дата:
Сообщение: Re: configuring new server / many slow disks?
От: Andreas Tille
Дата:
Сообщение: PostgreSQL in virtual machine