Re: Large object insert performance. - Mailing list pgsql-general

From Peter Haight
Subject Re: Large object insert performance.
Date
Msg-id 200008250050.RAA41954@wartch.sapros.com
Whole thread Raw
In response to Large object insert performance.  (Peter Haight <peterh@sapros.com>)
Responses Re: Large object insert performance.  (Radoslaw Stachowiak <radek@alter.pl>)
List pgsql-general
>Peter Haight <peterh@sapros.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.


pgsql-general by date:

Previous
From: Franck Martin
Date:
Subject: RE: VARCHAR with null
Next
From: Tatsuo Ishii
Date:
Subject: Re: sorting in UNICODE table