Re: Latest advice on SSD?

2018-04-11 Thread Mark Kirkwood
The 512 Gb model is big enough that the SLC cache and performance is gonna be ok. What would worry me is the lifetime: individual 512 Gb 850 EVOs are rated at 150 Tb over 5 years. Compare that to the Intel S3710 - 400 Gb is rated at 8 Pb over 5 years. These drives are fast enough so that you *m

Re: [PERFORM] Dissuade the use of exclusion constraint index

2018-04-11 Thread Adam Brusselback
> Self contained examples do wonders Good point, will work on that and post once I have something usable.

Re: [PERFORM] Dissuade the use of exclusion constraint index

2018-04-11 Thread Dave Cramer
Adam, I think the first thing to do is to make hackers aware of the specifics of which indexes are being used etc so that the planner could be taught how to use better ones. Self contained examples do wonders Dave Cramer da...@postgresintl.com www.postgresintl.com On 11 April 2018 at 01:59, Ad