Re: Partitioning an existing table
От
Vick Khera
Тема
Re: Partitioning an existing table
Дата
Msg-id
BANLkTi=h1DG9XCCreO_3pCjACjW4zVpCXQ@mail.gmail.com
Ответ на
Re: Partitioning an existing table (Raghavendra)
Список
Дерево обсуждения
Partitioning an existing table Phoenix Kiula <phoenix.kiula@gmail.com>
Re: Partitioning an existing table Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Partitioning an existing table "David Johnston" <polobo@yahoo.com>
Re: Partitioning an existing table Vick Khera <vivek@khera.org>
Re: Partitioning an existing table Greg Smith <greg@2ndQuadrant.com>
Re: Partitioning an existing table Phoenix Kiula <phoenix.kiula@gmail.com>
Re: Partitioning an existing table Vick Khera <vivek@khera.org>
Re: Partitioning an existing table Greg Smith <greg@2ndquadrant.com>
Re: Partitioning an existing table Raghavendra <raghavendra.rao@enterprisedb.com>
Re: Partitioning an existing table Raghavendra <raghavendra.rao@enterprisedb.com>
Re: Partitioning an existing table Vick Khera <vivek@khera.org>
Re: Partitioning an existing table Raghavendra <raghavendra.rao@enterprisedb.com>
Re: Partitioning an existing table Dimitri Fontaine <dimitri@2ndQuadrant.fr>
On Mon, Apr 25, 2011 at 10:53 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
1. Send all the data to .csv file with COPY TO command of the base table(which will undergo for partition).2. Create the partition setup with TRIGGER's3. Use COPY FROM command for inserting data into partition table.
so now when your running application goes to query the table, it gets doubles? if you do it in transactions, then how long are you going to cause the master table to be locked when doing such a bulk delete?
my point is to minimize service interruption, and that means moving small hunks at a time to minimize the locks needed.
В списке pgsql-general по дате отправления
