Hi
At 2013/2/8 I wrote:
> I have problems with the performance of FTS in a query like this:
>
> SELECT * FROM FullTextSearch WHERE content_tsv_gin @@
> plainto_tsquery('english', 'good');
>
> It's slow (> 30 sec.) for some GB (27886 html files, originally 73 MB zipped).
> The planner obviously alw
On 07/17/2013 09:04 PM, Greg Smith wrote:
I'm working on a completely replacement of that guide, one that actually
gives out a full set of advice. Right now I'm between their product
cycles, I'm expecting new hardware again here soon.
Me too. It's interesting that they seem to be focusing mor
On Thu, Jul 18, 2013 at 10:40 AM, Josh Berkus wrote:
>
> Right, that's what I just tested. The results are interesting. I
> changed the defaults as follows:
>
> bgwriter_delay = 100ms
> bgwriter_lru_maxpages = 512
> bgwriter_lru_multiplier = 3.0
>
> ... and the number of buffers being written by
Greg,
> There look to be a good number of buffers on this server that are only
> being written at checkpoint time. The background writer will only deal
> with buffers when their usage count is low. Fast servers can cycle over
> shared_buffers such that as soon as their usage counts get low, they
