Re: rotate records

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Jeevanandam, Kathirvel \(IE10\)" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: rotate records
Date: 2006-02-28 05:08:31
Message-ID: 20060228050831.GA12351@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Tue, Feb 28, 2006 at 09:14:59 +0530,
"Jeevanandam, Kathirvel (IE10)" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-28 06:09:25 Re: How many postmasters should be running?
Previous Message Tino Wildenhain 2006-02-28 05:04:05 triggers, performance Was: Re: rotate records

Browse pgsql-performance by date

  From Date Subject
Next Message Jeevanandam, Kathirvel (IE10) 2006-02-28 05:54:34 Re: triggers, performance Was: Re: [GENERAL] rotate records
Previous Message Tino Wildenhain 2006-02-28 05:04:05 triggers, performance Was: Re: rotate records