Re: [ADMIN] Performances

2006-12-28 Thread Alvaro Herrera
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

Re: [ADMIN] Performances

2006-12-28 Thread Bricklen Anderson
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)-

[ADMIN] Performances

2006-12-28 Thread Cedric BUSCHINI
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

Re: [ADMIN] Trigger trouble

2006-12-28 Thread Simon Riggs
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