From: Bruno Wolff III <bruno@wolff.to>
To: Jeevanandam, Kathirvel \(IE10\) <Jeevanandam.Kathirvel@honeywell.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: rotate records
Date: Mon, 27 Feb 2006 23:08:31 -0600
Message-ID: <20060228050831.GA12351@wolff.to> (raw)
In-Reply-To: <CB23ED848A082748B413D5AE98DDFC3D69FA1A@IE10EV801.global.ds.honeywell.com>
References: <CB23ED848A082748B413D5AE98DDFC3D69FA1A@IE10EV801.global.ds.honeywell.com>
On Tue, Feb 28, 2006 at 09:14:59 +0530,
"Jeevanandam, Kathirvel (IE10)" <Jeevanandam.Kathirvel@honeywell.com> wrote:
> Hi all,
Please don't hijack existing threads to start new ones. This can cause
people to miss your question and messes up the archives.
Performance questions should generally be posted to the performance list.
I have redirected followups to there.
>
> I am facing performance issues even with less than 3000 records, I am
> using Triggers/SPs in all the tables. What could be the problem.
> Any idea it is good to use triggers w.r.t performance?
A common cause of this kind of thing is not running vacuum often enough
leaving you with a lot of dead tuples.
You should probably start by doing a vacuum full analyse and then showing
the list some problem query sources along with explain analyse output
for them.
>
> Regards,
> Jeeva.K
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
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: bruno@wolff.to, Jeevanandam.Kathirvel@honeywell.com, pgsql-general@postgresql.org
Subject: Re: rotate records
In-Reply-To: <20060228050831.GA12351@wolff.to>
* 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