select into problem
От | Denis Perchine |
---|---|
Тема | select into problem |
Дата | |
Msg-id | 0010181323230T.17427@dyp.perchine.com обсуждение исходный текст |
Список | pgsql-general |
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 ----------------------------------
В списке pgsql-general по дате отправления: