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))
|
| Список | 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 по дате отправления: