| From: | Benjamin Arai <benjamin(at)araisoft(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Problem with large table not using indexes (I think) |
| Date: | 2006-12-23 19:26:08 |
| Message-ID: | 458D82D0.5050903@araisoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hi,
The largest table in my database (30GB) has mysteriously went from
taking milli-seconds to perform a query to minutes. This disks are fine
and I have a 4GB shared_memory. Could this slow down have to do with
the fsm_max_pages or something else like that? I made it larger but the
queries still taking a long time. I do daily vacuum's but I don't run
it with -z or --full. I would like to avoid doing a --full if possible
because it would literally take over a week to complete. Any help would
be greatly appreciated.
Benjamin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-12-23 19:33:39 | Re: Problem with large table not using indexes (I think) |
| Previous Message | Fabricio Peñuelas | 2006-12-23 06:00:53 | Configuracion de postgresql Sobre cargado |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-12-23 19:33:39 | Re: Problem with large table not using indexes (I think) |
| Previous Message | org | 2006-12-23 18:28:35 | Re: Clustering & Load Balancing & Replication |