pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
realtime data inserts
13+ messages / 9 participants
[nested] [flat]

* realtime data inserts
@ 2003-05-10 15:25 Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 16:02 ` Re: realtime data inserts Ericson Smith <eric@did-it.com>
  2003-05-10 17:08 ` Re: realtime data inserts Jim C. Nasby <jim@nasby.net>
  2003-05-12 15:56 ` Re: realtime data inserts Steve Crawford <scrawford@pinpointresearch.com>
  0 siblings, 4 replies; 13+ messages in thread

From: Adam Siegel @ 2003-05-10 15:25 UTC (permalink / raw)
  To: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org

I have realtime data flowing at a rate of 500, 512 byte packets per second.
I want to log the info in a database table with two other columns, one for a
timestamp and one for a name of the packet.  The max rate I can achieve is
350 inserts per second on a sun blade 2000.  The inserts are grouped in a
transaction and I commit every 1200 records.  I am storing the binary data
in a bytea.  I am using the libpq conversion function.  Not sure if that is
slowing me down.  But I think it is the insert not the conversion.

Any thoughts on how to achive this goal?




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
@ 2003-05-10 16:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  3 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2003-05-10 16:00 UTC (permalink / raw)
  To: Adam Siegel <adam@sycamorehq.com>; +Cc: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org

"Adam Siegel" <adam@sycamorehq.com> writes:
> I have realtime data flowing at a rate of 500, 512 byte packets per second.
> I want to log the info in a database table with two other columns, one for a
> timestamp and one for a name of the packet.  The max rate I can achieve is
> 350 inserts per second on a sun blade 2000.  The inserts are grouped in a
> transaction and I commit every 1200 records.

Have you thought about using COPY?

			regards, tom lane




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-05-10 18:31   ` Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 13+ messages in thread

From: Ron Johnson @ 2003-05-10 18:31 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
> "Adam Siegel" <adam@sycamorehq.com> writes:
> > I have realtime data flowing at a rate of 500, 512 byte packets per second.
> > I want to log the info in a database table with two other columns, one for a
> > timestamp and one for a name of the packet.  The max rate I can achieve is
> > 350 inserts per second on a sun blade 2000.  The inserts are grouped in a
> > transaction and I commit every 1200 records.
> 
> Have you thought about using COPY?

Generate a temporary file, and then system("COPY /tmp/foobar ...") ?

-- 
+---------------------------------------------------------------+
| Ron Johnson, Jr.        mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA      http://members.cox.net/ron.l.johnson  |
|                                                               |
| The purpose of the military isn't to pay your college tuition |
| or give you a little extra income; it's to "kill people and   |
| break things".  Surprisingly, not everyone understands that.  |
+---------------------------------------------------------------+




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
@ 2003-05-11 02:46     ` Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-11 16:54       ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2003-05-11 02:46 UTC (permalink / raw)
  To: Ron Johnson <ron.l.johnson@cox.net>; +Cc: pgsql-general@postgresql.org

Ron Johnson <ron.l.johnson@cox.net> writes:
> On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
>> Have you thought about using COPY?

> Generate a temporary file, and then system("COPY /tmp/foobar ...") ?

No, copy from stdin.  No need for a temp file.

			regards, tom lane




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-05-11 16:54       ` Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 16:58         ` Re: realtime data inserts Doug McNaught <doug@mcnaught.org>
  0 siblings, 1 reply; 13+ messages in thread

From: Ron Johnson @ 2003-05-11 16:54 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
> > On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
> >> Have you thought about using COPY?
> 
> > Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
> 
> No, copy from stdin.  No need for a temp file.

But wouldn't that only work if the input stream is acceptable to
COPY ?

-- 
+---------------------------------------------------------------+
| Ron Johnson, Jr.        mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA      http://members.cox.net/ron.l.johnson  |
|                                                               |
| The purpose of the military isn't to pay your college tuition |
| or give you a little extra income; it's to "kill people and   |
| break things".  Surprisingly, not everyone understands that.  |
+---------------------------------------------------------------+




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-11 16:54       ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
@ 2003-05-11 16:58         ` Doug McNaught <doug@mcnaught.org>
  2003-05-16 20:27           ` Re: realtime data inserts alex b. <mailinglists1@gmx.de>
  0 siblings, 1 reply; 13+ messages in thread

From: Doug McNaught @ 2003-05-11 16:58 UTC (permalink / raw)
  To: Ron Johnson <ron.l.johnson@cox.net>; +Cc: pgsql-general@postgresql.org

Ron Johnson <ron.l.johnson@cox.net> writes:

> On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> > Ron Johnson <ron.l.johnson@cox.net> writes:
> > > On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
> > >> Have you thought about using COPY?
> > 
> > > Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
> > 
> > No, copy from stdin.  No need for a temp file.
> 
> But wouldn't that only work if the input stream is acceptable to
> COPY ?

Yes, but you could always pipe it through a script or C program to
make it so...

-Doug




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-11 16:54       ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 16:58         ` Re: realtime data inserts Doug McNaught <doug@mcnaught.org>
@ 2003-05-16 20:27           ` alex b. <mailinglists1@gmx.de>
  2003-05-16 20:33             ` Re: realtime data inserts Ericson Smith <eric@did-it.com>
  0 siblings, 1 reply; 13+ messages in thread

