Hi Steve,
This is a very good website. We use the postgresql 8.2. there may be a little
different. It's very useful to me.
Thanks.
Regards.
Grace
At 2012-05-18 03:02:41,"Steve Crawford" wrote:
>On 05/17/2012 11:54 AM, leaf_yxj wrote:
>> I know we can know the currenct activity via pg_s
On 05/17/2012 11:54 AM, leaf_yxj wrote:
I know we can know the currenct activity via pg_stat_activity. What's else
you guys use to debug.
And for some times back, how can we check the activities?
Thanks.
Grace
Performance is a complex enough issue to warrant its own mailing list
(CPU type, num
I know we can know the currenct activity via pg_stat_activity. What's else
you guys use to debug.
And for some times back, how can we check the activities?
Thanks.
Grace
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-syste
On 6/3/2010 5:43 AM, Jamie Lawrence-Jenner wrote:
>
> Hi All
>
> In SQL Server I could copy sql code out of an application and paste it
> into SSMS, declare & assign vars that exist in the sql and run.. yay
> great debugging scenario.
>
> e.g. (please note I am rusty and syntax may be incorrect)
On 3 Jun 2010, at 12:43, Jamie Lawrence-Jenner wrote:
> Hi All
>
> In SQL Server I could copy sql code out of an application and paste it into
> SSMS, declare & assign vars that exist in the sql and run.. yay great
> debugging scenario.
>
> e.g. (please note I am rusty and syntax may be incorr
Hi All
In SQL Server I could copy sql code out of an application and paste it into
SSMS, declare & assign vars that exist in the sql and run.. yay great
debugging scenario.
e.g. (please note I am rusty and syntax may be incorrect)
declare @x as varchar(10)
set @x = 'abc'
select * from sometable
sunpeng escribió:
> how to debug the codes in the PostgresMain() from the begining of this
> function to the "for (;;)" loop that handles the connection?
> if i use eclipse cdt to attach the postgres process forked by postmaster,
> this part of codes from the begining of this PostgresMain() to the
how to debug the codes in the PostgresMain() from the begining of this
function to the "for (;;)" loop that handles the connection?
if i use eclipse cdt to attach the postgres process forked by postmaster,
this part of codes from the begining of this PostgresMain() to the "for
(;;)" loop could not
how to debug the codes in the PostgresMain() from the begining of this
function to the "for (;;)" loop that handles the connection?
if i use eclipse cdt to attach the postgres process forked by postmaster,
this part of codes from the begining of this PostgresMain() to the "for
(;;)" loop could not
Tom Lane <[EMAIL PROTECTED]> writes:
> What python version? (Hint: pre-8.2 plpython is known not to work
> with python 2.5)
This is more to confirm what I've found in practice and couldn't find at the
online docs for 8.2: is it possible to use output variables to write stored
procedures in plpyt
Tom Lane <[EMAIL PROTECTED]> writes:
> Jorge Godoy <[EMAIL PROTECTED]> writes:
>> This is with:
>
>> OpenSuSE 10.2
>> postgresql-server-8.1.5-13
>> postgresql-libs-8.1.5-13
>> postgresql-docs-8.1.5-13
>> postgresql-devel-8.1.5-13
>> postgresql-8.1.5-13
>> postgresql-pl-8.1.5-15
>
> What python ver
Jorge Godoy <[EMAIL PROTECTED]> writes:
> This is with:
> OpenSuSE 10.2
> postgresql-server-8.1.5-13
> postgresql-libs-8.1.5-13
> postgresql-docs-8.1.5-13
> postgresql-devel-8.1.5-13
> postgresql-8.1.5-13
> postgresql-pl-8.1.5-15
What python version? (Hint: pre-8.2 plpython is known not to work
Hi!
I've updated my system and after importing some old data I started getting
this message:
*** glibc detected *** postgres: godoy neo localhost(34476) SELECT: double free
or corruption (out): 0x08494440 ***
hi
i down loaded the postgre sql source code and compile it, can any body
plz tell that how to debug it in windows platform
regards
srinivasa
_
NRIs Zero balance Account. FREE Money Transfers with FREE DVD
https://www.online.citib
[snip]
> So what is the UPDATE doing? What is the query (see pg_stat_activity)
> doing? Is it updating a lot of rows? If the query does run for a long
> time holding any kind of lock, you're going to get strange effects like
> this.
The UPDATE is processing ~ 100 rows in a transaction (I'm not sur
> Well, I've had time to read your previous message too.
>
> The first time you seem to imply the machine slowed down across all
> processes - ssh etc. Was that the case this time?
OK, the slowdown/crash was a different problem, which might have been
caused by a "too many files open" problem co
Richar, Martijn,
Thanks for answering, but I had to kill the process in the meantime. I
tried kill -11 in the hope it will produce a core dump at least, but it
either didn't dump core or I don't know where to look for it as I can't
find it.
In any case, this is the second time I experience such a
Csaba Nagy <[EMAIL PROTECTED]> writes:
> I have right now a locked backend, similar to what I had a few days ago.
> It won't answer to pg_cancel_backend.
> Is there a way to diagnoze what it is actually doing ?
> If you answer, please do it quickly as in max 15 minutes I'll kill -9
> ...
This pos
Csaba Nagy wrote:
Hi all,
I have right now a locked backend, similar to what I had a few days ago.
It won't answer to pg_cancel_backend.
Is there a way to diagnoze what it is actually doing ?
If you answer, please do it quickly as in max 15 minutes I'll kill -9
Have you tried "strace -p " to
n
cancel the query.
Yours,
Aarjan
- Original Message -
From: "Csaba Nagy" <[EMAIL PROTECTED]>
To: "Postgres general mailing list"
Sent: Friday, November 18, 2005 12:13 PM
Subject: [GENERAL] How to debug a locked backend ?
> Hi all,
>
> I have right now a lock
Attach with gdb:
gdb -p [pid]
You may need to specify the the executable on some platforms.
On Fri, Nov 18, 2005 at 12:13:00PM +0100, Csaba Nagy wrote:
> Hi all,
>
> I have right now a locked backend, similar to what I had a few days ago.
> It won't answer to pg_cancel_backend.
> Is there a way
Hi all,
I have right now a locked backend, similar to what I had a few days ago.
It won't answer to pg_cancel_backend.
Is there a way to diagnoze what it is actually doing ?
If you answer, please do it quickly as in max 15 minutes I'll kill -9
...
Thanks,
Csaba.
---(en
On Fri, Oct 01, 2004 at 03:05:14PM +0200, Henriksen, Jonas F wrote:
> I'm writing some simple triggers and functions for a postgres
> database, and I'm wondering how to go about to debug a
> pl/pgSQL-script. Is there a way to echo variable-content to screen, or
> to file? Or is there other, more a
Hi,
http://www.postgresql.org/docs/7.4/static/plpgsql-errors-and-messages.html
Albert
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
I'm writing some simple triggers and functions for a postgres database, and I'm
wondering how to go about to debug a pl/pgSQL-script. Is there a way to echo
variable-content to screen, or to file? Or is there other, more advanced ways of
debugging such scripts?
regards Jonas:))
-
25 matches
Mail list logo
