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
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
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
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
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
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
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://
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 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
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 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
>>>
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
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
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
15 matches
Mail list logo
