Re: Performance (was: The New Slashdot Setup (includes MySql server)) - Mailing list 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