Groups > comp.databases.postgresql > #381

scan into many tables

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	Greg Hennessy <greg.hennessy@cox.net>
Newsgroups	comp.databases.postgresql
Subject	scan into many tables
Date	Fri, 13 Jul 2012 16:11:03 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	12
Message-ID	<jtphan$934$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Date	Fri, 13 Jul 2012 16:11:03 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="9b7bc6154893da76f7357e62763374a4"; logging-data="9316"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18D8b40QXitLTOkRXRyZzLdciON6mHS4TM="
User-Agent	slrn/0.9.9p1 (Linux)
Cancel-Lock	sha1:0uI+H4Dxed43omKYd0V1JIocBbA=
Xref	csiph.com comp.databases.postgresql:381

Show key headers only | View raw

I have a rather large table (3 TB) that I need to split up.
I can do a bunch of 
select yada into tmp_00 from centroids where value=0;
select yada into tmp_01 from centroids where value=1;
select yada into tmp_02 from centroids where value=2;

but since a scan on the database takes about 40 hours,
and I have values between 0 and 48, I'm looking at multiple 
weeks just to copy things into the smaller tables.

Is there a way to do this while going through the
database once?

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 16:11 +0000
  Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-13 18:37 +0200
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 18:54 +0000
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 20:48 +0000
  Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 17:51 +0100
    Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 19:00 +0000
      Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 22:15 +0100
      Re: scan into many tables Graham Murray <newspost@gmurray.org.uk> - 2012-07-22 11:46 +0100
        Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 13:09 +0100
          Re: scan into many tables Robert Klemme <shortcutter@googlemail.com> - 2012-07-22 18:55 +0200
            Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 21:07 +0100
          Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 10:30 -0700
            Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-22 20:24 +0200
              Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 12:54 -0700
        Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-22 22:57 +0000
  Re: scan into many tables Jasen Betts <jasen@xnet.co.nz> - 2012-07-14 02:55 +0000

csiph-web