| 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 >> 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
| 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 |