From: alex b. @ 2003-05-16 20:27 UTC (permalink / raw)
  To: Postgresql General <pgsql-general@postgresql.org>

Doug McNaught wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
> 
> 
>>On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
>>
>>>Ron Johnson <ron.l.johnson@cox.net> writes:
>>>
>>>>On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
>>>>
>>>>>Have you thought about using COPY?
>>>
>>>>Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
>>>
>>>No, copy from stdin.  No need for a temp file.
>>
>>But wouldn't that only work if the input stream is acceptable to
>>COPY ?
> 
> 
> Yes, but you could always pipe it through a script or C program to
> make it so...

lets say I have an about 1kb/s continuus datastream comming in for many 
hours and I'd like to store this data in my db using COPY table FROM stdin.

At what time should I COMMIT or close the stream to feed the database 
and COPY FROM again?






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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-11 16:54       ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 16:58         ` Re: realtime data inserts Doug McNaught <doug@mcnaught.org>
  2003-05-16 20:27           ` Re: realtime data inserts alex b. <mailinglists1@gmx.de>
@ 2003-05-16 20:33             ` Ericson Smith <eric@did-it.com>
  2003-05-16 22:29               ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 1 reply; 13+ messages in thread

From: Ericson Smith @ 2003-05-16 20:33 UTC (permalink / raw)
  To: alex b. <mailinglists1@gmx.de>; +Cc: Postgresql General <pgsql-general@postgresql.org>

You probably want to have a process that constantly stores the data in a
text file. Every "n" minutes, you will cause the logger to rotate the
text file, then process that batch. 

Over here, we are able to dump around 5,000 records per second in one of
our tables using that methodology.

- Ericson Smith
eric@did-it.com

On Fri, 2003-05-16 at 16:27, alex b. wrote:
> Doug McNaught wrote:
> > Ron Johnson <ron.l.johnson@cox.net> writes:
> > 
> > 
> >>On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> >>
> >>>Ron Johnson <ron.l.johnson@cox.net> writes:
> >>>
> >>>>On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
> >>>>
> >>>>>Have you thought about using COPY?
> >>>
> >>>>Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
> >>>
> >>>No, copy from stdin.  No need for a temp file.
> >>
> >>But wouldn't that only work if the input stream is acceptable to
> >>COPY ?
> > 
> > 
> > Yes, but you could always pipe it through a script or C program to
> > make it so...
> 
> lets say I have an about 1kb/s continuus datastream comming in for many 
> hours and I'd like to store this data in my db using COPY table FROM stdin.
> 
> At what time should I COMMIT or close the stream to feed the database 
> and COPY FROM again?
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html
-- 
Ericson Smith <eric@did-it.com>




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 16:00 ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-10 18:31   ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 02:46     ` Re: realtime data inserts Tom Lane <tgl@sss.pgh.pa.us>
  2003-05-11 16:54       ` Re: realtime data inserts Ron Johnson <ron.l.johnson@cox.net>
  2003-05-11 16:58         ` Re: realtime data inserts Doug McNaught <doug@mcnaught.org>
  2003-05-16 20:27           ` Re: realtime data inserts alex b. <mailinglists1@gmx.de>
  2003-05-16 20:33             ` Re: realtime data inserts Ericson Smith <eric@did-it.com>
