New answers tagged tablespaces
How much improvement are you expecting from the SSD? It is surprising how little physical I/O actually happens on busy indexes and I don't think I've ever solved an actual performance problem with physical I/O devices. I don't know enough about PostgresSQL to comment on buffering or recoverability and the like but I will say that choosing performance over ...
I have identified the problem: it was caused by pgsql_tmp dir in the tbs_ibi_dat tablespace. I ran a bad query with many sorting data so PostgreSQL stored that sorting data in that directory.
A tablespace can contain tables from more than one database. The extra space must be from another database.
Top 50 recent answers are included