| From: | "Matthias Urlichs" <smurf(at)noris(dot)net> |
|---|---|
| To: | Chris <chris(at)bitmead(dot)com> |
| Cc: | Matthias Urlichs <smurf(at)noris(dot)net>, Hannu Krosing <hannu(at)tm(dot)ee>, The Hermit Hacker <scrappy(at)hub(dot)org>, Alessio Bragadini <alessio(at)albourne(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Performance (was: The New Slashdot Setup (includes MySql server)) |
| Date: | 2000-05-19 10:39:40 |
| Message-ID: | 20000519123940.N27730@noris.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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(at)noris(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2000-05-19 10:51:38 | RE: Performance (was: The New Slashdot Setup (includes MySql server)) |
| Previous Message | Matthias Urlichs | 2000-05-19 10:18:03 | Re: Performance (was: The New Slashdot Setup (includes MySql server)) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2000-05-19 10:51:38 | RE: Performance (was: The New Slashdot Setup (includes MySql server)) |
| Previous Message | Karel Zak | 2000-05-19 10:22:51 | Re: query cache (was: Re: caching query results) |