Re: [NOVICE] How to split a table? - Mailing list pgsql-sql

From Christoph Frick
Subject Re: [NOVICE] How to split a table?
Date
Msg-id 20061017092616.GH3822@byleth.sc-networks.de
Whole thread Raw
In response to How to split a table?  ("Felix Zhang" <felix.zhang.2005@gmail.com>)
List pgsql-sql
On Tue, Oct 17, 2006 at 03:39:21PM +0800, Felix Zhang wrote:

> I want to split a table to 2 small tables. The 1st one contains 60%
> records which are randomly selected from the source table.  How to do
> it?

i do my A/B-Group splitting usually by &1 the serial of the table.
assuming, that there are no irregularities in the process of creating
your entries, this should give a 50/50 split, which is reuseable for
future things and there never is a intersection of the two groups.

--
cu

Attachment

pgsql-sql by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: get_next_billing_date() ...
Next
From: "Obe, Regina"
Date:
Subject: Re: [NOVICE] How to split a table?