|
This is my first question here, so I would like to say hello to
everyone:) In my case, the problem appears when I want to fetch some data to inflate the table with it. First of all, I am counting the records from the table (for paging, over indexed column), then the select query is performed (with limit equal to 15). I use the c3p0 library to manage the pool connections to the database and what I get is the timeout: both queries (separately) can take longer than 150 seconds. If I execute the query straight on the database (without usage of jdbc), it sometimes takes even 11 minutes to complete. Month or two ago I vacuumed the database manually. Now I can see - in the last_vacuum and last_autovacuum from the pg_stat_all_tables - that the nulls are written there. There are about 35 milion records in the table. Details:
And here is the question, which I posted on the Stackoverflow two months ago: http://stackoverflow.com/questions/33009865/why-index-only-scan-is-taking-so-long I would appreciate any help/tips. |
<<attachment: smime.p7s>>
