pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Query Time is Slow
2+ messages / 2 participants
[nested] [flat]

* Query Time is Slow
@ 2013-02-08 22:13 Foster, Kristian B (HSC) <kristian-foster@ouhsc.edu>
  2013-02-08 22:45 ` Re: Query Time is Slow Kevin Grittner <kgrittn@ymail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Foster, Kristian B (HSC) @ 2013-02-08 22:13 UTC (permalink / raw)
  To: pgsql-performance

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 environments.
The parameters we have modified on postgresql.confi are the following:

*         shared_buffers = 24MB to 512 MB to 4GB

*         work_mem = 1MB to 512MB to 1GB

*         maintenance_work = 16MB to 1GB

*         temp_buffers = 8MB to 1GB

*         effective_cache_size = 128MB to 1024MB to 16GB

*         autovacuum = on to off

Currently the queries are running about 4x slower on postgres than sql server.  Is there any settings I need to check?

Thanks
Kristian

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Query Time is Slow
  2013-02-08 22:13 Query Time is Slow Foster, Kristian B (HSC) <kristian-foster@ouhsc.edu>
@ 2013-02-08 22:45 ` Kevin Grittner <kgrittn@ymail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Kevin Grittner @ 2013-02-08 22:45 UTC (permalink / raw)
  To: Foster, Kristian B \(HSC\) <kristian-foster@ouhsc.edu>; pgsql-performance

"Foster, Kristian B (HSC)" <kristian-foster@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:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

That is likely to yield good advice which will help all queries,
but if anything remains slow after the first one is sorted out,
pick another.

-Kevin


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2013-02-08 22:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-02-08 22:13 Query Time is Slow Foster, Kristian B (HSC) <kristian-foster@ouhsc.edu>
2013-02-08 22:45 ` Kevin Grittner <kgrittn@ymail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox