Re: [BUGS] Bug #681: creating indices after data insertion

2002-05-29 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> 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 ---(end of broadcast)-

Re: [BUGS] Bug #681: creating indices after data insertion

2002-05-29 Thread Dmitry Tkach
Did you vacuum it? I hope, it helps... Dima [EMAIL PROTECTED] wrote: >Markus Grill ([EMAIL PROTECTED]) reports a bug with a severity of 2 >The lower the number the more severe it is. > >Short Description >creating indices after data insertion > >Long Description >Hello, > >in my opinion there i

[BUGS] Bug #681: creating indices after data insertion

2002-05-29 Thread pgsql-bugs
Markus Grill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description creating indices after data insertion Long Description Hello, in my opinion there is a big bug with indexes. I used Postgresql 7.1.3 and 7.2.1 First I create two ta