Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: postgres and access

    Hi

    I'm trying to create a backend postgres database in order to provide data for a frontend Access database.
    unfortunately, I can't remove the Access database and replace it by the postgres database.
    what I'd like to do is to run access queries to postgres views
    but I have performances problems :
    Despite the postgres tables are very huge ( from 300000 rows to 10 million rows,more than 50 colums, and I can't alter them) I thought the postgres server would create the views quickly but on the contrary, it works very slowly, it takes more than one hour to fullfill a view !
    I tried different configurations of the postgres ODBC driver, but nothing changes...
    what can I do to improve the performances ?
    or is postgres unable to hang on with huge tables and views ?
    that would surprise me...

  2. #2
    Join Date
    Sep 2003
    Location
    Wisconsin, USA
    Posts
    34
    First off, it sounds like your database needs to be better-normalized ... but that's not possible in this case if you can't alter the tables -or- the views .... This is a tough one to answer without seeing your data or queries, but I know pg can handle databases that size without much problem if they're properly optimized.

    My first guess off the top of my head is that your DB isn't properly indexed.


    I don't want to repeat what's already out there, so I'll point you to http://techdocs.postgresql.org/ (specifically the "Optimising" section.)

    And http://www.freebsddiary.org/postgresql-analyze.php (a good site explaining the basics of how one person optimized his db).


    Sounds like what you really need is some good DB overhaul work tho.

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Thumbs up Try OPenOffice

    Openoffice could be a berrter backend for a postgresql database ! with the possibility to run queries : http://dba.openoffice.org/drivers/postgresql/index.html
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •