Felix Schwarz <[EMAIL PROTECTED]> wrote: > > If I don't build the two tables in the > > INSERT INTO entries .. > INSERT INTO entries .. > INSERT INTO entries .. > > INSERT INTO binaries .. > INSERT INTO binaries .. > INSERT INTO binaries .. > > but instead do a > > INSERT INTO entries .. > INSERT INTO binaries .. > > INSERT INTO entries .. > INSERT INTO binaries .. > > INSERT INTO entries .. > INSERT INTO binaries .. > > over a longer period of time .. does the part of your answer about > better locality still apply?
Somewhat. You still have some increased locality of reference, but not as much as you would if entries was created first and binaries separately. You can restore locality of reference by running VACUUM. -- D. Richard Hipp <[EMAIL PROTECTED]>