Is INSERT FROM considered a transaction?

From: Matthew Hagerty <mhagerty(at)voyager(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Is INSERT FROM considered a transaction?
Date: 2001-03-08 21:30:40
Message-ID: 5.0.2.1.2.20010308163035.02b55c28@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

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Myers 2001-03-08 21:33:50 Re: Use SIGQUIT instead of SIGUSR1?
Previous Message Matthew Hagerty 2001-03-08 21:14:08 Is INSERT FROM considered a transaction?