| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Tom Laudeman <twl8n(at)virginia(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tuning to speed select |
| Date: | 2006-08-09 13:46:38 |
| Message-ID: | 20060809134638.GM22329@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 09, 2006 at 09:19:31AM -0400, Tom Laudeman wrote:
> Hi,
>
> I'm running PostgreSQL version 8 on a dual 2.4GHz Xeon with 1GB of RAM
> and an IDE hard drive. My big table has around 9 million records.
>
> Is there a tuning parameter I can change to increase speed of selects?
> Clearly, there's already some buffering going on since selecting an
> indexed ~50,000 records takes 17 seconds on the first try, and only 0.5
> seconds on the second try (from pgsql).
Your OS is probably buffering, 1GB of RAM holds a lot of data. You can
try increasing the shared_buffers parameter, but if the delay is
getting data from the disk, that won't really help you.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-08-09 14:04:18 | Re: Tuning to speed select |
| Previous Message | Tomi NA | 2006-08-09 13:42:10 | Re: Data warehouse & OLAP |