Re: [HACKERS] full table delete query

2016-05-03 Thread David G. Johnston
On Tue, May 3, 2016 at 5:51 AM, hari.prasath wrote: > Hi all, > How postgresql handles full table delete in terms of loading the > full table in these scenarios > > consider one big table(tablename: bigtable) > and the query will be >> delete from bigtable; > >

[HACKERS] full table delete query

2016-05-03 Thread hari.prasath
Hi all, How postgresql handles full table delete in terms of loading the full table in these scenarios consider one big table(tablename: bigtable) and the query will be delete from bigtable; 1)which doesn't have any foreign table reference with any other tables 2)And when this