Jan Wieck <JanWieck@xxxxxxxxx> writes: > On 7/28/2005 2:03 PM, Tom Lane wrote: >> Well, there's the problem --- the stats subsystem is designed in a way >> that makes it rewrite its entire stats collection on every update. >> That's clearly not going to scale well to a large number of tables. >> Offhand I don't see an easy solution ... Jan, any ideas? > PostgreSQL itself doesn't work too well with tens of thousands of > tables. Really? AFAIK it should be pretty OK, assuming you are on a filesystem that doesn't choke with tens of thousands of entries in a directory. I think we should put down a TODO item to see if we can improve the stats subsystem's performance in such cases. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
