From: | Robert Gottstein <RGottstein(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Transaction read command fetching of single Data Items |
Date: | 2009-12-11 15:09:26 |
Message-ID: | 4B2260A6.8020009@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello, I am a Student of the TU-Darmstadt (Germany), and I would like to
run some tests with Postgres on SSDs.
I need to know at which position a Transaction executes a read on a Data
Item in the source code.
(Backround) I want to evaluate a certain worst case scenario:
When a Transaction "t" reads a Data Item "x" I want to fetch all the
versions "xNew" which are newer than the version of x that t read, if
they exist.
I just want to fetch and immediately forget them, even if that results
in additional reads on the storage drive
[it is even feasable at this point to fetch all Versions of x instead
of just the newer ones]
but I don't know where I should place the code.
I looked at some classes of the backend, but I wasn't able to find the
exact place.
I would be grateful for any hints you could give me.
Best regards, I appreciate your efforts
Robert Gottstein
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2009-12-11 15:11:01 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |
Previous Message | Craig Ringer | 2009-12-11 14:42:38 | Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow. |