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

2016-03-18 Thread Andreas Joseph Krogh
På onsdag 16. mars 2016 kl. 16:07:56, skrev Evgeniy Shishkin < itparan...@gmail.com >: > On 16 Mar 2016, at 18:04, Evgeniy Shishkin wrote: > >> >> On 16 Mar 2016, at 17:52, Evgeniy Shishkin wrote: >> >> >>> On 16 Mar 2016, at 16:37, Tom Lane wrote: >>> >>>

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

2016-03-18 Thread Andreas Joseph Krogh
På onsdag 16. mars 2016 kl. 14:53:04, skrev Andreas Joseph Krogh < andr...@visena.com >: På onsdag 16. mars 2016 kl. 14:37:27, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > 1. Why isnt' folder_id part of the index-cond? Because a GIN index

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

2016-03-18 Thread Evgeniy Shishkin
> On 16 Mar 2016, at 18:04, Evgeniy Shishkin wrote: > >> >> On 16 Mar 2016, at 17:52, Evgeniy Shishkin wrote: >> >> >>> On 16 Mar 2016, at 16:37, Tom Lane wrote: >>> >>> Andreas Joseph Krogh writes: 1. Why isnt' folder_id part of the index-cond? >>> >>> Because a GIN index is useles

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

2016-03-18 Thread Andreas Joseph Krogh
På torsdag 17. mars 2016 kl. 18:20:23, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Evgeniy Shishkin writes: > Uh, it works if i cast to bigint explicitly FWIW, the reason for that is that the int8_ops operator class that btree_gin creates doesn't contain any cross-type operators.  Probably wo

Re: [PERFORM] Disk Benchmarking Question

2016-03-18 Thread Mike Sofen
Sorry for the delay, long work day! Ok, I THINK I understand where you’re going. Do it this way: 4 drives in Raid10 = 2 pairs of mirrored drives, aka still 2 active drives (2 are failover). They are sharing the 12gbps SAS interface, but that speed is quite irrelevant…it’s just a giant pipe

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

2016-03-18 Thread Jeff Janes
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 useless for sorting. > > > 2. Is there a way to make it use the (sa