pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsee toast table
5+ messages / 3 participants
[nested] [flat]
* see toast table
@ 2003-05-21 16:49 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-23 12:51 ` Re: see toast table Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Eric Anderson Vianet SAO @ 2003-05-21 16:49 UTC (permalink / raw)
To: pgsql-sql
How coul i see a toast table.
i can´t visualise it at pgadmin.
tnx
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: see toast table
2003-05-21 16:49 see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
@ 2003-05-23 12:51 ` Jan Wieck <JanWieck@Yahoo.com>
2003-05-23 13:23 ` Re: see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Jan Wieck @ 2003-05-23 12:51 UTC (permalink / raw)
To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>; +Cc: pgsql-sql
Eric Anderson Vianet SAO wrote:
> How coul i see a toast table.
>
> i can´t visualise it at pgadmin.
I was wondering what you expect to see then? They are a technical
implementation detail within the storage management.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: see toast table
2003-05-21 16:49 see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-23 12:51 ` Re: see toast table Jan Wieck <JanWieck@Yahoo.com>
@ 2003-05-23 13:23 ` Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-24 21:11 ` Re: see toast table Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Eric Anderson Vianet SAO @ 2003-05-23 13:23 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: pgsql-sql
because the following error:
´missing chunk number 0 for toast value 32067496´
I get ir when I try ´vacuum -e -v -z -e´ or a simple pg_dump.
I would like to know what is this value. And how could i fix it.
tnx.
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Jan Wieck" <JanWieck@Yahoo.com>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: <pgsql-sql@postgresql.org>
Sent: Friday, May 23, 2003 9:51 AM
Subject: Re: [SQL] see toast table
> Eric Anderson Vianet SAO wrote:
> > How coul i see a toast table.
> >
> > i can´t visualise it at pgadmin.
>
> I was wondering what you expect to see then? They are a technical
> implementation detail within the storage management.
>
>
> Jan
>
> --
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: see toast table
2003-05-21 16:49 see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-23 12:51 ` Re: see toast table Jan Wieck <JanWieck@Yahoo.com>
2003-05-23 13:23 ` Re: see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
@ 2003-05-24 21:11 ` Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jan Wieck @ 2003-05-24 21:11 UTC (permalink / raw)
To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>; +Cc: pgsql-sql
Eric Anderson Vianet SAO wrote:
> because the following error:
>
> ´missing chunk number 0 for toast value 32067496´
>
> I get ir when I try ´vacuum -e -v -z -e´ or a simple pg_dump.
>
> I would like to know what is this value. And how could i fix it.
You have probably a corrupted toast index on a table. Try to reindex it
and if that doesn't help hunt down the damaged main row and update it's
toasted value with something fresh (there have been enough discussions
about it, you should find how to do that in the mailing list archives.
These discussions will also point out that you probably have some bad
memory and/or other non trustworthy piece of hardware including the
tools you should use to identify the damage.
Jan
>
> tnx.
>
> Eric Anderson Martins Miranda
> Net Admin @ Via Net SAO
> ----- Original Message -----
> From: "Jan Wieck" <JanWieck@Yahoo.com>
> To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
> Cc: <pgsql-sql@postgresql.org>
> Sent: Friday, May 23, 2003 9:51 AM
> Subject: Re: [SQL] see toast table
>
>
>
>>Eric Anderson Vianet SAO wrote:
>>
>>>How coul i see a toast table.
>>>
>>>i can´t visualise it at pgadmin.
>>
>>I was wondering what you expect to see then? They are a technical
>>implementation detail within the storage management.
>>
>>
>>Jan
>>
>>--
>>#======================================================================#
>># It's easier to get forgiveness for being wrong than for being right. #
>># Let's break this rule - forgive me. #
>>#================================================== JanWieck@Yahoo.com #
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: see toast table
@ 2003-05-23 07:25 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 5+ messages in thread
From: Christoph Haller @ 2003-05-23 07:25 UTC (permalink / raw)
To: pgsql-sql; +Cc: eric@vianet-express.com.br
>
> How could i see a toast table.
>
> i can't visualise it at pgadmin.
>
RTFM. Read The Fine Manual. Especially:
$PGSQLD/doc/html/catalog-pg-class.html
$PGSQLD/doc/html/monitoring-stats.html
$PGSQLD/doc/html/page.html
Regards, Christoph
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-05-24 21:11 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-21 16:49 see toast table Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-23 12:51 ` Jan Wieck <JanWieck@Yahoo.com>
2003-05-23 13:23 ` Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-05-24 21:11 ` Jan Wieck <JanWieck@Yahoo.com>
2003-05-23 07:25 Re: see toast table Christoph Haller <ch@rodos.fzk.de>
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