I would like some assistance in understanding of template1 database.- I want to
know the tables of tempate1- I want to know when there is any
insertion/updation in template1 theoretically.- If i want to monitor the
transactions done in the template1 database ( insertion/updation ) , is there
an
> > - I want to know the tables of tempate1> > There are none, unless you
> > choose to add some.I got it there are no tables. What about the system
> > tables of template1 database ? Are they updated or not?
> > - If i want to monitor the transactions done in the template1 database (
> > inserti
I am working on some legacy product. In which template1 vacuuming with Analyze
is executed through cron job every one hour and some times it is taking lot of
time.I want to know if there is any major update/insert in template1 at some
time, so i wanted to monitor the number of insertions and del
$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relations found.
I am getting as mentioned above. I am not sure what is taking vacuuming long
time.
- What is the recommendation of vacuuming for wraparound issue for template1 -
Once
What should be the interval for calling vacuum on template1 and postgres
database in case
1. No table is created on template1.
Should i pass analyze parameter for template1 and postgres vacuum.
.05>poll([{fd=3,
events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLIN}]) <35.027745>
regards,S H
Hi,
I have my database in which i am executing vacuuming running manually in one
hour.
In my production database sometime when vacuuming is running it is taking long
time in opening connection.
My current version is version 8.1. Is there any known issue about open
connection problem with vacuu
acuum problem
> From: scott.marl...@gmail.com
> To: msq...@live.com
> CC: pgsql-general@postgresql.org
>
> On Mon, May 13, 2013 at 8:05 AM, S H wrote:
> > Hi,
> >
> > I have my database in which i am executing vacuuming running manually in one
> > hour.
>
My disk is utilized by many other components, thus do we have minimum
recommendation my postgres to have sufficient speed. Current perfomance of my
disk is around 1-5MB/sec. Is it sufficient?
Is it slow and can be cause of slow vacuuming..
> I wonder if you've got a bloated pg catalog then. Certainly sounds
> like it's a possibility.
> So other than vacuuming when you recreate this, is the server working
> hard? What is vacuum vacuuming when this happens (pg_stat_activity
> should show that)
Does vacuum full is required to avoid bloa
I am doing some experiment to
understand the behaviour of manual vacuum.
I created small
table and started doing insertion/deletion/updation on 2 rows in infinite loop.
It started bloating around 844 times, but after it stopped bloating.. what
could be the reason?
In between i am running manual
Got some information from following
http://www.depesz.com/2011/07/06/bloat-happens/
What is the general solution to avoid bloating.
> On Tue, 2013-05-14 at 14:51 +0000, S H wrote:
> > I am doing some experiment to understand the behaviour of manual
> > vacuum.
> >
> >
I am doing regular insertion/deletion on the same tables .. and running vacuum
in an hour...
I suspect there is bloating in my tables.. but how does bloating in pgcatalog
is happening is not clear...> Normally vacuum full is NOT required on a regular
basis. However, if
> you did something like
I confirmed that there is no bloating unfortunately.
Did some experiment and it seems that connection open are always slow in case
of vacuuming..
- Experiment done are as follows:-- Do frequent vacuuming.- Execute xx
connections every min and close after one sec.- when vacuum is running
connec
Hi,
I have faced very strange problem in one of psotgresql query in one of the
production environment. It is working fine in development and other environment.
Current value in colname = 5;Update tablename set colname = 0 where key =
18;commit , in parallel to above queries ( either vacuum or re
ted to commit problem in 8.1 version.
> Date: Wed, 7 Aug 2013 17:05:59 -0700
> From: adrian.kla...@gmail.com
> To: msq...@live.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Commit problem in read-commited isolation level
>
> On 08/07/2013 04:54 PM, S H wrote:
&
> 1) What is your exact Postgres version i.e 8.1.5.?
V - 8.1.18
> 3) You also say it works fine in two environments, but not one.
>
> What are the environments?
> OS and version, memory, Postgres versions, etc.
It is working on most of the production system ( more than 100) but failed once
in on
gresql.org/docs/8.1/static/release-8-1-7.html
and above comment.
Regards,S H
...@live.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Commit hung bug
>
> S H wrote:
> > There is one bug mentioned commit hung for days..
> > http://www.postgresql.org/message-id/1af3044fcab26f4db1ae551f8a33634b3d2...@mail.digital-rapids.com
> > &
Dear Sally Sally ,
I had a few questions concerning the backup/restore process for pg.
1) Is it possible to dump data onto an existing database that contains
data (assumning the schema of both are the same). Has anyone done
this? I am thinking of this in order to expediate the data load proces
Dear twosk
I heard from somone that i could use PostgreSQL, but I cannot find any information
that confirms or denies it.
AFAIK There was a discussion on the same topic in Dec2003 please search
the list and you will geta solution
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Her
Dear Shelby Cain ,
Is this expected behavior or perhaps a bug?
For a novice like me can anyone please tell me
1. Will this effect my application developed on PostgreSQL
2. Will my Application break at some point I heavly use the type of
queries defined in the post.
Would be greatfull for
Dear Mage ,
I'm wondering why pgsql doesn't support boolean typecasts like select
true::int;
Many client applications including php assign 1 to true and 0 to false
This was a issue PHP < 4.2 + < PostgreSQL 7.3.x and supports it till
now for backward compatibility
--
Best Regards,
Vishal Kash
Dear Bill Moran ,
I know the correct solution is to use the same version to develop
on that I'm using to test. So I'm going to downgrade my version
to 7.3.4 for now ... but this doesn't solve my biggest problem:
getting the FOR loop to work. It appears from the error that
the parser is getting c
24 matches
Mail list logo
