Skip site navigation (1) Skip section navigation (2)

Re: scale up (postgresql vs mssql)

From: Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: scale up (postgresql vs mssql)
Date: 2012-06-20 06:01:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hi, all.

this is an obligation from the past:

the same test, that did ~230 results, is now doing ~700 results. that is,
BTW even better than mssql.

the ultimate solution for that problem was to NOT to do "ON COMMIT DELETE
ROWS" for the temporary tables. instead, we just do "DELETE FROM

doing "TRUNCATE temp_table1" is defiantly the worst case (~100 results in
the same test). this is something we knew for a long time, which is why we
did "ON COMMIT DELETE ROWS", but eventually it turned out as far from being
the best.

another minor issue is that when configuring
 temp_tablespace='other_tablespace', the sequences of the temporary tables
remain on the 'main_tablespace'.

i hope that will help making postgres even better :)


pgsql-performance by date

Next:From: Sergey KonoplevDate: 2012-06-20 13:36:20
Subject: Re: Why is a hash join being used?
Previous:From: Eyal WildeDate: 2012-06-20 04:46:48
Subject: index-only scan is missing the INCLUDE feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group