Il giorno dom, 16/07/2006 alle 11.08 -0700, Joe Conway ha scritto:
Gabriele Turchi wrote:
Il giorno sab, 15/07/2006 alle 13.04 -0700, Joe Conway ha scritto:
Why not just periodically (once an hour?) run ANALYZE registrazioni;
during the day. This will only update the statistics, and should
Just turn on autovacuuming on your 8.1 database. You can tune the vacuum and autovacuum parameters to minimize the impact to your system. This is the optimal route to take since PG will maintain the tables for you as needed.
HTH,ChrisOn 7/15/06, Gabriele Turchi [EMAIL PROTECTED] wrote:
Il giorno
Gabriele Turchi wrote:
Il giorno sab, 15/07/2006 alle 13.04 -0700, Joe Conway ha scritto:
Why not just periodically (once an hour?) run ANALYZE registrazioni;
during the day. This will only update the statistics, and should be very
low impact.
This is my solution too... but: is enough? Or
Hi all. I have a strange (and serious) problem with an application
ported from postgres 8.0 to 8.1.
The old installation is postgresql-8.0.4-2.FC4.1 running on a Fedora 4,
the new one is postgresql-8.1.4-1.FC5.1 running on a fedora 5.
Some query is now _very_ slow. I've found some deep
On Sat, Jul 15, 2006 at 04:14:11PM +0200, Gabriele Turchi wrote:
Hi all. I have a strange (and serious) problem with an application
ported from postgres 8.0 to 8.1.
The old installation is postgresql-8.0.4-2.FC4.1 running on a Fedora 4,
the new one is postgresql-8.1.4-1.FC5.1 running on a
Il giorno sab, 15/07/2006 alle 13.02 -0600, Michael Fuhr ha scritto:
On Sat, Jul 15, 2006 at 04:14:11PM +0200, Gabriele Turchi wrote:
Hi all. I have a strange (and serious) problem with an application
ported from postgres 8.0 to 8.1.
The old installation is postgresql-8.0.4-2.FC4.1
Gabriele Turchi wrote:
Running an ANALYZE really change the plan, now it is fast as before
(8.0).
On the production system a VACUUM FULL ANALYZE is run every morning
after a clean-up, when the registrazioni table is empty. During the
day this table fills up (about 500 record any day), and
Il giorno sab, 15/07/2006 alle 13.04 -0700, Joe Conway ha scritto:
Gabriele Turchi wrote:
Running an ANALYZE really change the plan, now it is fast as before
(8.0).
On the production system a VACUUM FULL ANALYZE is run every morning
after a clean-up, when the registrazioni table is