| 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: | Whole Thread | Raw Message | 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? |