On Fri, Nov 23, 2012 at 2:43 PM, Peter Kroon <plakroon@xxxxxxxxx> 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 <plakroon@xxxxxxxxx>Is a temp table created to memory(ram) or disk?I've converted some msssq
Not exactly as MS Sql declare tables.
In PostgreSQL, TEMP tables are session-private. These tables are session based and stored in a special schema and visible only to the backend which has created. Memory management is controlled with temp_buffer(shared by all backends) in postgresql.conf.
You should check UNLOGGED tables of same family, these tables are visible to all the backends and data shared across backends.
Since, data is not written to WAL's you should get better performance.
