Hi,
I tried to troubleshoot the errors while importing dumps in PostgreSQL -
8.0.0 version. But still i'm getting some permission level errors. Before
importing the dumps, i used to install some functions like
ltree,tsearch2,pgcrypto from directory
/usr/local/src/postgresql-8.0/contrib. So that i
Hi,
On 14 July 2011 14:17, Jenish Vyas wrote:
> Hi All,
> Can you guide me how to find out the read activities for stored functions in
> database?
> (How many times function called in specific time frame)
I hope this will help you
http://www.postgresql.org/docs/current/interactive/pgstatstatemen
Zitat von Kevin Grittner :
Jenish Vyas wrote:
I am able to insert 1190- 1210 records per seconds.
Now I just want to know by what extend I could stretch it.
What is the maximum insert I can achieve in one second? What is
the maximum number of insert postgresql achieved so far?
I don't ha
On Fri, Jul 15, 2011 at 2:09 AM, wrote:
> Zitat von Kevin Grittner :
>
>> Jenish Vyas wrote:
>>
>>> I am able to insert 1190- 1210 records per seconds.
>>>
>>> Now I just want to know by what extend I could stretch it.
>>>
>>> What is the maximum insert I can achieve in one second? What is
>>>
On Fri, Jul 15, 2011 at 3:39 AM, Scott Marlowe wrote:
>
> System: SuperMicro H8QG6
> 4xAMD Opteron(tm) Processor 6168
> Total 48 cores
> 128G RAM
> Areca 1680 w 512M battery backed cache
> 32 15k SAS 147Gig drives
>
> pgbench -i -s 100
> pgbench -c 48 -t 1
> tps = .626762 (including connec
On Fri, Jul 15, 2011 at 1:11 AM, saravanan wrote:
> Hi,
>
> I tried to troubleshoot the errors while importing dumps in PostgreSQL -
> 8.0.0 version. But still i'm getting some permission level errors. Before
> importing the dumps, i used to install some functions like
> ltree,tsearch2,pgcrypto fr
Hello,
I am new to this list and hope I have chosen the appropriate group to
ask this question.
We are running version 8.2.6 of postgres and I am trying to run a full
vacuum on a single table in our database. I started the vacuum about 24
hours ago and it is still running. Within 2-3 hrs o
Hello,
I am new to this list and hope I have chosen the appropriate group to
ask this question.
We are running version 8.2.6 of postgres and I am trying to run a full
vacuum on a single table in our database. I started the vacuum about 24
hours ago and it is still running. Within 2-3 hrs o
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik wrote:
> Since then, the process has continued to run (for about 20 hrs) without any
> additional information being returned.
Probably locked behind another long running task that is holding a buffer pin.
--
Simon Riggs http://
Simon - thanks for the response. I checked all the processes and
nothing appears to be holding it up. Any other advice?
Simon Riggs said the following on 7/15/2011 12:21 PM:
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik wrote:
Since then, the process has continued to run (for about 20 hr
Simon Riggs writes:
> On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik
> wrote:
>> Since then, the process has continued to run (for about 20 hrs) without any
>> additional information being returned.
> Probably locked behind another long running task that is holding a buffer pin.
That's possib
Tom,
It was not consuming any CPU time. I found that another process on the
machine failed. That process was trying to write to a different table
(not the one I was vacuuming) in the database and that table was locked
(not sure why). It produced thousands of errors which caused the log
file
David Ondrejik writes:
> I am still wondering how the vacuum process actually works. When it
> throws the output lines that show how many rows are
> recoverable/nonremovable, does this mean that the vacuum has completed?
No, that's just the end of the first pass over the table. After that it
David Ondrejik wrote:
> So I had to kill my process, recover disk space and get the
> machine back in working condition for the weekend. I guess I will
> attempt to do the full vacuum again next week.
Why do you think that you need a VACUUM FULL? That is only needed
as an extreme measure in r
Hello PGlist,
We are interested in migrate some data with identity/sequential columns
from a non PG database into PG database , tables with identity columns.
First Q is : are system generated/identity columns values supported in
PG8.4 if yes,
I would like to know if there is a option to control
15 matches
Mail list logo
