On Fri, Nov 23, 2012 at 2:43 PM, Peter Kroon <plakr...@gmail.com> wrote:
> I've converted some mssql functions and they appear to be slower in pgsql. > I use a lot of declared tables in mssql as they are created in memory. > Which makes it very fast. > > > > 2012/11/23 Peter Kroon <plakr...@gmail.com> > >> Is a temp table created to memory(ram) or disk? >> I've converted some msssq >> > > While the temporary table is in-use, For a small table the data will be in the memory, For a large table if data is not fit in memory then data will be flushed to disk periodically as the database engine needs more working space for other requests. A permanent table persist after terminating PostgreSQL session, whereas temporary table is automatically destroyed when PostgreSQL session ends. The memory is controlled by temp_buffers parameter (postgresql.conf) -- Thanks & Regards, Raghu Ram EnterpriseDB Corporation Blog:http://raghurc.blogspot.in/
