Karsten Hilbert <Karsten.Hilbert@xxxxxxx> writes: > The view in question is in fact a lot more complicated. This > is the best I've been able to come up with so far (and it is > still slow - slow as in 3-4 seconds for 20 records out of > (currently only) 50 !): What does EXPLAIN ANALYZE say about it? Also, what is the use-case you are concerned about --- selecting the whole view contents, or selecting WHERE something-or-other? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
