| From: | Yaroslav Dmitriev <yar(at)warlock(dot)ru> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: []performance issues |
| Date: | 2002-08-02 11:48:39 |
| Message-ID: | 3D4A7197.8010603@warlock.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Christopher Kings-Lynne wrote:
>Doing a row count requires a sequential scan in Postgres.
>
>Try creating another summary table that just has one row and one column and
>is an integer.
>
>
I have THREE summary tables derived from "stats" with different levels
of aggregation. They work quite fast, But:
1) Summary tables grow too
2) There are requests which cannot be predicted, so they involve the
"stats" table itself.
So I am still interested in PostgreSQL's ability to deal with
multimillon records tables.
Best regards,
Yar.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2002-08-02 11:55:02 | Re: Questions regarding contrib/tsearch |
| Previous Message | Xavier Bugaud | 2002-08-02 11:24:46 | Re: very slow updates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-08-02 11:59:20 | Build errors with current CVS |
| Previous Message | Hannu Krosing | 2002-08-02 11:34:21 | Re: Why is MySQL more chosen over PostgreSQL? |