Hi, I was wondering if there would be a detrimental effect of having tables with 150/200 columns in a table. I have a query which takes over 45 seconds to run on 2 tables which are joined. One table has 150 fields, the other has 200. They also have 86000 and 260000 records and 22 and 17 indexes respectively.
Its 8.2 running on windows with all the default postgres.conf settings.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.