Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #681: creating indices after data insertion - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #681: creating indices after data insertion
Date
Msg-id 24278.1022691438@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug #681: creating indices after data insertion  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-bugs
Tree view 
Dmitry Tkach <dmitry@openratings.com> writes:
> Did you vacuum it?

Even more to the point: vacuum analyze.

The described behavior sounds like the default assumptions in the
absence of any ANALYZE statistics ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Bug #681: creating indices after data insertion
Next
From: Andrew McMillan
Date:
Subject: Re: Documentation regarding %ROWTYPE in PL/PgSQL