Re: [NOVICE] How to split a table?

Поиск
Список
Период
Сортировка
От Christoph Frick
Тема Re: [NOVICE] How to split a table?
Дата
Msg-id 20061017092616.GH3822@byleth.sc-networks.de
обсуждение исходный текст
Ответ на How to split a table?  ("Felix Zhang" <felix.zhang.2005@gmail.com>)
Список 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

Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: get_next_billing_date() ...
Следующее
От: "Obe, Regina"
Дата:
Сообщение: Re: [NOVICE] How to split a table?