New version of patch. There are some bugfixes, minor refactoring, comments (unfortunatelly, not all the code is covered by comments yet). Also "fastbuild" parameter was added to the GiST index. It allows to test index building with and without fast build without postgres recompile.
------ With best regards, Alexander Korotkov. On Thu, Jun 16, 2011 at 10:35 PM, Alexander Korotkov <aekorot...@gmail.com>wrote: > Oh, actually it's so easy. Thanks. > > ------ > With best regards, > Alexander Korotkov. > > On Thu, Jun 16, 2011 at 10:26 PM, Heikki Linnakangas < > heikki.linnakan...@enterprisedb.com> wrote: > >> On 16.06.2011 21:13, Alexander Korotkov wrote: >> >>> My current idea is to measure number of IO accesses by pg_stat_statements >>> and measure CPU usage by /proc/PID/stat. Any thoughts? >>> >> >> Actually, you get both of those very easily with: >> >> set log_statement_stats=on >> >> LOG: QUERY STATISTICS >> DETAIL: ! system usage stats: >> ! 0.000990 elapsed 0.000000 user 0.000000 system sec >> ! [0.000000 user 0.008000 sys total] >> ! 0/0 [32/0] filesystem blocks in/out >> ! 0/0 [0/959] page faults/reclaims, 0 [0] swaps >> ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent >> ! 0/0 [10/1] voluntary/involuntary context switches >> STATEMENT: SELECT generate_series(1,100); >> >> >> >> -- >> Heikki Linnakangas >> EnterpriseDB http://www.enterprisedb.com >> > >
gist_fast_build-0.2.0.patch.gz
Description: GNU Zip compressed data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
