pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feednotify and leaks?
2+ messages / 2 participants
[nested] [flat]
* notify and leaks?
@ 2004-04-07 16:30 Theodore Petrosky <tedpet5@yahoo.com>
2004-04-07 18:27 ` Re: notify and leaks? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Theodore Petrosky @ 2004-04-07 16:30 UTC (permalink / raw)
To: pgsql-sql
I am using postgresql as the backend to a job tracking
system. My front app is running only on Mac OS X.
I have been using notifications from postgresql to
tell my user if the current record they are looking at
has been updated by someone else. Obviously I am only
'listening' when a user is looking at a particular
job.
I am concerned about usage of the listen and unlisten.
How does the backend know if my app didn't quit
unexpectidly? I mean I don't think my app has ever
crashed :)... and I do make sure if the user quits
that I close the connection. But I have a few users
that are using laptops on a wireless network. We are
in a building in manhattan and not infrequently the
wireless connection is lost.
After all this conversation.. I guess my question is..
am I leaking 'listens' if I don't close them properly?
I only created a few users and most of the connections
are from one of the user accounts. I do not have
separate user accounts.
Is this a problem waiting to bite me later?
Ted
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: notify and leaks?
2004-04-07 16:30 notify and leaks? Theodore Petrosky <tedpet5@yahoo.com>
@ 2004-04-07 18:27 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-04-07 18:27 UTC (permalink / raw)
To: Theodore Petrosky <tedpet5@yahoo.com>; +Cc: pgsql-sql
Theodore Petrosky <tedpet5@yahoo.com> writes:
> After all this conversation.. I guess my question is..
> am I leaking 'listens' if I don't close them properly?
No. It may take awhile for the backend to realize the connection is
dead (this is driven by RFC-specified TCP timeouts). Once it does,
though, it will clean up before exiting.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-07 18:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-07 16:30 notify and leaks? Theodore Petrosky <tedpet5@yahoo.com>
2004-04-07 18:27 ` Tom Lane <tgl@sss.pgh.pa.us>
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