From: Justin <justin@emproshunts.com>
To: mark <markkicks@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: select query takes 13 seconds to run with index
Date: Mon, 26 May 2008 20:05:20 -0400
Message-ID: <483B5040.30600@emproshunts.com> (raw)
In-Reply-To: <82fa9e310805261657u4a84b5fftd3abb50314f18815@mail.gmail.com>
References: <82fa9e310805261549m2362fbe8sbf18789938fee833@mail.gmail.com>
<483B4729.7050402@emproshunts.com>
<82fa9e310805261632y46f306fdh84e2da62ffbd7873@mail.gmail.com>
<483B4C74.7000703@emproshunts.com>
<82fa9e310805261657u4a84b5fftd3abb50314f18815@mail.gmail.com>
mark wrote:
>>
>>
>>
>> Size of the Table
>>
>>
>> 22 million rows approximately
>>
>>
>> I have no experience on large datasets so people with more experience in
>> this area are going to have to chime in.
>> My gut feel is 13 seconds for Postgresql to sort through an index of that
>> size and table is not bad.
>>
>> you may need to take a look at hardware and postgresql.config settings to
>> improve the performance for this query
>>
>> This query is very simple where changing it around or adding index results
>> massive improvements is not going to help in this case.
>>
> the hardware is e5405 dual quad core on a 16GB RAM machine, with 8.3.1
> default settings except maximum connections increased...
>
That could be problem, Postgresql default settings are very conservative.
You need to read http://www.postgresqldocs.org/wiki/Performance_Optimization
and tune posgtresql.config settings.
What OS are you running?
What is Disk Subsystem setup???
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: justin@emproshunts.com, markkicks@gmail.com, pgsql-general@postgresql.org
Subject: Re: select query takes 13 seconds to run with index
In-Reply-To: <483B5040.30600@emproshunts.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox