On Mon, Apr 21, 2008 at 10:54 PM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
> Case 1.
>
> Insert 100 records --- goes into block 1 .. 10
> Delete 100 records
> Insert 100 more records --- goes into 11 .. 20
>
>
> Case 2.
>
> Insert 100 records --- goes into block 1 .. 10
> Delete 100 records
> *Autovacuum triggers*
> Insert 100 more records -- goes into block 1 .. 10
>
Its probably not a very neat example because in this simplistic case,
the ordering would still be same, but we can easily construct a
slightly complex example to prove the point.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com