@ 2003-05-16 22:29               ` Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 0 replies; 13+ messages in thread

From: Ron Johnson @ 2003-05-16 22:29 UTC (permalink / raw)
  To: Postgresql General <pgsql-general@postgresql.org>

On Fri, 2003-05-16 at 15:33, Ericson Smith wrote:
> You probably want to have a process that constantly stores the data in a
> text file. Every "n" minutes, you will cause the logger to rotate the
> text file, then process that batch. 

Does the logger spawn the DB writer?

> Over here, we are able to dump around 5,000 records per second in one of
> our tables using that methodology.
> 
> - Ericson Smith
> eric@did-it.com
> 
> On Fri, 2003-05-16 at 16:27, alex b. wrote:
> > Doug McNaught wrote:
> > > Ron Johnson <ron.l.johnson@cox.net> writes:
> > > 
> > > 
> > >>On Sat, 2003-05-10 at 21:46, Tom Lane wrote:
> > >>
> > >>>Ron Johnson <ron.l.johnson@cox.net> writes:
> > >>>
> > >>>>On Sat, 2003-05-10 at 11:00, Tom Lane wrote:
> > >>>>
> > >>>>>Have you thought about using COPY?
> > >>>
> > >>>>Generate a temporary file, and then system("COPY /tmp/foobar ...") ?
> > >>>
> > >>>No, copy from stdin.  No need for a temp file.
> > >>
> > >>But wouldn't that only work if the input stream is acceptable to
> > >>COPY ?
> > > 
> > > 
> > > Yes, but you could always pipe it through a script or C program to
> > > make it so...
> > 
> > lets say I have an about 1kb/s continuus datastream comming in for many 
> > hours and I'd like to store this data in my db using COPY table FROM stdin.
> > 
> > At what time should I COMMIT or close the stream to feed the database 
> > and COPY FROM again?
> > 
> > 
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> > http://www.postgresql.org/docs/faqs/FAQ.html
-- 
+---------------------------------------------------------------+
| Ron Johnson, Jr.        mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA      http://members.cox.net/ron.l.johnson  |
|                                                               |
| The purpose of the military isn't to pay your college tuition |
| or give you a little extra income; it's to "kill people and   |
| break things".  Surprisingly, not everyone understands that.  |
+---------------------------------------------------------------+




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
@ 2003-05-10 16:02 ` Ericson Smith <eric@did-it.com>
  3 siblings, 0 replies; 13+ messages in thread

From: Ericson Smith @ 2003-05-10 16:02 UTC (permalink / raw)
  To: Adam Siegel <adam@sycamorehq.com>; +Cc: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org

Had the same problem recently...

Format your data like a pg text dump into a file and then...

COPY <tablename> (a,b,c) FROM stdin;
1   2   3
4   5   6
\.

psql <yourdatabase < dumpfile.sql

I've achieved thousands of rows per seconds with this method.

- Ericson Smith
eric@did-it.com
http://www.did-it.com

Adam Siegel wrote:

>I have realtime data flowing at a rate of 500, 512 byte packets per second.
>I want to log the info in a database table with two other columns, one for a
>timestamp and one for a name of the packet.  The max rate I can achieve is
>350 inserts per second on a sun blade 2000.  The inserts are grouped in a
>transaction and I commit every 1200 records.  I am storing the binary data
>in a bytea.  I am using the libpq conversion function.  Not sure if that is
>slowing me down.  But I think it is the insert not the conversion.
>
>Any thoughts on how to achive this goal?
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>  
>




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
@ 2003-05-10 17:08 ` Jim C. Nasby <jim@nasby.net>
  2003-05-12 14:51   ` Re: realtime data inserts Adam Siegel <adam@sycamore.us>
  3 siblings, 1 reply; 13+ messages in thread

From: Jim C. Nasby @ 2003-05-10 17:08 UTC (permalink / raw)
  To: Adam Siegel <adam@sycamorehq.com>; +Cc: pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org

Are you binding your insert? IE:

prepare statement INSERT INTO blah VALUES (?, ?, ?);

execute statement (a, b, c)

Instead of just "INSERT INTO blah VALUES(a, b, c)"


On Sat, May 10, 2003 at 11:25:16AM -0400, Adam Siegel wrote:
> I have realtime data flowing at a rate of 500, 512 byte packets per second.
> I want to log the info in a database table with two other columns, one for a
> timestamp and one for a name of the packet.  The max rate I can achieve is
> 350 inserts per second on a sun blade 2000.  The inserts are grouped in a
> transaction and I commit every 1200 records.  I am storing the binary data
> in a bytea.  I am using the libpq conversion function.  Not sure if that is
> slowing me down.  But I think it is the insert not the conversion.
> 
> Any thoughts on how to achive this goal?
 

