Re: Query plan changes after pg_dump / pg_restore

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Jona <jonanews(at)oismail(dot)com>
Cc: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Query plan changes after pg_dump / pg_restore
Date: 2005-06-09 08:25:54
Message-ID: 42A7FD12.2080608@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Thank you for the swift reply, the following is the output of the SHOW
> ALL for shared_buffers and effective_cache_size.
> shared_buffers: 13384
> effective_cache_size: 4000
> server memory: 2GB

effective_cache_size should be 10-100x larger perhaps...

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jona 2005-06-09 08:54:32 Re: Query plan changes after pg_dump / pg_restore
Previous Message Jona 2005-06-09 08:12:09 Re: Query plan changes after pg_dump / pg_restore