On Wed, Mar 17, 2004 at 03:29:33PM -0700, Shilong Stanley Yao wrote: > Hi, > I inserted thousands of records in a table, but when using "select > relname, relpages from pg_class;", the number of pages of the table in > which I am inserting records is always 10, which is the same as an empty > table. Am I doing anything wrong? Thanks, -Stan
These figures are updated by VACUUM and possibly by ANALYZE also. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > If the Catholic church can survive the printing press, science fiction > will certainly weather the advent of bookwarez. > http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow
pgp00000.pgp
Description: PGP signature
