pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems with version 7.1, could they be fixed in 7.2?
5+ messages / 3 participants
[nested] [flat]
* Problems with version 7.1, could they be fixed in 7.2?
@ 2002-08-26 23:54 Ligia Pimentel <pimentel_ligia@hotmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Ligia Pimentel @ 2002-08-26 23:54 UTC (permalink / raw)
To: pgsql-sql
I've been having problems with a database in postgres 7.1, this database
worked just fine for about 6 months, but it is a fast growing database (a
lot of records inserted every day, almost none deleted).
The problem is that the database started corrupting indexes, and tables
(even system tables, like pg_class). I posted my questions previously with
the specific messages, but sadly I got no reply :(...
I recovered a backup and installed it on another computer to verify that it
was not a hardware problem, but I kept having crashes every week.
Last week I decided to install a new computer with postgres 7.2 and I loaded
the database on this version. So far, no problem...
I would like to know if I could expect this problems to be fixed, because I
read on the documentation that version 7.2 was optimized for large
databases, or should I check something else.
Thank you.
Ligia
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Problems with version 7.1, could they be fixed in 7.2?
@ 2002-08-27 21:24 mark carew <markcarew@bigpond.com>
parent: Ligia Pimentel <pimentel_ligia@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: mark carew @ 2002-08-27 21:24 UTC (permalink / raw)
To: pgsql-sql
Hi Ligia,
Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never
remember, though reasonably sure that its the former).
Regards Mark Carew
Brisbane Australia
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Problems with version 7.1, could they be fixed in 7.2?
@ 2002-08-27 22:10 Ligia Pimentel <pimentel_ligia@hotmail.com>
parent: mark carew <markcarew@bigpond.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ligia Pimentel @ 2002-08-27 22:10 UTC (permalink / raw)
To: pgsql-sql
Yes we did. By the way, how often is it recomended?
Ligia
"mark carew" <markcarew@bigpond.com> wrote in message
news:akgr6p$vp2$1@news.hub.org...
> Hi Ligia,
>
> Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never
> remember, though reasonably sure that its the former).
>
> Regards Mark Carew
> Brisbane Australia
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Problems with version 7.1, could they be fixed in 7.2?
@ 2002-08-28 14:38 Ligia Pimentel <pimentel_ligia@hotmail.com>
parent: Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ligia Pimentel @ 2002-08-28 14:38 UTC (permalink / raw)
To: pgsql-sql
Ok. Got It. I thought that would help, also.
Thanks.
Ligia
"Stephan Szabo" <sszabo@megazone23.bigpanda.com> wrote in message
news:20020828080034.A85460-100000@megazone23.bigpanda.com...
> On Mon, 26 Aug 2002, Ligia Pimentel wrote:
>
> > I've been having problems with a database in postgres 7.1, this database
> > worked just fine for about 6 months, but it is a fast growing database
(a
> > lot of records inserted every day, almost none deleted).
> >
> > The problem is that the database started corrupting indexes, and tables
> > (even system tables, like pg_class). I posted my questions previously
with
> > the specific messages, but sadly I got no reply :(...
> >
> > I recovered a backup and installed it on another computer to verify that
it
> > was not a hardware problem, but I kept having crashes every week.
> >
> > Last week I decided to install a new computer with postgres 7.2 and I
loaded
> > the database on this version. So far, no problem...
> >
> > I would like to know if I could expect this problems to be fixed,
because I
> > read on the documentation that version 7.2 was optimized for large
> > databases, or should I check something else.
>
> Possibly, there were a bunch of bugs that were fixed between the two
> versions. There have still been reports of corruption on 7.2, but almost
> all of those have been traced to hardware problems. As a note, you
> probably want to run 7.2.2 if you're not already.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Problems with version 7.1, could they be fixed in 7.2?
@ 2002-08-28 15:04 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Ligia Pimentel <pimentel_ligia@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Stephan Szabo @ 2002-08-28 15:04 UTC (permalink / raw)
To: Ligia Pimentel <pimentel_ligia@hotmail.com>; +Cc: pgsql-sql
On Mon, 26 Aug 2002, Ligia Pimentel wrote:
> I've been having problems with a database in postgres 7.1, this database
> worked just fine for about 6 months, but it is a fast growing database (a
> lot of records inserted every day, almost none deleted).
>
> The problem is that the database started corrupting indexes, and tables
> (even system tables, like pg_class). I posted my questions previously with
> the specific messages, but sadly I got no reply :(...
>
> I recovered a backup and installed it on another computer to verify that it
> was not a hardware problem, but I kept having crashes every week.
>
> Last week I decided to install a new computer with postgres 7.2 and I loaded
> the database on this version. So far, no problem...
>
> I would like to know if I could expect this problems to be fixed, because I
> read on the documentation that version 7.2 was optimized for large
> databases, or should I check something else.
Possibly, there were a bunch of bugs that were fixed between the two
versions. There have still been reports of corruption on 7.2, but almost
all of those have been traced to hardware problems. As a note, you
probably want to run 7.2.2 if you're not already.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-08-28 15:04 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-26 23:54 Problems with version 7.1, could they be fixed in 7.2? Ligia Pimentel <pimentel_ligia@hotmail.com>
2002-08-27 21:24 ` mark carew <markcarew@bigpond.com>
2002-08-27 22:10 ` Ligia Pimentel <pimentel_ligia@hotmail.com>
2002-08-28 15:04 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-08-28 14:38 ` Ligia Pimentel <pimentel_ligia@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox