Skip site navigation (1) Skip section navigation (2)

Re: slow query

From: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
To: Clarence Gardner <clarence(at)silcom(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow query
Date: 2003-02-24 17:44:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
What about REINDEXing and other DB tricks?
Do you use any of these regularly?


-----Original Message-----
From: Clarence Gardner [mailto:clarence(at)silcom(dot)com] 
Sent: Monday, February 24, 2003 10:28 AM
To: Robert Treat
Cc: Oleg Lebedev; Josh Berkus; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] slow query

On 24 Feb 2003, Robert Treat wrote:

> If your seeing wildly dramatic improvments from vacuum full, you might

> want to look into running regular vacuums more often (especially for 
> high turnover tables), increase your max_fsm_relations to 1000, and 
> increasing your max_fsm_pages.

I don't know about the settings you mention, but a frequent vacuum does
not at all obviate a vacuum full. My database is vacuumed every night,
but a while ago I found that a vacuum full changed a simple single-table
query from well over 30 seconds to one or two. We now do a vacuum full
every night.


This email may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.  
Any review, copying, printing, disclosure or other use is prohibited.
We reserve the right to monitor email sent through our network.


pgsql-performance by date

Next:From: scott.marloweDate: 2003-02-24 18:11:33
Subject: Re: partitioning os swap data log tempdb
Previous:From: Clarence GardnerDate: 2003-02-24 17:27:56
Subject: Re: slow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group