From: | "Erwan DUROSELLE" <EDuroselle(at)seafrance(dot)fr> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <csegyud(at)vnet(dot)hu> |
Subject: | Rép. : What does count(*) count? |
Date: | 2003-12-31 10:53:36 |
Message-ID: | 7fddccc22d7f90ed628e61d91373f8fb3ff2aa6e@ |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
4908*2=9816
2 inserts on the same line in the dmp file?
Erwan
>>> Együd Csaba <csegyud(at)vnet(dot)hu> 31/12/2003 09:58:25 >>>
Hi all,
I tried to dump out a single table and just for a verification I counted the
number of 'INERT INTO' rows.
I found that count(*) results less rows than grep.
*******************
Csaba(at)compaq ~
$ pg_dump -d -t t_stockchanges alumil6 > sc.dump
*******************
alumil6=# select count(*) from t_stockchanges ;
count
-------
9816
(1 row)
*******************
Csaba(at)compaq ~
$ cat sc.dump | grep 'INSERT INTO' | wc -l
4908
*******************
What can be the reason of it?
Thx,
-- Csaba
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2003-12-31 11:06:23 | Replication ? |
Previous Message | Arjen van der Meijden | 2003-12-31 10:40:20 | Re: website doc search is extremely SLOW |