I want to ask if its possible that a situation where the main table is in a different tablespace from the index if it affects performance. i have a senario where a large table 250GB is in a tablespace and the indexes (3) with an average size of 40GB is in default tablespace. could this be the reason why queries are slow
Asked
Active
Viewed 236 times
-1
-
1https://wiki.postgresql.org/wiki/Slow_Query_Questions – Frank Heikens Feb 21 '22 at 12:00
1 Answers
0
No, unless one of these tablespaces is on slow storage.
Laurenz Albe
- 209,280
- 17
- 206
- 263
-
I confirm that Laurenz says and must admit that there is no problem even if the storage of indexes was much more slow than the table storage because the data are physically writes on disk asynchronously... But separates data table from indexes is an outdated form of storage needed when disk was very costly (1980/1995)... – SQLpro Feb 21 '22 at 12:59