full table delete query

From: "hari(dot)prasath" <hari(dot)prasath(at)zohocorp(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: full table delete query
Date: 2016-05-03 12:51:36
Message-ID: 15476ac7d90.129407c286117.5541529776983541411@zohocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 &gt;&gt; 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

cheers

- Harry

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2016-05-03 13:25:59 Re: pgindent fixups
Previous Message Rushabh Lathia 2016-05-03 11:04:49 pg_dump broken for non-super user