Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group