Re: How to make a REALLY FAST db server?
От | Randy Hall |
---|---|
Тема | Re: How to make a REALLY FAST db server? |
Дата | |
Msg-id | 011401c13aaf$f2f53ad0$4401a8c0@win2k обсуждение исходный текст |
Ответ на | How to make a REALLY FAST db server? (bpalmer <bpalmer@crimelabs.net>) |
Список | pgsql-general |
Indeed, there are applications where this is true. Postgres will try to keep as much in the buffers as possible. You always have to take your application into account when tuning the database. Your case where the database may fit entirely in RAM is quite different from a server holding many gigabytes of data and associated index files. -- Randy Hall - Red Hat Certified Engineer - Ex-Great Bridge PostgreSQL Expert Resume: http://members.home.net/rthall3 ----- Original Message ----- From: "Dr. Evil" <drevil@sidereal.kz> To: <pgsql-general@postgresql.org> Sent: Tuesday, September 11, 2001 12:12 AM Subject: Re: [GENERAL] How to make a REALLY FAST db server? > > As far as disks go. You cannot have too many spindles. But the number of > > spindles you have available depends on which pieces of postgres get split > > onto dedicated spindles. > > But if you have enough RAM that the entire DB can be held in RAM, and > if the DB acess pattern is 90% read, 10% write (which is usually the > case) then do you really need to worry about disk performance? > > It seems like for most applications, it is possible to hold all the > data in RAM, and RAM is cheap these days.
В списке pgsql-general по дате отправления: