Re: Large number of tables slow insert - Mailing list pgsql-performance

From Loic Petit
Subject Re: Large number of tables slow insert
Date
Msg-id 1775c5ea0808231747m71c4e75fn9b5c45ed604edfe8@mail.gmail.com
Whole thread Raw
In response to Large number of tables slow insert  ("Loic Petit" <tls.wydd@free.fr>)
Responses Re: Large number of tables slow insert
List pgsql-performance
I was a bit confused about the read and write sorry ! I understand what you mean...
But do you think that the IO cost (of only one page) needed to handle the index writing is superior than 300ms ? Because each insert in any of these tables is that slow.
NB: between my "small" and my "big" tests the only difference is the number of table (10 and 3000), there is almost the same amount of on-disk data

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Large number of tables slow insert
Next
From: "Scott Marlowe"
Date:
Subject: Re: Large number of tables slow insert