Re: [PERFORM] EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT

On 7.3.2015 03:26, Jeff Janes wrote: > On Fri, Mar 6, 2015 at 5:38 PM, Tom Lane > wrote: > > But the actual query is using a seq scan, and so it would hint the > table in efficient sequential order, rather than hinting the table > haphazardly in index order like probing

Re: [PERFORM] CREATE INDEX uses INDEX ?

Le 7 mars 2015 11:32, "Nicolas Paris" a écrit : > > Hello, > > I wonder if the process of index creation can benefit from other indexes. > It cannot. > EG: Creating a partial index with predicat based on a boolean column, will use an hypothetic index on that boolean column or always use a seq sc

[PERFORM] CREATE INDEX uses INDEX ?

Hello, I wonder if the process of index creation can benefit from other indexes. EG: Creating a partial index with predicat based on a boolean column, will use an hypothetic index on that boolean column or always use a seq scan on all rows ? Goal is to create partial indexes faster. Explain com