Search Postgresql Archives

How does Delete Query work ??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,


   I want to know about the flow in which delete query is executed in postgres .
Assume i have a following query.

Delete from table_a * where column_a = 'something' 

How is this query executed ? Are the rows first filtered out and then deleted one by one ?? Or is the row deleted as and when it is filtered ??

Thanks,
Harsha


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux