2012/3/7 Robert Haas <robertmh...@gmail.com>: > On Mon, Feb 27, 2012 at 10:54 AM, Pavel Stehule <pavel.steh...@gmail.com> > wrote: >> yes >> >> 2012/2/27 Robert Haas <robertmh...@gmail.com>: >>> On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel.steh...@gmail.com> >>> wrote: >>>> Hello >>>> >>>> I tested creating some larger indexes >>>> >>>> There was a warning: >>>> >>>> postgres=# CREATE INDEX idx_resource_name ON resource (name, tid); >>>> WARNING: concurrent insert in progress within table "resource" >>>> >>>> I am sure so there was only one active session - so this warning is >>>> strange. >>>> >> >> sure >> >> I tried generate data from >> http://archives.postgresql.org/pgsql-performance/2012-02/msg00210.php >> example >> >> I used pg from yesterday GIT repository >> >> and my configuration was >> >> shared buffers 500MB >> maintenance_work_mem 200MB >> wal_buffers 64MB >> checkpoint_segments 32 > > Is this repeatable? >
I didn't repeated this test, but I'll check it tomorrow. Pavel > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
