Postgres Pro
Downloads
Home   >   mailing lists

Re: Large number of open(2) calls with bulk INSERT into empty table - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Large number of open(2) calls with bulk INSERT into empty table
Date
Msg-id 827h29q4pd.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Large number of open(2) calls with bulk INSERT into empty table  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Large number of open(2) calls with bulk INSERT into empty table
List pgsql-hackers
Tree view 
* Robert Haas:

> I tried whacking out the call to GetPageWithFreeSpace() in
> RelationGetBufferForTuple(), and also with the unpatched code, but the
> run-to-run randomness was way more than any difference the change
> made.  Is there a better test case?

I think that if you want to exercise file system lookup performance, you
need a larger directory, which presumably means a large number of
tables.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pg_cancel_backend by non-superuser
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade if 'postgres' database is dropped