Re: [PERFORM] postgres files in use not staying in linux file cache

2014-06-10 Thread Shaun Thomas
On 06/05/2014 04:32 PM, Brio wrote: So here's where I'm stuck. How can reading a file not leave it in the Linux cache? I'd expect it to enter the inactive list (which is about 80GB), so I'd expect another 80GB would need to be read before it would be its turn to be evicted which should take

[PERFORM] Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

2014-06-10 Thread tim_wilson
Was my example not able to be repeated or do I need to give you a better example of the problem, or is there just a lot of stuff happening? Happy to do more work on example sql for the problem if it needs it, just need some feed back on how whether this problem is going to be looked at or not.

Re: [PERFORM] Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

2014-06-10 Thread Tom Lane
tim_wilson tim.wil...@telogis.com writes: Was my example not able to be repeated or do I need to give you a better example of the problem, or is there just a lot of stuff happening? The latter ... http://www.postgresql.org/message-id/flat/10787.1402083...@sss.pgh.pa.us

[PERFORM] Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

2014-06-10 Thread tim_wilson
Great thanks a lot. We will be ready to build and test a patch or 9.4 version as soon as you have a test patch you want to try. regards Tim -- View this message in context: