| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Waller, David" <Waller_D(at)imsdm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Insert statements really slow |
| Date: | 2007-11-14 02:44:07 |
| Message-ID: | b42b73150711131844g209da3a9u6ed38241b4ce54ba@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Nov 9, 2007 12:53 PM, Waller, David <Waller_D(at)imsdm(dot)com> wrote:
> I have an application that I am porting from MySQL to PostgreSQL and I am
> working on the import Perl script that process the data.
>
> The data is web log data and each line has a variable amount of the fields
> (mostly because of cookies) so I am using a lot of insert statements.
>
> In MySQL I go through a file in about 2 minutes and it is taking about 30 in
> PG. I have removed all but the primary key index and have done a BEGIN and
> COMMIT after turning off AUTOCOMMIT.
can you give us a better idea of the # records/sec we are talking
about here? mysql and pg are usually pretty close in insert
performance. maybe there is something fishy going on.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2007-11-14 02:58:42 | Re: [HACKERS] plperl and regexps with accented characters - incompatible? |
| Previous Message | Rick Grandy | 2007-11-13 23:27:51 | JOB WITH SUN MICROSYSTEMS!!! |