pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: rotate records 2+ messages / 2 participants [nested] [flat]
* Re: rotate records @ 2006-02-28 03:44 Jeevanandam, Kathirvel (IE10) <Jeevanandam.Kathirvel@honeywell.com> 0 siblings, 1 reply; 2+ messages in thread From: Jeevanandam, Kathirvel (IE10) @ 2006-02-28 03:44 UTC (permalink / raw) To: pgsql-general@postgresql.org Hi all, 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? Regards, Jeeva.K ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: rotate records @ 2006-02-28 05:08 Bruno Wolff III <bruno@wolff.to> parent: Jeevanandam, Kathirvel (IE10) <Jeevanandam.Kathirvel@honeywell.com> 0 siblings, 0 replies; 2+ messages in thread From: Bruno Wolff III @ 2006-02-28 05:08 UTC (permalink / raw) To: Jeevanandam, Kathirvel \(IE10\) <Jeevanandam.Kathirvel@honeywell.com>; +Cc: pgsql-general@postgresql.org; pgsql-performance 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-02-28 05:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-02-28 03:44 Re: rotate records Jeevanandam, Kathirvel (IE10) <Jeevanandam.Kathirvel@honeywell.com> 2006-02-28 05:08 ` Bruno Wolff III <bruno@wolff.to>
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