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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
NYSC

Browse pgsql-novice by date

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