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

[GENERAL] question about indexing.

2001-09-30 Thread Brian Hirt
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 value 1 23 have the value 2 6