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 table is referenced by other table
