Thank you for your mailing service
But I do not want your mailing service
Please don't send mail.
Have a nice day.. :)
_
¼±¹°, ÀüÅë³îÀÌ, Ãß¼®À½½Ä, ±³ÅëÁ¤º¸, °¡Á·¿©Çà- ¾ßÈÄ! ÇÑ°¡À§ Å׸¶°¡À̵å
http
"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.
>
>
That's the answer! Thanks Doug.
basement=# explain select * from game_developer where approved = 2;
Seq Scan on game_developer (cost=0.00..1920.17 rows=48 width=46)
basement=# explain select * from game_developer where approved = int2(2);
Index Scan using game_developer_approved on game_develo
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
--- Begin Message ---
The lib dir holds files to help us interface languages..
Some of the names seem obvious to me but are
the following for Perl
libpg.solipg.a libpg.so.2
And if not what are Perl files?
Lastly if the make did not install the files
as I got one message during make
