On Aug 19, 2010, at 11:25 AM, Greg Smith wrote:
> Philippe Rimbault wrote:
>> I've run "time pgbench -c 50" :
>>server x64 :
>>starting vacuum...end.
>>transaction type: TPC-B (sort of)
>>scaling factor: 1
>>query mode: simple
>>number of clients: 50
>>
> One of our many concerns has been the way we handle connections to the
> database. java/hibernate handle their own pooling so I understand that
> using anything else is out of the question.
It's not out of the question, but it's probably not necessary.
> Our jboss configuration
> current
We need more information than that, like:What version of PostgreSQL?What does the hardware look like?What does the disk and tablespace layout look like?How are your configuration variables set?Other than that, are the statistics up to date on the VehicleMake table?Bob Lunney--- On Thu, 8/26/10, Oze
On Thu, Aug 26, 2010 at 6:03 PM, Ozer, Pam wrote:
>
> I am new to Postgres and I am trying to understand the Explain Analyze so I
> can tune the following query. I run the same query using mysql and it takes
> less than 50ms. I run it on postgres and it takes 10 seconds. I feel like I
> am mi
I am new to Postgres and I am trying to understand the Explain Analyze
so I can tune the following query. I run the same query using mysql and
it takes less than 50ms. I run it on postgres and it takes 10 seconds.
I feel like I am missing something very obvious. (VehicleUsed is a big
table over 7
On Thu, Aug 26, 2010 at 2:29 PM, Maria L. Wilson
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 many concerns has been the way we handle connections to the
> database. java/hibernate handle th
Original Message
Subject:postgres 8.4.1 number of connections
Date: Thu, 26 Aug 2010 14:25:47 -0500
From: Maria L. Wilson
Reply-To: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS
APPLICATIONS]
To: pgsql-performance-ow...@postgresql.org
we have this appl
The bitmap heap scan is 3% faster,
3% isn't really significant. Especially if the new setting makes one query
100 times slower... Like a query which will, by bad luck, get turned into
a nested loop index scan for a lot of rows, on a huge table which isn't in
cache...
--
Sent via pgsql-
Isn't it more fair to just flush the cache before doing each of the
queries? In real-life, you'll also have disk caching... Flushing the
buffer pool is easy, just restart PostgreSQL (or perhaps there is a
admin command for it too?). Flushing the OS-disk cache is obviously
OS-dependent, for linu
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.
Now the first query we tried, would do a bitmap heap scan instead of a
seqscan when the latter w
10 matches
Mail list logo
