Re: [PERFORM] Query Time is Slow

2013-02-08 Thread Kevin Grittner
"Foster, Kristian B (HSC)" 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: http://wiki.postgresql.org/wiki/SlowQueryQuestions That i

[PERFORM] Query Time is Slow

2013-02-08 Thread Foster, Kristian B (HSC)
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 enviro

Re: [PERFORM] Query time

2006-03-13 Thread PFC
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)--- T

Re: [PERFORM] Query time

2006-03-13 Thread Ruben Rubio Rey
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 nor

Re: [PERFORM] Query time

2006-03-10 Thread Jim C. Nasby
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, 6

Re: [PERFORM] Query time

2006-03-10 Thread Richard Huxton
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 s

Re: [PERFORM] Query time

2006-03-10 Thread Ruben Rubio Rey
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.

Re: [PERFORM] Query time

2006-03-10 Thread Michael Fuhr
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 qu

Re: [PERFORM] Query time

2006-03-10 Thread Ruben Rubio Rey
Ruben 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 depe

[PERFORM] Query time

2006-03-10 Thread Ruben Rubio Rey
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 m