From: | Matthew Hagerty <matthew(at)venux(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Is INSERT FROM considered a transaction? |
Date: | 2001-03-08 21:14:08 |
Message-ID: | 5.0.2.1.2.20010308160353.02c8d2d8@pop3.venux.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Greetings,
Sorry about all the posts lately, but things seems to be running *really*
slow on my database. I have two tables, both are identical and one is used
to hold entries older than a certain date, i.e. the history table. I use
this query to move the old records from one to the other. In this case, is
each insert part of a big transaction that commits when it is done, or is
each insert its own transaction? Is there anything I can do to make this
faster? On average the entries table has about 50,000 records and the
history_entries table has about 3.5 million.
insert into history_entries
select * from entries where domain='somevalue' and time_stamp between
'date1' and 'date2'
Thanks,
Matthew
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Hagerty | 2001-03-08 21:30:40 | Is INSERT FROM considered a transaction? |
Previous Message | Tom Lane | 2001-03-08 21:06:16 | Use SIGQUIT instead of SIGUSR1? |