tag:blogger.com,1999:blog-8839574367290288724.post6514806987633394946..comments2023-12-11T13:13:11.330-08:00Comments on Pavel Stehule's blog: plpgsql and temp. tablesPavel Stěhulehttp://www.blogger.com/profile/01996484227228696817noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8839574367290288724.post-59597951882064133072008-11-19T12:30:00.000-08:002008-11-19T12:30:00.000-08:00I did these tests on 8.4.Three years ago I found, ...I did these tests on 8.4.<BR/><BR/>Three years ago I found, so delete on really small tables is faster than truncate.Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-23334403331687602282008-11-19T10:07:00.000-08:002008-11-19T10:07:00.000-08:00Maybe try one where you TRUNCATE the table rather ...Maybe try one where you TRUNCATE the table rather than DELETE from it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-18507506047112274202008-11-19T06:18:00.000-08:002008-11-19T06:18:00.000-08:00Which version this interesting finding applies to?...Which version this interesting finding applies to?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8839574367290288724.post-30399809255813555432008-11-18T12:18:00.000-08:002008-11-18T12:18:00.000-08:00s/tree/three/;s/tree/three/;Anonymousnoreply@blogger.com