On Thu, Aug 26, 2010 at 23:13, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Aug 26, 2010 at 2:29 PM, Maria L. Wilson
maria.l.wilso...@nasa.gov wrote:
we have this application (using jboss/java/hibernate) on linux accessing
data on 3 postgres database servers using 8.4.1.
One of our
@Pierre: i know.. but first i'd have to find such a query from real-life.
And also, i'm convinced that this query would be faster with a seqscan if
the data wenen't cached.
@Arjen: thanks, that helps.
But that's only the OS cache. There's also the shared_buffers, which are a
postgres specific
Ozer, Pam po...@automotive.com wrote:
I am new to Postgres and I am trying to understand the Explain
Analyze so I can tune the following query.
Fair enough. If you wanted advice from others on how to tune the
query, you would need to provide additional information, as
described here:
Scott Carey wrote:
But the select count(*) query, cached in RAM is 3x faster in one system than
the other. The CPUs aren't 3x different performance wise. Something else may
be wrong here.
An individual Core2 Duo 2.93Ghz should be at most 50% faster than a 2.2Ghz
Opteron for such a query.
Willy-Bas Loos wrote:
But that's only the OS cache. There's also the shared_buffers, which
are a postgres specific thing.
I've found DISCARD in the manual
http://www.postgresql.org/docs/8.3/interactive/sql-discard.html, but
that only influences a single session, not the shared buffers.
I
Ozer, Pam wrote:
I am new to Postgres and I am trying to understand the Explain Analyze
so I can tune the following query.
You should try http://explain.depesz.com/ , where you can post query
plans like this and see where the time is going in a very easy to work
with form. It will
On Thu, Aug 26, 2010 at 4:32 AM, Willy-Bas Loos willy...@gmail.com wrote:
Hi,
I have a colleague that is convinced that the website is faster if
enable_seqscan is turned OFF.
I'm convinced of the opposite (better to leave it ON), but i would like to
show it, prove it to him.
Stop, you're
On 8/27/10 5:21 PM, Ozer, Pam wrote:
I have a query that
Select Distinct VehicleId
From Vehicle
Where VehicleMileage between 0 and 15000.
I have an index on VehicleMileage. Is there another way to put an index on a
between? The index is not being picked up. It does get picked up when I run