Start off, I'm new to postgres. I'm running Ubuntu 10.04.04 with postgres 9.1
on a VM with 32 GB of RAM.
I'm trying to increase the response time on submitted queries. I'm comparing
the same queries to a SQL Server instance with the same data sets.
The queries are used in our Analytics
Foster, Kristian B (HSC) kristian-fos...@ouhsc.edu wrote:
Currently the queries are running about 4x slower on postgres than
sql server. Is there any settings I need to check?
Your best bet would be to pick one query and follow the steps
recommended here:
Richard Huxton wrote:
Ruben Rubio Rey wrote:
Hi,
I think im specting problems with a 7.4.8 postgres database.
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in
Information, Ruben - we can't do anything without information.
What usefull information could I provide?
Offending queries, EXPLAIN ANALYZE, tables description, condiguration
parameters, hardware, intended use...
---(end of broadcast)---
Hi,
I think im specting problems with a 7.4.8 postgres database.
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in normal circunstances.
Why sometimes its takes too
Rubio
Rey
Sent: Friday, March 10, 2006 2:06 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Query time
Hi,
I think im specting problems with a 7.4.8 postgres database.
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend
On Fri, Mar 10, 2006 at 11:05:57AM +0100, Ruben Rubio Rey wrote:
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in normal circunstances.
Is it the *exact* same
Michael Fuhr wrote:
On Fri, Mar 10, 2006 at 11:05:57AM +0100, Ruben Rubio Rey wrote:
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in normal circunstances.
Ruben Rubio Rey wrote:
Hi,
I think im specting problems with a 7.4.8 postgres database.
Sometimes some big query takes between 5 to 15 seconds. It happens
sometimes all the day it does not depend if database is busy.
I have measured that sentence in 15 - 70 ms in normal circunstances.
Why
On Fri, Mar 10, 2006 at 11:29:53AM +0100, Ruben Rubio Rey wrote:
There is not possibility to use another database. It's the best option I
have seen. We have been working in postgres in last 3 years, and this is
the first problem I have seen. (The database is working in a large
website,
10 matches
Mail list logo