On Mar 14, 2006, at 4:19 PM, mcelroy, tim wrote:
Humm, well I am running 8.0.1 and use that option and see the
following in
my vacuum output log:
vacuumdb: vacuuming database "template1"
it has done so since at least 7.4, probably 7.3. the "-a" flag
really does what is says.
---
On Tue, Mar 14, 2006 at 09:37:33PM +, Richard Huxton wrote:
> >But shouldn't it be possible to batch up WAL writes and syncs? In other
> >words, if you have 5 transactions that all COMMIT at exactly the same
> >time, it should be possible to get all 5 WAL pages (I'll assume each
> >one generate
Jim C. Nasby wrote:
On Fri, Mar 10, 2006 at 11:57:16PM -0800, David Lang wrote:
On Sat, 11 Mar 2006, Joost Kraaijeveld wrote:
On Fri, 2006-03-10 at 13:40 +, Richard Huxton wrote:
Your ATA disk is lying about disk caching being turned off. Assuming
each insert is in a separate transaction,
On Tue, Mar 14, 2006 at 04:19:37PM -0500, mcelroy, tim wrote:
> Humm, well I am running 8.0.1 and use that option and see the following in
> my vacuum output log:
>
> vacuumdb: vacuuming database "template1"
>
> So I would assume that it is being vacuumed? Maybe I'm wrong. If so, we
> should be
Title: RE: [PERFORM] Vacuum template databases, Urgent: Production probl
Humm, well I am running 8.0.1 and use that option and see the following in my vacuum output log:
vacuumdb: vacuuming database "template1"
So I would assume that it is being vacuumed? Maybe I'm wrong. If so, we shoul
On Tue, Mar 14, 2006 at 12:28:17PM -0500, mcelroy, tim wrote:
> If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases
> including template1?
It does on 8.1...
[EMAIL PROTECTED]:15]~:18%vacuumdb -va | & grep template1
vacuumdb: vacuuming database "template1"
[EMAIL PROTECTED]:16
On Tue, Mar 14, 2006 at 11:44:12AM -0500, Pallav Kalva wrote:
> Hi,
>
> Do we have to vacuum template0 database regularly ? We got this warning
> this morning while vacuuming databases. As a part of my daily vacuum job
> I do vacuum of quartz, helix_fdc and affiliate databases which are t
On Tue, Mar 14, 2006 at 09:02:49AM -0300, andremachado wrote:
> Hello,
> Attached is a file containing the problematic queries cited yesterday, with
> "explain", "\di" and "show all" outputs.
> The first one finished in almost 4 hours. Firebird for windows finished in
> 1m30s.
> The second one CRA
On Fri, Mar 10, 2006 at 11:57:16PM -0800, David Lang wrote:
> On Sat, 11 Mar 2006, Joost Kraaijeveld wrote:
>
> >On Fri, 2006-03-10 at 13:40 +, Richard Huxton wrote:
> >>Your ATA disk is lying about disk caching being turned off. Assuming
> >>each insert is in a separate transaction, then it's
On Fri, Mar 10, 2006 at 10:39:57PM -0300, Andre Felipe Machado wrote:
> It seems that effective_cache_size does not tell postgresql to actually
> use windows disk cache.
No, it just tells PostgreSQL how much cache memory it should expect to
have.
> What parameter must be configured?
> Do you have
On Fri, Mar 10, 2006 at 10:46:56AM -0600, Scott Marlowe wrote:
> I think it's time to get a new hosting provider.
>
> If they're still running PostgreSQL 7.3.9 (the latest 7.3 is 7.3.14, and
> 8.1.3 is amazingly faster than 7.3.anything...) then they're likely not
> updating other vital components
On 3/14/06, andremachado <[EMAIL PROTECTED]> wrote:
> Unfortunately, the first query simply returned the same estimated costs by the
> planner.
Can you try making a big increase to work_mem .conf parameter (as much
as is reasonalbe) and see if that helps either query?
ok, thats understandable. yo
Hello,
Many thanks for your suggestions.
I am trying to optimize server configs, as (presumed) my friend already
optimized his queries and firebird windows is executing them fast.
You could see at the new attached file the results of the queries rewrite.
Unfortunately, the first query simply return
Title: RE: [PERFORM] Vacuum template databases, Urgent: Production problem
If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases including template1?
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: Tues
Pallav Kalva <[EMAIL PROTECTED]> writes:
>Do we have to vacuum template0 database regularly ?
No, and in fact you can't because it's marked not datallowconn.
But you do need to vacuum template1 and usps every now and then.
regards, tom lane
---
Hi,
Do we have to vacuum template0 database regularly ? We got this warning this morning while vacuuming databases. As a part of my daily vacuum job I do vacuum of quartz, helix_fdc and affiliate databases which are the
one's which are heavily updated and used. But today I realized that usps,
On 3/14/06, andremachado <[EMAIL PROTECTED]> wrote:
> Hello,
> Attached is a file containing the problematic queries cited yesterday, with
> "explain", "\di" and "show all" outputs.
> The first one finished in almost 4 hours. Firebird for windows finished in
> 1m30s.
> The second one CRASHED after
Title: RE: [PERFORM] PG Statistics
Thanks you Steve. As mentioned in my other reply to Michael Fuhr I'll post the results from tests to be performed this week.
Tim
-Original Message-
From: Steve Poe [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2006 7:38 PM
To: mcelr
Title: RE: [PERFORM] PG Statistics
Thank you for the insight Michael. I'll be performing some tests with the various setting on/off this week and will post the results.
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2006 7:19 PM
T
Hello,
Attached is a file containing the problematic queries cited yesterday, with
"explain", "\di" and "show all" outputs.
The first one finished in almost 4 hours. Firebird for windows finished in
1m30s.
The second one CRASHED after some hours, without finishing. The error message
is at the file
20 matches
Mail list logo
