[GENERAL] Extremely slow performance with 'select *' after insert of 37,000 records

The table in question is a simple users table. The details are at the bottom of this message. The performance on this table was fine during testing with less than 100 users. Then we inserted about 37,000 records into the table. Now a 'SELECT * FROM pp_users' takes over 40 seconds!!.

Re: [GENERAL] Extremely slow performance with 'select *' after insert of 37,000 records

I seem to have a problem CC: the list these days... --- Collin Peters [EMAIL PROTECTED] wrote: Running the query 'EXPLAIN ANALYZE SELECT * FROM pp_users' --- Seq Scan on pp_users (cost=0.00..1597.26 rows=37326 width=1102) (actual