Postgres Pro
Downloads
Home   >   mailing lists

Re: Query plan changes after pg_dump / pg_restore - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Query plan changes after pg_dump / pg_restore
Date
Msg-id 42A7FD12.2080608@familyhealth.com.au
Whole thread Raw
In response to Re: Query plan changes after pg_dump / pg_restore  (Jona <jonanews@oismail.com>)
Responses Re: Query plan changes after pg_dump / pg_restore
List pgsql-performance
Tree view 
>   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

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Recommendations for configuring a 200 GB database
Next
From: Jona
Date:
Subject: Re: Query plan changes after pg_dump / pg_restore