Re: create table as select VS create table; insert as select - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: create table as select VS create table; insert as select
Date
Msg-id AANLkTi=+WtGyAns8N0n_ZdGgbuz6dD-S-CHH0P1bGTnG@mail.gmail.com
Whole thread Raw
In response to create table as select VS create table; insert as select  (Jacqui Caren-home <jacqui.caren@ntlworld.com>)
List pgsql-general
Hi,

On 29 October 2010 11:46, Jacqui Caren-home <jacqui.caren@ntlworld.com> wrote:
> I have inherited an application that populates a number of
> temp.y tables using create table ... as select ...

What is the principle of creating this temp.y tables?
May be table partitioning is better to implement here -
http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html

>
> This is taking roughly five to ten minutes to run
>
> As this process hammers the database, I can only run benchmarks at night so
> am asking here if anyone know if
>
> create table ...; then insert into ... as select... ; would be faster.
>
> or if anyone can suggest an alternative I may have missed.
>
> I am happy to move code server side if need be.
>
> TIA
>
> Jacqui
>
> I know these is not a lot of detail in the above - the system is under NDA
> and I need to check with my employer before I give out any system details.
>
> Before you ask it is not a big customer - just a very paranoid one :-)
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp

pgsql-general by date:

Previous
From: "Jan C."
Date:
Subject: pg_restore -t table doesn't restore PKEY
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: share lock when only one user connected?