PostgreSQL in memory database performance issue

Question

I'm trying to speed up my django unit test, so I wrote custom database backend using for test purposes another tablespace located in memory. But I found no real advantages, the time my test running in memory remains the same.

Then I created two similar tables using different tablespaces and run 10000 inserts for the each one. Time for the both queries was about 1 sec.

Am I missing something? Why database located in memory doesn't shows performance grow?

have you tried making your backend such that it never creates any indexes? — Peter Bengtsson
– Peter Bengtsson, Commented Sep 24, 2010 at 14:02

Magnus Hagander · Accepted Answer · 2010-09-22 14:35:08Z

1

For inserts, you were most likely just limited by the writes to the transaction log (pg_xlog). This is not affected by you moving the tables to a different tablespace. That only comes into effect once you write enough data to go beyond what fits in the cache and/or when you run a checkpoint in the test - and 10,000 rows and 1 second is nowhere near enough to reach that.

answered Sep 22, 2010 at 14:35

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL in memory database performance issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related