"Mike Charnoky" <noky@xxxxxxxxxxx> writes: > Here is the output from EXPLAIN ANALYZE. This is the same query run > back to back, first time takes 42 minutes, second time takes less than 2 > minutes! That doesn't really sound strange at all. It sounds like you have a very slow disk and very large amount of memory. 40 minutes to scan 11.4M records sounds kind of high to me though. How wide are these records anyways? That is, what is the table definition for this table? If this is a single consumer drive 42 minutes sounds about right for 2k wide records being randomly accessed. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
