"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
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
I was wondering if somebody could clear up how tablespaces are used.
Let's say I have three classes of storage:
- ramdisk (tmpfs)
- SSD
- spinning rust
Furthermore, let's say I'd like to be able to tell postgresql to
prefer them - in that order - until they each get full. IE, use tmpfs
until it re
Hi Jesper and Pavel
Thx for your hints.
I'm rather reluctant in tuning with unwanted side effects, We'll see.
I have to setup my system and db again before I can try out your tricks.
Yours, Stefan
2013/2/8 Jesper Krogh :
> On 08/02/13 01:52, Stefan Keller wrote:
>>
>> Hi,
>>
>> I have problems w
This query http://pgsql.privatepaste.com/359bed8e9e gets executed every
500 ms and normally completes really quickly
http://explain.depesz.com/s/poVQ, but the more job_batches table
(http://pgsql.privatepaste.com/eaf6d63fd2) gets used, the slower this
query gets, to the point where it takes min
