Skip site navigation (1) Skip section navigation (2)

large table and temp space.

From: "Molenda, Mark P" <mark(dot)molenda(at)eds(dot)com>
To: pgsql-novice(at)postgresql(dot)org,"'psql-general(at)postgresql(dot)org'" <psql-general(at)postgresql(dot)org>
Subject: large table and temp space.
Date: 2002-07-23 19:06:52
Message-ID: 424D6EA99E39D4118FA100508BDF09700ABE517D@USCHM203 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have a 10 million row table that I want to prune down and then create a
table from this pruned data.  I was using "select col1 into newtable from
oldtable where col1 not like '%somevar'  ;     but this creates an error
"ERROR:  ltsWriteBlock: failed to write block 3617 of temporary file
                Perhaps out of disk space?"   I think I have plenty of disk
left, but I don't know how to let postgres know I have more space.  

The second problem is that I have a column that is text.  I need to take
that text and turn it into a recognizable date.  It is currently in UNIX
time format (i.e.1025510400.814 ).

Mark P. Molenda <<...OLE_Obj...>> 
Senior Information Specialist

pgsql-novice by date

Next:From: sibusiso xoloDate: 2002-07-23 20:18:29
Subject: help with failure to connect over a network
Previous:From: Tom LaneDate: 2002-07-23 15:30:46
Subject: Re: URGENT! pg_dump doesn't work!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group