select into problem

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
----------------------------------

Responses

Browse pgsql-general by date

  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