postgres too slow

Posted by Killercode on Stack Overflow See other posts from Stack Overflow or by Killercode
Published on 2010-06-16T12:32:03Z Indexed on 2010/06/16 12:32 UTC
Read the original article Hit count: 179

Filed under:

Hi,

I'm doing massive tests on a Postgres database...

so basically I have 2 table where I inserted 40.000.000 records on, let's say table1 and 80.000.000 on table2

after this I deleted all those records.

Now if I do SELECT * FROM table1 it takes 199000ms ?

I can't understand what's happening?

can anyone help me on this?

© Stack Overflow or respective owner

Related posts about postgresql