Re: [HACKERS] Making table reloading easier

2016-11-03 Thread Michael Paquier
On Thu, Nov 3, 2016 at 11:37 PM, Corey Huinker wrote: >> ALTER TABLE my_table >> DISABLE INDEX ALL; > > +1 > This very thing came up in a conversation with PeterG early last year. I was > in favor then and I was surprised that the only thing standing in the way > was a lack of ALTER TABLE synt

Re: [HACKERS] Making table reloading easier

2016-11-03 Thread Corey Huinker
> > > ALTER TABLE my_table > DISABLE INDEX ALL; > +1 This very thing came up in a conversation with PeterG early last year. I was in favor then and I was surprised that the only thing standing in the way was a lack of ALTER TABLE syntax. Creating temporary data structures to mimic existing met

[HACKERS] Making table reloading easier

2016-11-02 Thread Craig Ringer
Hi all A very common operation that users perform is reloading tables. Sometimes as part of an ETL process. Sometimes as part of a dump and reload. Sometimes loading data from external DBs, etc. Right now users have to jump through a bunch of hoops to do this efficiently: BEGIN; TRUNCATE TABLE