Mitch Pirtle <mitch.pirtle@xxxxxxxxx> writes: > I have a client that is testing an internal data platform, and they > were happy with PostgreSQL until they tried to join views - at that > time they discovered PostgreSQL was not using the indexes, and the > queries took 24 hours to execute as a result. You'll need to provide some actual details if you want useful comments. Let's see the table schemas, the view definitions, and the EXPLAIN plan (I'll spare you a request for EXPLAIN ANALYZE given that it'd take 24 hours to get ;-) ... although some estimate of the number of rows expected would be helpful). And I trust they remembered to ANALYZE the underlying tables first? Also, which PG version exactly? regards, tom lane
