webmailstation=# select * into table stats082000 from stats where sent_date <
'2000-09-01';
ERROR: stats082000: cannot extend. Check free disk space.
webmailstation=# \d stats
Table "stats"
Attribute | Type | Modifier
-----------+-----------+------------------------------------------------
id | integer | not null default nextval('stats_id_seq'::text)
user_id | integer | not null
server_id | integer | not null
isin | boolean | not null
sent_date | timestamp | not null
Index: stats_id_key
Table is quite large.
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE:
Analyzing...
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE: --Relation
stats--
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE: Pages
7393: Changed 1, reaped 49, Empty 0, New 0; Tup 1005281: Vac 82, Keep/VTL
0/0, Crash 0, UnUsed 0, MinLen 56, MaxLen 56; Re-using: Free/Avail. Space
5768/5768; EndEmpty/Avail. Pages 0/49. CPU 0.91s/0.33u sec.
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE: Index
stats_id_key: Pages 1982; Tuples 1005281: Deleted 0. CPU 0.29s/2.28u sec.
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE: Rel stats:
Pages: 7393 --> 7392; Tuple(s) moved: 82. CPU 0.01s/0.03u sec.
psql:/home/www/www.webmailstation.com/sql/reindex.sql:75: NOTICE: Index
stats_id_key: Pages 1982; Tuples 1005281: Deleted 82. CPU 0.16s/2.42u sec.
PostgreSQL 7.0.2, Linux 2.2.16.
Any ideas why this can happend?
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------