At 04:20 17.06.2003, Nikolaus Dilger said:
--------------------[snip]--------------------
>My guess is that the second execution of the query is
>shorter since the data blocks are cached in memory.
>When you modify the data then it needs to be read again
>from disk which is much slower than from memory. The
>short execution after restarting PostgreSQL seems to
>indicate that your data is cached in the Linux buffer
>cache.
>
>The only strange thing seems to be that you have so few
>rows. Are you getting the data from a remote machine?
>How many bytes does a single row have? Are they really
>large???
--------------------[snip]--------------------
What exactly do you mean? This table is quite filled (2.3 million rows),
but the query results are correct.
--
>O Ernest E. Vogelsinger
(\) ICQ #13394035
^ http://www.vogelsinger.at/
