On Sat, Aug 23, 2008 at 6:47 PM, Loic Petit <[EMAIL PROTECTED]> wrote: > 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
It could be that the tables or indexes are heavily bloated. What's the churn rate on these tables / indexes? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
