Folks,
I just noticed that if I use a tstzrange for convenience, a standard
btree index on a timestamp won't get used for it. Example:
table a (
id int,
val text,
ts timestamptz
);
index a_ts on a(ts);
SELECT * FROM a WHERE ts @ tstzrange('2013-01-01','2013-01-01
On 3/20/2013 6:44 PM, David Rees wrote:
On Thu, Mar 14, 2013 at 4:37 PM, David Boreham david_l...@boreham.org wrote:
You might want to evaluate the performance you can achieve with a single-SSD
(use several for capacity by all means) before considering a RAID card + SSD
solution.
Again I bet it
On 3/20/2013 7:44 PM, David Rees wrote:
On Thu, Mar 14, 2013 at 4:37 PM, David Boreham david_l...@boreham.org wrote:
You might want to evaluate the performance you can achieve with a single-SSD
(use several for capacity by all means) before considering a RAID card + SSD
solution.
Again I bet
On Wed, Mar 20, 2013 at 6:44 PM, David Rees dree...@gmail.com wrote:
On Thu, Mar 14, 2013 at 4:37 PM, David Boreham david_l...@boreham.org wrote:
You might want to evaluate the performance you can achieve with a single-SSD
(use several for capacity by all means) before considering a RAID card +
On 21/03/13 13:44, David Rees wrote:
On Thu, Mar 14, 2013 at 4:37 PM, David Boreham david_l...@boreham.org wrote:
You might want to evaluate the performance you can achieve with a single-SSD
(use several for capacity by all means) before considering a RAID card + SSD
solution.
Again I bet it
Josh Berkus j...@agliodbs.com writes:
I just noticed that if I use a tstzrange for convenience, a standard
btree index on a timestamp won't get used for it. Example:
table a (
id int,
val text,
ts timestamptz
);
index a_ts on a(ts);
SELECT * FROM a WHERE ts @