On 2015-05-31 07:04, Jean-David Beyer wrote: > On 05/30/2015 09:46 AM, Ashik S L wrote: >> We are using postgres SQL version 8.4.17.. >> Postgres DB szie is 900 MB and we are inserting 273 rows at once .and >> each row is of 60 bytes.Every time we insert 16380 bytes of data. > > Way back when, I was inserting a lot of rows of date (millions of rows) > and it was taking many hours on a machine with 6 10,000 rpm Ultra/320 > SCSI hard drives and 8 GBytes of ram. Each insert was a separate > transaction. > > When I bunched up lots of rows (thousaands) into a single transaction, > the whole thing took less than an hour. Or use copy, \copy if possible, or a "temporary" unlogged table to copy from later, etc... > Is it possible that when you insert 273 rows at once, you are doing it > as 273 transactions instead of one? That's the thing, even on an old laptop with a slow IDE disk, 273 individual inserts should not take more than a second. -- http://yves.zioup.com gpg: 4096R/32B0F416 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
