I have a table that has roughly 750,000 records. The table has 7 columns one of which is a text field where we have large text, ranging from a few hundred chars to a few KB of data. A simple select * is taking roughly 9 minutes to fetch all data.
I am new to PostgreSQL and I am not sure if this is what I should expect from it in terms of performance. If I remove the text field in which I store large data from my select query the time drops to roughly 4 minutes which again is quite high.
The Explain Analyze shows the following:
Select all columns:
Seq Scan on myTable (cost=0.00..37193.62 rows=749962 width=332)
Select all columns except the large text field:
Seq Scan on myTable (cost=0.00..37193.62 rows=749962 width=69)
I am not really sure what to conclude from this, any help in improving the performance is appreciated.