Re: [PERFORM] Use of sequence rather than index scan for one text column on one instance of a database

2009-10-03 Thread Bill Kirtley
s quiescent at the time? Regards, -Bill Kirtley On Sep 24, 2009, at 12:26 PM, Tom Lane wrote: Bill Kirtley writes: select xmin,* from pg_index where indexrelid = 'index_users_on_email'::regclass; xmin | indexrelid | indrelid | indnatts | indisunique | indisprimary

[PERFORM] Use of sequence rather than index scan for one text column on one instance of a database

2009-09-23 Thread Bill Kirtley
(cleverly named email2) and copying the data (update users set email2=email) and adding the appropriate index and the query performed quickly. So we can fix the immediate problem, but I'd feel more comfortable understanding it. Do folks on this list have suggestions for how t