From: | Felson <felson123(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: full table... |
Date: | 2002-08-20 16:16:02 |
Message-ID: | 20020820161602.45552.qmail@web13005.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am on 7.0 I am plaing an upgade at the end of the
week as I am getting a new server to put it on. As for
rules, there are a number of indexs, and 2 forign key
rules.
here are all the indexes, and triggers on the table as
per pg_dump -Dst
CREATE UNIQUE INDEX "channeldata_id_key" on
"channeldata" using btree ( "id" "int4_ops" );
CREATE UNIQUE INDEX "channeldata_unique_ts_cd_id_key"
on "channeldata" using btree ( "cd_id" "int4_ops",
"tstamp" "timestamp_ops" );
CREATE INDEX "channeldata_cd_id_index" on
"channeldata" using btree ( "cd_id" "int4_ops" );
CREATE INDEX "channeldata_tstamp_index" on
"channeldata" using btree ( "tstamp" "timestamp_ops"
);
CREATE INDEX "channeldata_s_id_index" on
"channeldata" using btree ( "s_id" "int4_ops" );
CREATE CONSTRAINT TRIGGER "channeldata_cd_id_key"
AFTER INSERT OR UPDATE ON "channeldata" NOT
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
PROCEDURE "RI_FKey_check_ins"
('channeldata_cd_id_key', 'channeldata', 'channel',
'UNSPECIFIED', 'cd_id', 'id');
CREATE CONSTRAINT TRIGGER "channeldata_s_id_key" AFTER
INSERT OR UPDATE ON "channeldata" NOT DEFERRABLE
INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE
"RI_FKey_check_ins" ('channeldata_s_id_key',
'channeldata', 'site', 'UNSPECIFIED', 's_id', 'id');
I tried to drop the 2 triggers, but it told me they
didn't exist... If I select on the pd_triggers I can
see them in there though...
I gess one other point that I should mention, is taht
the computer is 500 MhZ 256MB RAM and an IDE hard
drive... I will have a real server this week or next.
But I need to be colecting that data in the
meantime...
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Felson <felson123(at)yahoo(dot)com> writes:
> > Acutely, there are 7 inserts that that take place
> on
> > that table before it can talk to the unit that is
> > broadcasting to me again...
> > There is a unique constraint on (tstamp, cd_id)
> but
> > removing it didn't fix the speed issue...
> > I am at about 3,000,000 rows give or take a few
> > thousand.
>
> Three million rows is not "huge", it's more in the
> barely-enough-to-notice class. There is no way that
> seven inserts should
> take even a second. I've got to think that you're
> firing triggers or
> rules that are chewing the time.
>
> Which version did you say you are using? 7.2's psql
> will list triggers
> and rules when you say "\d table", but I'm not sure
> earlier releases will.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-08-20 16:20:58 | Re: full table... |
Previous Message | Tom Lane | 2002-08-20 15:51:43 | Re: full table... |