| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Constantin Stefanov" <cstef(at)mail(dot)ru>, <pgadmin-support(at)postgresql(dot)org> |
| Cc: | "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> |
| Subject: | Re: Very slow viewing of large table. |
| Date: | 2003-10-23 08:18:15 |
| Message-ID: | 03AF4E498C591348A42FC93DEA9661B84C5C27@mail.vale-housing.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru]
> Sent: 23 October 2003 08:59
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Very slow viewing of large table.
>
> > SELECT relname, reltuples FROM pg_class;
> For my table there is
> ------------------------------
> accounting# SELECT relname, reltuples FROM pg_class where
> relname='ip_accounting';
> relname | reltuples
> ---------------+-------------
> ip_accounting | 7.71493e+07
> ------------------------------
> May be there is some overflow or incorrect result parsing?
Hmm, shouldn't be - the code appears to use longs everywhere. I can't
really spend time on this now though - Andreas, can you take a look
please?
Thanks, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-10-23 10:51:04 | Re: Very slow viewing of large table. |
| Previous Message | Constantin Stefanov | 2003-10-23 07:59:15 | Re: Very slow viewing of large table. |