Pavel Stehule <pavel.steh...@gmail.com> writes: >> Nice. Another interesting numbers would be device utilization, average >> I/O speed and required space (which should be ~2x the pgstat.stat size >> without the patch).
> this point is important - with large warehouse with lot of databases > and tables you have move stat file to some ramdisc - without it you > lost lot of IO capacity - and it is very important if you need only > half sized ramdisc [ blink... ] I confess I'd not been paying close attention to this thread, but if that's true I'd say the patch is DOA. Why should we accept 2x bloat in the already-far-too-large stats file? I thought the idea was just to split up the existing data into multiple files. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers