Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance (was: The New Slashdot Setup (includes MySql server)) - Mailing list pgsql-hackers

From Matthias Urlichs
Subject Re: Performance (was: The New Slashdot Setup (includes MySql server))
Date
Msg-id 20000520100900.H27730@noris.de
Whole thread Raw
In response to Re: Performance (was: The New Slashdot Setup (includes MySql server))  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hi,

Tom Lane:
> It never pays to assume you know what's happening without having looked
> :-(.  It turns out the planner is not the only culprit: the executor's
> ExecOpenIndices() routine *also* does a sequential scan of pg_index.

That meshes with my observation that updates seem to do twice as many
read() calls on pg_index than inserts.

For this test, anyway.

-- 
Matthias Urlichs  |  noris network GmbH   |   smurf@noris.de  |  ICQ: 20193661
The quote was selected randomly. Really.       |        http://smurf.noris.de/
-- 
Statistics: Nubers looking for an argument.

pgsql-hackers by date:

Previous
From: "Matthias Urlichs"
Date:
Subject: Re: Re: Heaps of read() syscalls by the postmaster
Next
From: "Matthias Urlichs"
Date:
Subject: Re: Performance (was: The New Slashdot Setup (includes MySql server))