Hi Scott, Kevin, Alvaro, and everybody else:
Many thanks for your help and advices. After vacuuming
and reindexing all tables, my nightly run zipped right
through at amazing speed.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
S
Hi,
We've started getting duplicate key violates unique constraint error on
one of the toast index starting last weekend. This error occurs when
attempting to update a huge table.
ERROR: duplicate key violates unique constraint
"pg_toast_3270368541_index"
PG version is 8.0 with
On Nov 14, 2007 3:33 PM, Kevin Grittner <[EMAIL PROTECTED]> wrote:
> >>> On Wed, Nov 14, 2007 at 3:16 PM, in message
> <[EMAIL PROTECTED]>, "Scott Marlowe"
> <[EMAIL PROTECTED]> wrote:
>
> > On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> >> INFO: vacuuming "public.allele"
> >>
Hi,
In looking at some cacti memory usage graphs, the Oracle servers show only 6
of a total of16 GB of RAM as 'Total Available'. Whereas, our Postgres version
8.24 servers show all 16 GB of RAM totally available or free.Some people
are asking why Postgres doesn't take that memory
Hi Scott,
Many thanks for your suggestion. I have issued a
bit heavier command prior to reading your mail.
At psql prompt, I (as superuser) typed:
# vacuum full verbose analyse;
and it spewing many, many lines. The tail end of
the output from it looks like:
INFO: vacuuming "public.allele"
I
>>> On Wed, Nov 14, 2007 at 3:16 PM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>> INFO: vacuuming "public.allele"
>> INFO: "allele": found 2518282 removable, 1257262 nonremovable row versions
>
On Nov 14, 2007 3:13 PM, dx k9 <[EMAIL PROTECTED]> wrote:
>
>In looking at some cacti memory usage graphs, the Oracle servers show
> only 6 of a total of16 GB of RAM as 'Total Available'. Whereas, our
> Postgres version 8.24 servers show all 16 GB of RAM totally available or
> free.Some p
On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> Hi Scott,
>
> Many thanks for your suggestion. I have issued a
> bit heavier command prior to reading your mail.
>
> At psql prompt, I (as superuser) typed:
># vacuum full verbose analyse;
OK, I had just wanted vacuum verbo
"Juan Miguel Paredes" <[EMAIL PROTECTED]> writes:
> ... But when trying to
> start Postgresql with the recovered location, we get the following
> error:
> " * Error: The server must be started under the locale : which does
> not exist any more."
There is no such message text in the standard Postg
Hi, folks!
Due to a hardware (hard disk) problem, we've tried to restore a
postgresql filesystem backup (taken from what was left on the drive)
to a fresh Postgresql install (as stated in
http://www.postgresql.org/docs/8.1/interactive/backup-file.html),
checking the appropiate ownership, privilege
On Nov 14, 2007 12:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>
> The postgres server I have (on redhat linux 2.6 with recent
> Dell hardware (4 cpus)) is running terribly slow.
>
> A job it should have gotten done in less than 1 hour
> took 7.5 hours last night.
OK, before you try to fix th
Tena Sakai wrote:
> I checked kernel parameter
> shmmax and it was set as 33554432. I "fixed" it as
> suggested by the manual:
> http://www.postgresql.org/docs/8.2/static/kernel-resources.html
Note that just by changing shmmax you're not doing anything to Postgres
itself. If you want Postgres t
Hi Everybody,
The postgres server I have (on redhat linux 2.6 with recent
Dell hardware (4 cpus)) is running terribly slow.
A job it should have gotten done in less than 1 hour
took 7.5 hours last night.
The job I am referencing above gets run via crontab every
evening and I comb the log file fa
Hutger Hauer a écrit :
Dear all,
I'm looking for a monitoring tool that helps me to pick performance
informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB
or table, such as MRTG does.
Does someone know a tool that can provide me such information?
Have a look
Dear all,
I'm looking for a monitoring tool that helps me to pick performance
informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB
or table, such as MRTG does.
Does someone know a tool that can provide me such information?
Thanks in advance.
Hutger
15 matches
Mail list logo
