From: | Denis Perchine <dyp(at)perchine(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | select into problem |
Date: | 2000-10-18 06:23:23 |
Message-ID: | 0010181323230T.17427@dyp.perchine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Victor Ivanov | 2000-10-18 07:25:05 | Re: C function and NULL result |
Previous Message | Tom Lane | 2000-10-18 05:31:00 | Re: web programming |