Re: many sessions waiting DataFileRead and extend

#x27;d try to capture a snapshot of what queries were running at the moment the problem happens. If, for example, all the sessions suddenly decide to insert into the same table at the same time, it might be good to think about whether there's a way to avoid that. -- Robert Haas EDB: http://www.enterprisedb.com

Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)

, BSD? > > I'd be *VERY* surprised if any would be faster. It's not easy to write a > faster implmentation, than what I've proposed, and especially not so if > you use strtol() as the API (variable bases, a bit of locale support). OK. Nothing else from me... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)

work out the other way on, say, BSD? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

27;s "sample" is pretty easy to use and produces text format output that is easy to email. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company