Thread: WARNING: concurrent insert in progress within table "resource"
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. postgres=# select version(); version ──────────────────────────────────────────────────────────────────────────────────────────────────────────PostgreSQL 9.2develon i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.1 20100924 (Red Hat 4.5.1-4), 32-bit (1 row) Regards Pavel
On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel.stehule@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. > > > postgres=# select version(); > version > ────────────────────────────────────────────────────────────────────────────────────────────────────────── > PostgreSQL 9.2devel on i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.1 > 20100924 (Red Hat 4.5.1-4), 32-bit > (1 row) > > Regards > > Pavel That seems bad. But can you provide any more details about how to reproduce it? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
yes 2012/2/27 Robert Haas <robertmhaas@gmail.com>: > On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel.stehule@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 >> >> postgres=# select version(); >> version >> ────────────────────────────────────────────────────────────────────────────────────────────────────────── >> PostgreSQL 9.2devel on i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.1 >> 20100924 (Red Hat 4.5.1-4), 32-bit >> (1 row) >> >> Regards >> >> Pavel > > That seems bad. But can you provide any more details about how to reproduce it? > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
On Mon, Feb 27, 2012 at 10:54 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > yes > > 2012/2/27 Robert Haas <robertmhaas@gmail.com>: >> On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel.stehule@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? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
2012/3/7 Robert Haas <robertmhaas@gmail.com>: > On Mon, Feb 27, 2012 at 10:54 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: >> yes >> >> 2012/2/27 Robert Haas <robertmhaas@gmail.com>: >>> On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel.stehule@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