Nikola,
> I am not sure pgAdmin uses count(*) and I didn't have time to check
> phpPgAdmin also, I presumed it from similarly slow response I get in
> psql
Well, pgAdmin and phpPgAdmin have their own mailing lists. I'd suggest
posting there. Ideally, these programs should have an option that
l
>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 5:20 PM
Subject: Re: [SQL] count(*) optimization
Bummer. I seem to remember PGAccess using the numbers generated by ANALYZE
to show the number of records. I noticed it was inaccurate until you ran a
vaccum. I guess pgAdmin chose
ECTED]>
Sent: Wednesday, January 08, 2003 5:22 PM
Subject: Re: [SQL] count(*) optimization
> On Wed, Jan 08, 2003 at 17:04:40 +0100,
> Nikola Ivacic <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > I have trouble executing count(*) statement.
> > On a large data
On Wed, Jan 08, 2003 at 17:04:40 +0100,
Nikola Ivacic <[EMAIL PROTECTED]> wrote:
> 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 cou
