accuracy over speed in this case.
Ian Harding
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(
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 PROT
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 to optimize count()
function to index it?
thanks
Nikola
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 PRO
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 got one 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