Re: Performance
От | Bruce Momjian |
---|---|
Тема | Re: Performance |
Дата | |
Msg-id | 200201211333.g0LDX4422570@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Performance ("Martins Zarins" <mark@vestnesis.lv>) |
Ответы |
Any body know --- 'sql query where condition execution plan'
|
Список | pgsql-admin |
See techdocs performance article: http://techdocs.postgresql.org Martins Zarins wrote: > On 18 Jan 2002, at 9:22, Jeremy Buchmann wrote: > > > > It's more than just processor cache, it's your whole I/O subsystem. > > How fast are your drives? How fast is the drive controller? How much > > cache is on each drive? How much cache is on the drive controller? > > Are you going to use a RAID? If so, what type? Do you have enough > > memory for the size of the database and type of queries you're going > > to run? > Is there any good doc about this on net? > (About disc cache, raid cache processor cache and queries - how > they influence each other?) > > Mark > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-admin по дате отправления: