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