pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Carlos Lopez <chlopezl@yahoo.com>
To: pgsql-performance@postgresql.org
To: pgsql-admin@postgresql.org
Subject: poor performance in migrated database
Date: Sat, 6 Nov 2004 11:52:15 -0800 (PST)
Message-ID: <20041106195215.91282.qmail@web52706.mail.yahoo.com> (raw)

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.
The problem is that there are many nested views which
normally join tables by using two fields, one
character and other integer.
The biggest table has about 300k records (isn't it too
little for having performance problems?)
What could be the poor performance reason? the server
is a dual itanium (intel 64bits) processor with 6Gb of
RAM and a 36Gb Raid 5 scsi hdds of 15k rpm.
If someone has the time and wants to check the
structure, I have a copy of everything at
http://www.micredito.com.sv/.carlos/materiales.sql.bz2
it is a pgsqldump made with postgres 7.4
Thanks in advance for your help.

Carlos Lopez Linares.


=====
___
Ing. Carlos López Linares
IT Consultant
Quieres aprender linux?
visita http://www.aprende-linux.com.sv


		
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com 
 




view thread (8+ messages)  latest in thread

Message-ID: <20041106195215.91282.qmail@web52706.mail.yahoo.com>
Permalink:  ../20041106195215.91282.qmail@web52706.mail.yahoo.com/
Also on:    postgresql.org/message-id/20041106195215.91282.qmail@web52706.mail.yahoo.com

 · 

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: chlopezl@yahoo.com, pgsql-admin@postgresql.org
  Subject: Re: poor performance in migrated database
  In-Reply-To: <20041106195215.91282.qmail@web52706.mail.yahoo.com>

* 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