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
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)-
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
On Thu, 2006-12-21 at 10:26 +, Sandy Spence wrote:
> I get the following error when performing a pg_dump
>
> dumping database "ltt"...
> pg_dump: WARNING: owner of data type trigger appears to be invalid
>
> the owner and database exists, I have run the following select statement,
>
> selec