Re: [GENERAL] question about indexing.

2001-09-30 Thread Doug McNaught
"Brian Hirt" <[EMAIL PROTECTED]> writes: > I have a table with about 1 million rows in it. One of the columns in this > table is some sort of status (it's an int2). Out of the million rows, only > about 100 of the rows have a status that is not like the rest. > Yes, i do vacuum the table. > >

Re: [GENERAL] question about indexing.

2001-09-30 Thread Brian Hirt
ed on game_developer (cost=0.00..80.87 rows=48 width=46) - Original Message - From: "Doug McNaught" <[EMAIL PROTECTED]> To: "Brian Hirt" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Brian A Hirt" <[EMAIL PROTECTED]> Sent: Sunday, September 30,

Re: [GENERAL] question about indexing.

2001-09-30 Thread Stephan Szabo
On Sun, 30 Sep 2001, Brian Hirt wrote: > I have a table with about 1 million rows in it. One of the columns in this > table is some sort of status (it's an int2). Out of the million rows, only > about 100 of the rows have a status that is not like the rest. > > for example: > 999,900 have the