Re: tablespace to benefit from ssd ?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: tablespace to benefit from ssd ?
Дата
Msg-id CAMkU=1y6y25GLgcL+2DZt4J8+x=9tZy5kXA2sz5Uy5u-G5vRgA@mail.gmail.com
обсуждение исходный текст
Ответ на tablespace to benefit from ssd ?  (Nicolas PARIS <nicolas.paris@riseup.net>)
Список pgsql-performance
On Tue, Feb 18, 2020, 11:42 PM Nicolas PARIS <nicolas.paris@riseup.net> wrote:
 However the server has a large amount of ram
memory and I suspect all of those indexes are already cached in ram.

Then there may be no benefit to be had.


I have read that tablespaces introduce overhead of maintenance and
introduce complication for replication.

Yes, they are a nuisance for the humans who need to document, maintain, configure, etc. And they can induce administrators into making mistakes which can prolong outages or cause data loss.

But on the other hand I have
this ssd disk ready for something.

That isn't a good reason.  Unless your users are complaining, or you think they will be soon as things scale up, or you think they would be complaining of they weren't too apathetic to, then I would make no change that adds complexity just because the hardware exists.

But I would turn on track_io_timing, and load pg_stat_statements, and probably set up auto_explain.  That way when problems do arrive, you will be prepared to tackle them with empirical data.

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Lars Aksel Opsahl
Дата:
Сообщение: Re: SubtransControlLock and performance problems
Следующее
От: Patrick FICHE
Дата:
Сообщение: RE: Can we have multiple tablespaces with in a database.