Re: Performance (was: The New Slashdot Setup (includes MySql server))

Поиск
Список
Период
Сортировка
От Matthias Urlichs
Тема Re: Performance (was: The New Slashdot Setup (includes MySql server))
Дата
Msg-id 20000519123940.N27730@noris.de
обсуждение исходный текст
Ответ на Re: Performance (was: The New Slashdot Setup (includes MySql server))  (Chris <chris@bitmead.com>)
Ответы Re: Performance (was: The New Slashdot Setup (includes MySql server))  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Chris:
> Matthias Urlichs wrote:
> 
> > Nonono, the 1000 read() calls are triggered by a simple INSERT or UPDATE
> > call. They actually scan the pg_index table of the benchmark database.
> 
> Does this only happen on the first call to INSERT/UPDATE after
> connecting to the database, or does it happen with all subsequent calls
> too?
> 
All of them. Whatever the server is looking up here, it's _not_ cached.

-- 
Matthias Urlichs  |  noris network GmbH   |   smurf@noris.de  |  ICQ: 20193661
The quote was selected randomly. Really.       |        http://smurf.noris.de/
-- 
GRITCH 1. n. A complaint (often caused by a GLITCH (q.v.)).  2. v. To  complain.  Often verb-doubled: "Gritch gritch".
3.Glitch.                               -- From the AI Hackers' Dictionary
 


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

Предыдущее
От: Chris
Дата:
Сообщение: Re: Performance (was: The New Slashdot Setup (includes MySql server))
Следующее
От: Karel Zak
Дата:
Сообщение: Re: query cache (was: Re: caching query results)