On 07/07/2013 08:21 PM, Alex Decalli wrote: > Hello everybody > I want to cleanup my session table, it is already about 1 Gigabyte! I hit: > > me@myserver:~$ sudo rt-clean-sessions --debug --older 1M
That reminds me - is there any reason RT would get upset if the sessions table was suddenly empty after a restart? I'm wondering if it should be an UNLOGGED table on PostgreSQL 9.1 and above, so it doesn't incur write-ahead logging overhead. If it doesn't need to be crash-safe and it's OK to just have it truncated after a crash recovery restart, that'd be ideal. Thoughts? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
