On Mon, Feb 28, 2011 at 01:48:30PM -0600, Jason Long wrote:
> I stopped doing the nightly vacuum full and reindex. After 3 months
> some queries would not complete within 2 minutes. Normally these take
> less than 5 seconds. I tried vacuum without full and reindex, but the
> problem was still t
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote:
> On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote:
> > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
> >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
> >> > I currently have Postgres 9.0 install after an upgrade. My databa
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote:
> On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote:
> > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
> >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
> >> > I currently have Postgres 9.0 install after an upgrade. My databa
On Mon, Nov 8, 2010 at 2:06 PM, Jason Long
wrote:
> Every night when there is no activity I do a full vacuum, a reindex, and
> then dump a nightly backup.
>
> Is this optimal with regards to performance? autovacuum is set to the
> default.
In the general case this seems way overkill. Do you suf
On Mon, Nov 8, 2010 at 4:41 PM, Jason Long
wrote:
> On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote:
>> On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote:
>> > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
>> >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long
>> >> wrote:
>> >> > I
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote:
> On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote:
> > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
> >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
> >> > I currently have Postgres 9.0 install after an upgrade. My databa
On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote:
> On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
>> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
>> > I currently have Postgres 9.0 install after an upgrade. My database is
>> > relatively small, but complex. The dump is about 90M
On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote:
> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
> > I currently have Postgres 9.0 install after an upgrade. My database is
> > relatively small, but complex. The dump is about 90MB.
> >
> > Every night when there is no activity I do a
On Mon, 2010-11-08 at 13:28 -0800, John R Pierce wrote:
> On 11/08/10 10:50 AM, Jason Long wrote:
> > I currently have Postgres 9.0 install after an upgrade. My database is
> > relatively small, but complex. The dump is about 90MB.
> >
> > Every night when there is no activity I do a full vacuum,
On Mon, 2010-11-08 at 13:28 -0800, John R Pierce wrote:
> On 11/08/10 10:50 AM, Jason Long wrote:
> > I currently have Postgres 9.0 install after an upgrade. My database is
> > relatively small, but complex. The dump is about 90MB.
> >
> > Every night when there is no activity I do a full vacuum,
On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote:
> I currently have Postgres 9.0 install after an upgrade. My database is
> relatively small, but complex. The dump is about 90MB.
>
> Every night when there is no activity I do a full vacuum, a reindex,
One question, why?
> and then dump a nig
On 11/08/10 10:50 AM, Jason Long wrote:
I currently have Postgres 9.0 install after an upgrade. My database is
relatively small, but complex. The dump is about 90MB.
Every night when there is no activity I do a full vacuum, a reindex, and
then dump a nightly backup.
Is this optimal with regar
I currently have Postgres 9.0 install after an upgrade. My database is
relatively small, but complex. The dump is about 90MB.
Every night when there is no activity I do a full vacuum, a reindex, and
then dump a nightly backup.
Is this optimal with regards to performance? autovacuum is set to t
On Monday 8. November 2010 20.06.13 Jason Long wrote:
> I currently have Postgres 9.0 install after an upgrade. My database is
> relatively small, but complex. The dump is about 90MB.
>
> Every night when there is no activity I do a full vacuum, a reindex, and
> then dump a nightly backup.
>
>
I currently have Postgres 9.0 install after an upgrade. My database is
relatively small, but complex. The dump is about 90MB.
Every night when there is no activity I do a full vacuum, a reindex, and
then dump a nightly backup.
Is this optimal with regards to performance? autovacuum is set to t
15 matches
Mail list logo
