sun solaris & postgres 
Author Message
 sun solaris & postgres

 >
 >Difference specification ??
 >How many memory in att and steph?

steph has
Memory size: 4096 Megabytes
att has
Memory size: 512 Megabytes

--Cindy

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/



Sat, 06 Nov 2004 02:42:05 GMT
 sun solaris & postgres

That could be why 7.1.3 is out performing it has 8 times more memory than
the 7.2.1 machine

What about CPU's, controllers and are both config files the same for steph
and att?

Darren Ferguson

Quote:


>  >Difference specification ??
>  >How many memory in att and steph?

> steph has
> Memory size: 4096 Megabytes
> att has
> Memory size: 512 Megabytes

> --Cindy

> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

> http://www.postgresql.org/users-lounge/docs/faq.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Sat, 06 Nov 2004 04:29:32 GMT
 sun solaris & postgres

I figured out at least part of the problem...

Quote:
Neil Conway writes:

 >Can you post the EXPLAIN results for the 30-sec/5-sec query on 7.0.3,
 >the EXPLAIN ANALYZE results for 7.2, and the relevant bits of the schema?

on att:
Text=> explain SELECT get_citation(4,1,815460);
NOTICE:  QUERY PLAN:

Result  (cost=0.00..0.00 rows=0 width=0)

EXPLAIN
Text=>

on steph:
Text=# explain analyze SELECT get_citation(4,1,815460);
NOTICE:  QUERY PLAN:

Result  (cost=0.00..0.01 rows=1 width=0) (actual time=12.74..132.06 rows=1 loops=1)
Total runtime: 132.23 msec

EXPLAIN
Text=#

on both att, steph, the table is set up as follows:

      create table citations
                  (aid smallint, wid smallint,
                   citation varchar(50),
                   byteloc integer);

      create function get_citation (int2, int2, int4)
        returns SETOF varchar AS
        'select citation from citations where
           aid = $1 and wid = $2 and byteloc = $3'
        LANGUAGE 'SQL';

      truncate citations;
      copy citations from '/data/home/tlg/src/citegen/fullIds.txt';
      create index awbyte_idx on citations(aid,wid,byteloc);
      cluster awbyte_idx on citations;
      create index awcite_idx on citations(aid,wid,citation);
      vacuum citations;
      vacuum analyze citations;

I just found the problem, based in part on the explains.  After changing
the function to

      create function get_citation (int4, int4, int4)
        returns SETOF varchar AS
        'select citation from citations where
           aid = $1::smallint and wid = $2::smallint and byteloc = $3'
        LANGUAGE 'SQL';

on steph, the performance has pretty much improved to match that of att.
Would the changes between 7.0 and 7.2 account for this?  (There's no
explain analyze in 7.0, so I can't make a more detailed analysis of the
function on att.)  But now on steph:

Text=# explain analyze SELECT get_citation(4,1,815460);
NOTICE:  QUERY PLAN:

Result  (cost=0.00..0.01 rows=1 width=0) (actual time=6.83..6.87 rows=1 loops=1)
Total runtime: 7.00 msec

EXPLAIN

--
Cindy

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sat, 06 Nov 2004 06:33:04 GMT
 sun solaris & postgres

No, if you read more carefully, att is the one that is performing its
operations an order of magnitude faster than steph, which is why we're
so stumped.  But I think I located the problem (see other email).

Quote:
Darren Ferguson writes:

 >That could be why 7.1.3 is out performing it has 8 times more memory than
 >the 7.2.1 machine
 >
 >What about CPU's, controllers and are both config files the same for steph
 >and att?
 >
 >Darren Ferguson
 >

 >
 >>
 >>  >
 >>  >Difference specification ??
 >>  >How many memory in att and steph?
 >>
 >> steph has
 >> Memory size: 4096 Megabytes
 >> att has
 >> Memory size: 512 Megabytes
 >>
 >> --Cindy
 >>
 >> ---------------------------(end of broadcast)---------------------------
 >> TIP 5: Have you checked our extensive FAQ?
 >>
 >> http://www.postgresql.org/users-lounge/docs/faq.html
 >>
 >
 >
 >---------------------------(end of broadcast)---------------------------
 >TIP 6: Have you searched our list archives?
 >
 >http://archives.postgresql.org
 >

--
Cindy

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sat, 06 Nov 2004 06:36:24 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. sun sparc oracle solaris--- && troubles

2. IDS 9.21 & SUN Solaris OS

3. NT Oracle Enterprise Manager & Sun Solaris Server

4. Oratab & Sun Solaris HA

5. Informix 4.1 & Sun SOLARIS v2.4

6. (Fwd) Sun OS to Sun Solaris Ingres Upgrade

7. Sun Informix Client and Sun Solaris Server

8. GA-Atlanta-261131--ORACLE-UNIX-Solaris-SUN-Windows NT-Database Administrator (DBA)-Oracle/UNIX/Solaris

9. porting postgres to Sun 386i platform

10. PHP/Postgres/Solaris problem

11. Postgres port for Solaris


 
Powered by phpBB® Forum Software