Horton

Re: Why we don't want hints Was: Slow count(*) again...

Andrea Suisani <sickpig@opinioni.net>

View thread
From: Andrea Suisani <sickpig@opinioni.net>
To: Tobias Brox <tobixen@gmail.com>
Cc: Vitalii Tymchyshyn <tivv00@gmail.com>, Josh Berkus <josh@agliodbs.com>, pgsql-performance@postgresql.org, Mladen Gogala <mladen.gogala@vmsinfo.com>
Date: 2011-02-11T11:33:22Z
Lists: pgsql-hackers, pgsql-performance 
On 02/11/2011 12:26 PM, Tobias Brox wrote:
> 2011/2/11 Vitalii Tymchyshyn<tivv00@gmail.com>:
>>> My idea as well, though it looks ugly and it would be a maintenance
>>> head-ache (upgrading the index as new transaction types are added
>>> would mean "costly" write locks on the table,
>>
>> Create new one concurrently.
>
> Concurrently?  Are there any ways to add large indexes without
> blocking inserts to the table for the time it takes to create the
> index?

yep, AFAIR since 8.2
see: http://www.postgresql.org/docs/8.2/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY

[cut]

Andrea