On Mon, 2005-10-31 at 16:12, Tom Lane wrote:
> Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes:
> > I was mainly wondering if that behaviour had changed, if, when the data
> > are released, they are still held in shared memory until forced out by
> > newer / more popular data. Which would make the buffer pool a real
> > cache.
Oh, sorry. I Was under the impression that once it wasn't needed the
buffers just dropped the data completely. Thanks
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
