tag:blogger.com,1999:blog-20038672.post4538507979847800357..comments2024-03-28T00:58:29.187-04:00Comments on Robert Haas: Global Temporary and Unlogged TablesRobert Haashttp://www.blogger.com/profile/08393677427643988650noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-20038672.post-31810745299245166962018-05-17T14:01:32.921-04:002018-05-17T14:01:32.921-04:00Temporary tables are always unlogged. There would...Temporary tables are always unlogged. There would be no point to writing WAL for a temporary table.Robert Haashttps://www.blogger.com/profile/08393677427643988650noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-15149511209861508172018-03-15T22:42:30.713-04:002018-03-15T22:42:30.713-04:00Using 10.3 on a 1.3 billion entry DB.
Import takes...Using 10.3 on a 1.3 billion entry DB.<br />Import takes several days and we are not worried about crashing, losing data or else.<br />We developed a parallel import by using separate sessions which create temporary tables first for some intermediate work, then insert into main table when done.<br />We would like to make the temporary session tables unlogged but 10.3 doesn't allow that. A table can only be EITHER unlogged OR temporary but we think that specifically temp AND unlogged are useful.<br />Please consider this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20038672.post-20228874912386273192016-02-17T17:22:04.986-05:002016-02-17T17:22:04.986-05:00You could probably do that with a tablespace. Moun...You could probably do that with a <a href="http://www.postgresql.org/docs/9.5/static/manage-ag-tablespaces.html" rel="nofollow">tablespace</a>. Mount your SSD at an appropriate location, and beware the caveats on that page.<br />GreenReaperhttps://www.blogger.com/profile/04490769419978225723noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-32242980088027572692013-05-29T13:37:27.840-04:002013-05-29T13:37:27.840-04:00A useful thing would be to let some tables be stor...A useful thing would be to let some tables be stored on a ramdisk only, while others on normal hard disks. AFAIK this is not possible today. <br /><br />Not all tables have the same "importance". Some may be used for temporary data, even heavily used, but non critical at all. Doing so would improve performance, and reduce the stress on hard disks and, even more, on solid state drives.Pietrohttps://www.blogger.com/profile/14129475981160022554noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-67788359500177323802012-12-06T16:54:13.871-05:002012-12-06T16:54:13.871-05:00Working on a PeopleSoft on Oracle project, just st...Working on a PeopleSoft on Oracle project, just started wishing that Oracle was as cool as PostgreSQL and had unlogged tables. There is a table that is daily truncated and loaded (summary data to improve reporting performance). Not logging that monster would make the logs take a lot less disk, and would make it require a lot less bandwidth to a hot fail over server.<br /><br />New use case: Reduce bandwidth to a hot fail over server when the data can be reproduced on the target system.Grant Johnsonhttps://www.blogger.com/profile/06772023212277928936noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-14733119384827408982012-06-20T23:56:42.931-04:002012-06-20T23:56:42.931-04:00I'm looking forward to seeing the global tempo...I'm looking forward to seeing the global temporary tables. Maybe in 9.3?<br /><br />My use case: In a web app, at the beginning of the request, I'd like to set a variable that represents the current user's id. I'd like to be able to access that user's id in subsequent queries, views, etc.joevandykhttps://www.blogger.com/profile/17835717350954324810noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-14297761228498635922012-06-20T23:54:36.300-04:002012-06-20T23:54:36.300-04:00I'm looking forward to seeing this! Maybe in 9...I'm looking forward to seeing this! Maybe in 9.3?joevandykhttps://www.blogger.com/profile/17835717350954324810noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-12870119444833856672011-10-03T12:35:03.799-04:002011-10-03T12:35:03.799-04:00@MK: I'm not quite sure what you mean by tempo...@MK: I'm not quite sure what you mean by temporary tables which can survive session destruction. 9.1 does have unlogged tables, which might do what you need. Global temporary tables are not implemented yet, but might be someday (probably not for 9.2, though).Robert Haashttps://www.blogger.com/profile/08393677427643988650noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-20173636158167781162011-10-01T13:38:07.141-04:002011-10-01T13:38:07.141-04:00PG 9.1 was released and it doesn't have temp t...PG 9.1 was released and it doesn't have temp tables wich can survie session destruction. Do You know if these kind of table will be ever implemented?MKhttps://www.blogger.com/profile/09099979752371256423noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-44034213234282344022010-05-20T15:25:25.029-04:002010-05-20T15:25:25.029-04:00Very useful features. If half the ideas floating ...Very useful features. If half the ideas floating around for 9.1 make it in that release I'll be more excited about it than the upcoming one!Chris Spottshttps://www.blogger.com/profile/15071378159488654217noreply@blogger.com