-- 
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
  2003-05-10 17:08 ` Re: realtime data inserts Jim C. Nasby <jim@nasby.net>
@ 2003-05-12 14:51   ` Adam Siegel <adam@sycamore.us>
  0 siblings, 0 replies; 13+ messages in thread

From: Adam Siegel @ 2003-05-12 14:51 UTC (permalink / raw)
  To: Jim C. Nasby <jim@nasby.net>; +Cc: pgsql-performance; pgsql-general@postgresql.org


The copy from method (PQputline) allows me to achieve around 1000 inserts 
per second. 


On Sat, 10 May 2003, Jim C. Nasby wrote:

> Are you binding your insert? IE:
> 
> prepare statement INSERT INTO blah VALUES (?, ?, ?);
> 
> execute statement (a, b, c)
> 
> Instead of just "INSERT INTO blah VALUES(a, b, c)"
> 
> 
> On Sat, May 10, 2003 at 11:25:16AM -0400, Adam Siegel wrote:
> > I have realtime data flowing at a rate of 500, 512 byte packets per second.
> > I want to log the info in a database table with two other columns, one for a
> > timestamp and one for a name of the packet.  The max rate I can achieve is
> > 350 inserts per second on a sun blade 2000.  The inserts are grouped in a
> > transaction and I commit every 1200 records.  I am storing the binary data
> > in a bytea.  I am using the libpq conversion function.  Not sure if that is
> > slowing me down.  But I think it is the insert not the conversion.
> > 
> > Any thoughts on how to achive this goal?
>  
> 
> 




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

* Re: realtime data inserts
  2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
@ 2003-05-12 15:56 ` Steve Crawford <scrawford@pinpointresearch.com>
  3 siblings, 0 replies; 13+ messages in thread

From: Steve Crawford @ 2003-05-12 15:56 UTC (permalink / raw)
  To: Adam Siegel <adam@sycamorehq.com>; pgsql-hackers@postgresql.org; pgsql-performance; pgsql-general@postgresql.org

Depends - we don't know enough about your needs. Some questions:

Is this constant data or just capturing a burst?

Are you feeding it through one connection or several in parallel?

Did you tune your memory configs in postgresql.conf or are they still at the 
minimalized defaults?

How soon does the data need to be available for query? (Obviously there will 
be up to a 1200 record delay just due to the transaction.)

What generates the timestamp? Ie. is it an insert into foo values (now(), 
packetname, data) or is the app providing the timestamp?

More info about the app will help.

Cheers,
Steve


On Saturday 10 May 2003 8:25 am, Adam Siegel wrote:
> I have realtime data flowing at a rate of 500, 512 byte packets per second.
> I want to log the info in a database table with two other columns, one for
> a timestamp and one for a name of the packet.  The max rate I can achieve
> is 350 inserts per second on a sun blade 2000.  The inserts are grouped in
> a transaction and I commit every 1200 records.  I am storing the binary
> data in a bytea.  I am using the libpq conversion function.  Not sure if
> that is slowing me down.  But I think it is the insert not the conversion.
>
> Any thoughts on how to achive this goal?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




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


end of thread, other threads:[~2003-05-16 22:29 UTC | newest]

Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-10 15:25 realtime data inserts Adam Siegel <adam@sycamorehq.com>
2003-05-10 16:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-10 18:31   ` Ron Johnson <ron.l.johnson@cox.net>
2003-05-11 02:46     ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-11 16:54       ` Ron Johnson <ron.l.johnson@cox.net>
2003-05-11 16:58         ` Doug McNaught <doug@mcnaught.org>
2003-05-16 20:27           ` alex b. <mailinglists1@gmx.de>
2003-05-16 20:33             ` Ericson Smith <eric@did-it.com>
2003-05-16 22:29               ` Ron Johnson <ron.l.johnson@cox.net>
2003-05-10 16:02 ` Ericson Smith <eric@did-it.com>
2003-05-10 17:08 ` Jim C. Nasby <jim@nasby.net>
2003-05-12 14:51   ` Adam Siegel <adam@sycamore.us>
2003-05-12 15:56 ` Steve Crawford <scrawford@pinpointresearch.com>

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