Re: sun solaris & postgres

Difference specification ??
How many memory in att and steph?
>
> OK, we have two different solaris machines:
>
> SunOS att 5.8 Generic sun4u sparc SUNW,Ultra-60
> and
> SunOS steph 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-4
>
> att is running
> psql (PostgreSQL) 7.0.3
> contains readline, history, multibyte support
>
> and steph is running
> psql (PostgreSQL) 7.2
> contains support for: readline, history, multibyte
>
> We've got a web server using the postgres database for its queries.
> We're seeing some contradictory data, some of which suggests that
> att is faster than steph and at other times the other way around.
>
> If we search on an item that is not to be found in our entries,
> steph goes through the postgres entries faster than att, perhaps
> by about 10% (not a markedly faster rate, but distinctly faster).
> If we search on an item that is commonly found and display 100
> results at a time on each page, then what takes att 5 seconds to
> generate and display takes steph 30 seconds to do the same thing.
>
> Our tech support is convinced that postgres is running slower on
> steph.  I don't think that's the entire story, given the different
> results for the different kinds of searches, but I'd appreciate any
> suggestions or feedback any of you have, particularly in regards to
> what might improve performance on steph.
>
> Is there any indication that 7.2 is slower overall than 7.0.3?
>
> We use the same script to set up the postgres files on each machine,
> so they're both configured the same way with respect to indexing
> and vaccum/analyse.
>
> Thanks,
> --Cindy
> --
> ctmoore@uci.edu
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>