gin creation and previous history of server

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: gin creation and previous history of server
Date: 2008-11-04 14:55:07
Message-ID: 20081104155507.204f7118@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems that gin creation is triggering something nasty in the
server that depends on previous history of the server.

If I vacuum full than drop the index and recreate it even with
maintenance_work_mem='200MB' index creation may take forever.
Stopping the execution may make vacuuming very slow or stopping the
server very slow etc...

I know that the server may be cleaning the new partially created
index etc... but gin creation even with 200MB of
maintenance_work_mem is having a too strange and to big hit on the
server.

I can *occasionally* succede to create a gin index in reasonable
time if I shut down the server, vacuum full and drop and recreate
the index separately from the transaction that load the data.

gist creation is *predictably* much faster even inside the
transaction that load the data and doesn't have side effect outside
index creation.
Even when gin creation succede it is definitively slower than 3x

gist/gin index creation looks more cpu bounded than memory bounded.
I'm checking if I made some mistake in other cfg parameters that may
have some impact on index creation...

Any further clue?

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-04 15:33:26 Re: gin creation and previous history of server
Previous Message Diego Schulz 2008-11-04 14:53:41 Re: INSERT with RETURNING clause inside SQL function