On Thursday 06 December 2007 20:00, Tom Lane wrote:
> "Weber, Geoffrey M." <[EMAIL PROTECTED]> writes:
> > My problems really are with performance consistency. I have tweaked the
> > execution so that everything should run with sub-second execution times,
> > but even after everything is running w
"Weber, Geoffrey M." <[EMAIL PROTECTED]> writes:
> My problems really are with performance consistency. I have tweaked the
> execution so that everything should run with sub-second execution times, but
> even after everything is running well, I can get at most a week or two of
> steady running bef
2:43 PM
To: Weber, Geoffrey M.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Continual Postgres headaches...
On Dec 6, 2007 2:22 PM, Weber, Geoffrey M.
<[EMAIL PROTECTED]> wrote:
> In my efforts to correct these consistency in execution problems, I
have
> gone from vacuuming (
On Dec 6, 2007, at 2:22 PM, Weber, Geoffrey M. wrote:
I've been trying for quite a while to get Postgresql tuned for use
as an OLTP system. I have several PL/pgSQL functions that handle
inserts and updates to the main table and several near-real-time
daemons written that access the data a
On Dec 6, 2007, at 1:22 PM, Weber, Geoffrey M. wrote:
I've been trying for quite a while to get Postgresql tuned for use
as an OLTP system. I have several PL/pgSQL functions that handle
inserts and updates to the main table and several near-real-time
daemons written that access the data a
On Dec 6, 2007 2:22 PM, Weber, Geoffrey M. <[EMAIL PROTECTED]> wrote:
> In my efforts to correct these consistency in execution problems, I have
> gone from vacuuming (with analyze) twice a day to every 30 minutes (how long
> it takes a vacuum analyze to run - another seeming problem because it
> s
