Re: [PERFORM] Searching GIN-index (FTS) and sort by timestamp-column

2016-03-22 Thread Oleg Bartunov
On Sat, Mar 19, 2016 at 5:44 AM, Jeff Janes wrote: > On Wed, Mar 16, 2016 at 6:53 AM, Andreas Joseph Krogh > wrote: > >> På onsdag 16. mars 2016 kl. 14:37:27, skrev Tom Lane : >> >> Andreas Joseph Krogh writes: >> > 1. Why isnt' folder_id part of the index-cond? >> >> Because a GIN index is use

Re: [PERFORM] Disk Benchmarking Question

2016-03-22 Thread Dave Stibrany
Thanks for the feedback guys. I'm looking forward to the day when we upgrade to SSDs. For future reference, the bonnie++ numbers I was referring to are: Size: 63G Sequential Output: 396505 K/sec % CPU 21 Sequential Input: 401117 K/sec % CPU 21