Re: [SQL] count(*) optimization

2003-01-08 Thread Nikola Ivacic
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(

Re: [SQL] count(*) optimization

2003-01-08 Thread Nikola Ivacic
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

[SQL] count(*) optimization

2003-01-08 Thread Nikola Ivacic
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

Re: [SQL] COPY command problems

2002-12-24 Thread Nikola Ivacic
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

[SQL] COPY command problems

2002-12-24 Thread Nikola Ivacic
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