pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Issue while using PostgreSql 8.4.
2+ messages / 2 participants
[nested] [flat]

* Issue while using PostgreSql 8.4.
@ 2010-12-23 08:31  Atul Kumar <Atul_Kumar@persistent.co.in>
  0 siblings, 1 reply; 2+ messages in thread

From: Atul Kumar @ 2010-12-23 08:31 UTC (permalink / raw)
  To: pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>; pgsql-sql; pgsql-general@postgresql.org <pgsql-general@postgresql.org>

Hi,
                I am using PostgreSql  8.4 for my web application also  am using following technology stacks:

1>     Java

2>     Window XP (OS).

3>     JBoss Server4.2.
My issue is, first time I am creating the table and inserting some rows of data. After doing some logic going to delete that table . I am observing application is getting hang while executing statement.execute().

Please suggest me how to fix this issue.

Thanks
Atul Kumar

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Issue while using PostgreSql 8.4.
@ 2010-12-23 15:23  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Atul Kumar <Atul_Kumar@persistent.co.in>
  0 siblings, 0 replies; 2+ messages in thread

From: Kevin Grittner @ 2010-12-23 15:23 UTC (permalink / raw)
  To: Atul Kumar <Atul_Kumar@persistent.co.in>; pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>; pgsql-general@postgresql.org <pgsql-general@postgresql.org>; pgsql-sql

Atul Kumar <Atul_Kumar@persistent.co.in> wrote:
 
> My issue is, first time I am creating the table and inserting some
> rows of data. After doing some logic going to delete that table .
> I am observing application is getting hang while executing
> statement.execute().
 
It's taking a long time to run which statement, a DELETE of all rows
in a table?
 
This isn't sounding much like a PostgreSQL bug at this point, but
with so little information, it is hard to tell for sure.  Please
review this page:
 
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
 
As a "shot in the dark" -- if the statement which is taking a long
time is the DELETE, and you want to delete all rows in the table,
try TRUNCATE TABLE.
 
-Kevin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-12-23 15:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-23 08:31 Issue while using PostgreSql 8.4. Atul Kumar <Atul_Kumar@persistent.co.in>
2010-12-23 15:23 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox