Thread
-
Re: University Masters Project
Bruce Momjian <maillist@candle.pha.pa.us> — 1999-09-03T02:31:10Z
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Bruce, > > The replacement of the existing client/server communication project with > CORBA looks very interesting, I would love to get involved with something > like that. Is there anyone working on it at the moment? What area of it > would you like me to look into, any ideas of how I could turn a project like > that into a good Thesis? If you can give me some pointers I'll go and speak > to my tutor about it all. [CC'ing to hackers for comments.] Well, one idea is to create a server that listens on a certain port for CORBA requests, sends them to a backend for processing, and returns the result. The other idea is to replace our current communication system that uses single-character flags and data with a corba model. See developers documentation for deals on that. I think the first on is clearly good, the second may suffer from performance problems, or it may not be worth changing all our interfaces to handle a new protocol. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
-
Re: [HACKERS] Re: University Masters Project
Marc G. Fournier <scrappy@hub.org> — 1999-09-03T11:19:07Z
On Thu, 2 Sep 1999, Bruce Momjian wrote: > [Charset iso-8859-1 unsupported, filtering to ASCII...] > > Bruce, > > > > The replacement of the existing client/server communication project with > > CORBA looks very interesting, I would love to get involved with something > > like that. Is there anyone working on it at the moment? What area of it > > would you like me to look into, any ideas of how I could turn a project like > > that into a good Thesis? If you can give me some pointers I'll go and speak > > to my tutor about it all. > > > [CC'ing to hackers for comments.] > > Well, one idea is to create a server that listens on a certain port for > CORBA requests, sends them to a backend for processing, and returns the > result. > > The other idea is to replace our current communication system that uses > single-character flags and data with a corba model. See developers > documentation for deals on that. > > I think the first on is clearly good, the second may suffer from > performance problems, or it may not be worth changing all our interfaces > to handle a new protocol. I'm curious as to whether there is a way of testing that without too much trouble? Even the investigation of *that* might make for the thesis in itself? Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -
Postgres Performance
Edwin Ramirez <ramirez@doc.mssm.edu> — 1999-09-03T15:42:22Z
Hello, I am using Postgres extensively for a number of projects. I am extremely happy with its performance and flexibility. I am trying to optimize the system, currently I run the postmaster with the following setting: postmaster -i -B 2048 -o '-S 2048' I have a couple of large(?) tables which I would like to keep them in memory (cached) so that searches are performed as fast as possible. Is it possible to 'pin' the tables and it's indexes in memory? Are there any other options/values which would yield better performance? Thanks, -Edwin S. Ramirez-
-
Re: [HACKERS] Postgres Performance
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1999-09-03T16:08:49Z
> I have a couple of large(?) tables which I would like to keep them in > memory (cached) so that searches are performed as fast as possible. > Is it possible to 'pin' the tables and it's indexes in memory? Not explicitly. We rely on the OS to do that. > Are there any other options/values which would yield better performance? By default, the backend "fsyncs" for every query. You can disable this, which would then allow the tables to hang around in memory until the OS decides to flush to disk. Not everyone should do this, since there is a (small) risk that if your computer crashes after some updates but before things are flushed then the db might become inconsistant. afaik we have never had an unambiguous report that this has actually happened (but others might remember differently). There is already that risk to some extent, but instead of the window being O(1sec) it becomes O(30sec). Run the backend by adding '-o -F' (or just '-F' to your existing list of "-o" options). - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California -
RE: [HACKERS] Re: University Masters Project
Mark Proctor <mark@polar-digital.com> — 1999-09-03T17:26:21Z
Dear All, Yes I agree with you that something like that might make a thesis in itself, and definitely sounds interesting. I really need to sit down and go through PostgreSQL so that I understand how it all works, so that I can ask questions without wasting everyone's time, as I'm sure a lot of the questions I currently have will be in the documentation. I start Uni in 4 weeks time, which by then I hope to have the basics to PostgreSQL and its architecture, that along with guidance from my tutor should then give me a good base to start the project on. I'll keep you all informed of my progress with this over the next few weeks, and my University's response to my request to work on a project of this nature. Who should I direct my correspondance to, as I don't want to start filling up people's email box's with unessecary email. Regards Mark Proctor Brunel University Email : M.Proctor@bigfoot.com ICQ : 8106598 -----Original Message----- From: The Hermit Hacker [mailto:scrappy@hub.org] Sent: Friday, September 03, 1999 12:19 PM To: Bruce Momjian Cc: mark@polar-digital.com; PostgreSQL-development Subject: Re: [HACKERS] Re: University Masters Project On Thu, 2 Sep 1999, Bruce Momjian wrote: > [Charset iso-8859-1 unsupported, filtering to ASCII...] > > Bruce, > > > > The replacement of the existing client/server communication project with > > CORBA looks very interesting, I would love to get involved with something > > like that. Is there anyone working on it at the moment? What area of it > > would you like me to look into, any ideas of how I could turn a project like > > that into a good Thesis? If you can give me some pointers I'll go and speak > > to my tutor about it all. > > > [CC'ing to hackers for comments.] > > Well, one idea is to create a server that listens on a certain port for > CORBA requests, sends them to a backend for processing, and returns the > result. > > The other idea is to replace our current communication system that uses > single-character flags and data with a corba model. See developers > documentation for deals on that. > > I think the first on is clearly good, the second may suffer from > performance problems, or it may not be worth changing all our interfaces > to handle a new protocol. I'm curious as to whether there is a way of testing that without too much trouble? Even the investigation of *that* might make for the thesis in itself? Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -
Re: [HACKERS] Re: University Masters Project
Bruce Momjian <maillist@candle.pha.pa.us> — 1999-09-03T17:44:05Z
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Dear All, > > Yes I agree with you that something like that might make a thesis in itself, > and definitely sounds interesting. > > I really need to sit down and go through PostgreSQL so that I understand how > it all works, so that I can ask questions without wasting everyone's time, > as I'm sure a lot of the questions I currently have will be in the > documentation. I start Uni in 4 weeks time, which by then I hope to have the > basics to PostgreSQL and its architecture, that along with guidance from my > tutor should then give me a good base to start the project on. > > I'll keep you all informed of my progress with this over the next few weeks, > and my University's response to my request to work on a project of this > nature. > > Who should I direct my correspondance to, as I don't want to start filling > up people's email box's with unessecary email. Hackers list is fine. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026