Hello everyone,
A quick question:
- how long does it take you to perform that query :
"SELECT COUNT(*) FROM A_TABLE;"
There are like 56113000 rows in the table.
Thanks
Cedric
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wil
Cedric BUSCHINI wrote:
Hello everyone,
A quick question:
- how long does it take you to perform that query :
"SELECT COUNT(*) FROM A_TABLE;"
Not long :)
dev5=# SELECT COUNT(*) FROM A_TABLE;
ERROR: relation "a_table" does not exist
---(end of broadcast)-
Cedric BUSCHINI wrote:
> Hello everyone,
>
> A quick question:
> - how long does it take you to perform that query :
> "SELECT COUNT(*) FROM A_TABLE;"
Longer than I want to wait in any case. In most cases you can rewrite
that query to something else; what that something looks like, depends on
h
