pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Troels Arvin <troels@arvin.dk>
To: pgsql-admin@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: poor performance in migrated database
Date: Sat, 06 Nov 2004 21:07:06 +0100
Message-ID: <pan.2004.11.06.20.07.06.409592@arvin.dk> (raw)
References: <20041106195215.91282.qmail@web52706.mail.yahoo.com>

On Sat, 06 Nov 2004 11:52:15 -0800, Carlos Lopez wrote:

> I have migrated a database from MS SQL to a
> postgresSQL database, but when running it, the results
> are very slow (and unusable) which is the only reason
> we don't entirely move to postgresSQL.

Have you run ANALYZE lately? (See manual.)

Do you know how to use EXPLAIN? (See manual.) If so: Please post an
example query which is slow, and the corresponding output from EXPLAIN.

Have you tried turning your random_page_cost a bit down? (My experience
its value should generally be lessened.)

Have you read
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html ?

> The biggest table has about 300k records (isn't it too
> little for having performance problems?)

That should be no problem.

-- 
Greetings from Troels Arvin, Copenhagen, Denmark





view thread (8+ messages)  latest in thread

Message-ID: <pan.2004.11.06.20.07.06.409592@arvin.dk>
Permalink:  ../pan.2004.11.06.20.07.06.409592@arvin.dk/
Also on:    postgresql.org/message-id/pan.2004.11.06.20.07.06.409592@arvin.dk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: troels@arvin.dk, pgsql-admin@postgresql.org
  Subject: Re: poor performance in migrated database
  In-Reply-To: <pan.2004.11.06.20.07.06.409592@arvin.dk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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