"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.
>
>
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,
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
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