From: | Mark Dobbrow <mdobbrow(at)yahoo(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Large table performance |
Date: | 2007-01-13 00:31:09 |
Message-ID: | 376735.48483.qm@web35309.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello -
I have a fairly large table (3 million records), and am fetching 10,000 non-contigous records doing a simple select on an indexed column ie
select grades from large_table where teacher_id = X
This is a test database, so the number of records is always 10,000 and i have 300 different teacher ids.
The problem is, sometimes fetching un-cached records takes 0.5 secs and sometimes (more often) is takes more like 10.0 seconds
(fetching the same records for a given teacher_id a second time takes about 0.25 secs)
Has anyone seen similar behavior or know what the solution might be?
any help much appreciated,
Mark
ps. My shared_buffers is set at 5000 (kernal max), and work_mem=8192
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2007-01-13 00:40:25 | Re: Large table performance |
Previous Message | Simon Riggs | 2007-01-12 19:50:54 | Re: [HACKERS] table partioning performance |