On Tue, 2004-12-14 at 16:50, Jimmie H. Apsey wrote:
> I think my indexes are OK.
>
> I have no settings for 'shared memory buffers' in postgresql.conf on
> either system. Both systems have same, i.e.
> #sort_mem = 512
> #shared_buffers = 2*max_connections # min 16
> #fsync = true
>
> Do you, or any of you, have any other suggestions for why such a
> simple "select count(*) from tpv;" should take six times as long on
> our latest and greatest dual processor server with almost the latest
> and greatest postgresql? View tpv is a three table join which takes
> 3.38 seconds on the 'old' system and 18.09 seconds on the 'new'
> system.
You really need to do an "explain analyze <query>" where <query> is the
query used to create the view. Post the output of that here. My guess
is one is using indexes to match up rows, the other is using seq scans.
Or something like that.