Re: Large object insert performance.

From: Peter Haight <peterh(at)sapros(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large object insert performance.
Date: 2000-08-25 00:50:59
Message-ID: 200008250050.RAA41954@wartch.sapros.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Peter Haight <peterh(at)sapros(dot)com> writes:
>> All I'm doing is inserting the large objects.
>
>How many LOs are we talking about here?

400,000. It gets too slow way before that, though. Around 30,000. I'm going
ahead with storing them in external files with an index in the database.
That is going very well.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2000-08-25 01:07:27 Re: sorting in UNICODE table
Previous Message brianb 2000-08-25 00:48:47 Re: Postgresql on Solaris 8