Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
postgresql select where is null takes too long
Found the solution, i had to many nulls 90%, you may delete the post sry...- sergiui
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
postgresql select where is null takes too long
Hi, I have a TABLE with many rows (about 1000 000) I want to get all the fields that have the value on colum A null. Field A is integere and is indexed with a default btree. My query is: "SELECT * FROM table WHERE A is null" this takes forever and eventualy returns nothing even if i do a...- sergiui
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
