agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedPostgres 4.2 Problems...
2+ messages / 2 participants
[nested] [flat]
* Postgres 4.2 Problems...
@ 1994-08-18 16:13 sdalby@fuller.mech.utah.edu
1994-08-19 19:43 ` Re: Postgres 4.2 Problems... Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 1 reply; 2+ messages in thread
From: sdalby@fuller.mech.utah.edu @ 1994-08-18 16:13 UTC (permalink / raw)
To: legacy
Hello there,
We have five small Postgres databases against which we pose "randomly"
generated queries nightly. Under SunOS 4.1.1 and Postgres version
4.0.1 we were able to pose greater than 10,000 queries without any
Postgres problems. Now under Solaris 2.3 and Postgres 4.2 we are only
able to get about 3,000 before the ~postgres/data/pg_log file
(relation) balloons to 134 MB (the file is *extremely* sparse) and we
get the error:
WARN:Aug 15 10:17:08:cannot open segment 1 of relation pg_time
At this point we are not able to do any more with Postgres and our
homegrown solution is to use ~postgres/bin/cleardbdir,
~postgres/bin/initdb, and rebuild the five small databases.
As an experiment, we have also built Postgres 4.2 under SunOS 4.1.1.
Different problem here (the Postgres backend dies), but we are still
unable to get through as many queries as we were able to under version
4.0.1 of Postgres. In fact, the number of queries we are able to
process is similar to the number processed under Solaris 2.3.
Both versions passed the regression test when I built them. Has
anyone else experienced problems similar to this?
Sean Dalby
Department of Mechanical Engineering Design Systems Laboratory
University of Utah
sdalby@part.net
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres 4.2 Problems...
1994-08-18 16:13 Postgres 4.2 Problems... sdalby@fuller.mech.utah.edu
@ 1994-08-19 19:43 ` Paul M. Aoki <aoki@cs.berkeley.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1994-08-19 19:43 UTC (permalink / raw)
To: sdalby@fuller.mech.utah.edu; +Cc: legacy
sdalby@fuller.mech.utah.edu writes:
> We have five small Postgres databases against which we pose "randomly"
> generated queries nightly. Under SunOS 4.1.1 and Postgres version
> 4.0.1 we were able to pose greater than 10,000 queries without any
> Postgres problems. Now under Solaris 2.3 and Postgres 4.2 we are only
> able to get about 3,000 before the ~postgres/data/pg_log file
> (relation) balloons to 134 MB (the file is *extremely* sparse)
last night i ran 20000 insert/update/select statements against
one table on solaris 2.3 and sunos 4.1.3. the log/time tables
were exactly the size you would expect from 20000 committed
transactions (one bit per xact in log, four bytes per xact in
time, allocated in 8k pages):
bohemia:aoki (12)> ls -l $PGDATA/pg_{log,time}
-rw------- 1 postgres postgres 8192 Aug 19 06:27 /tmp/data/pg_log
-rw------- 1 postgres postgres 90112 Aug 19 06:27 /tmp/data/pg_time
bohemia:aoki (13)> uname -a
SunOS bohemia.cs.berkeley.edu 5.3 Generic sun4m sparc
i just unpacked the binary distribution (which uses gcc) and
used that. our solaris compiler license expired again so i
can't check that.
a sparse log file would normally suggest a lot of aborts, but it
seems hard to believe that postgres could even manage to *parse*
8 * 134,000,000 queries overnight, so i have no idea what might
be causing what you're seeing.. all i can say is, try the binary
distribution (if you aren't already) and see what happens.
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-08-19 19:43 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-08-18 16:13 Postgres 4.2 Problems... sdalby@fuller.mech.utah.edu
1994-08-19 19:43 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox