Hi
I have trouble executing count(*)
statement.
On a large dataset it takes quite a while to return
result.
Is there any other way to get number of tupples in
relation
or is the only way tooptimize count()
function to indexit?
thanks
Nikola
The problem is in other software I use,
witch uses count(*) function to display relation properties
pgAdmin II
phpPgAdmin
Nikola
- Original Message -
From: Bruno Wolff III [EMAIL PROTECTED]
To: Nikola Ivacic [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 5:22
Programmer/Analyst II
Tacoma-Pierce County Health Department
[EMAIL PROTECTED]
(253) 798-3549
Nikola Ivacic [EMAIL PROTECTED] 01/08/03 08:15AM
The problem is in other software I use,
witch uses count(*) function to display relation properties
pgAdmin II
phpPgAdmin
Nikola
- Original Message
I need help
Has somebody experienced difficulties using COPY
command on large files.
I have a large (250MB) file and each time I insert
records I've gotone or more ( 30 of cca 1079000)
corrupted
records. The number of corrupted records is not
constant (i.e. 1, 30, 7, 23 etc..)
p.s. the
some tools for FreeBSD
to test RAM, because I think the hard disk is ok.
p.s. right now I am testing it with splited file
thanks
Nikola
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Nikola Ivacic [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 4:24 PM