I have been experiencing some very slow queries for a specific table. This table grows daily. I ran the pg_relation_size function, which gives the size of a table in the database:
mydb=# select pg_relation_size('reports'); pg_relation_size ------------------ 10318856192 (1 row)
Now I assume the return value is in bytes. So if I wanted gigabyte size, then this is basically saying 10.3 gigabytes. Could a table that is in 10 gigabytes in size really reduce the performance of queries against that table?