Re: [HACKERS] A post-7.1 wish-list.

2001-01-10 Thread Tom Samplonius
On Mon, 8 Jan 2001, Manuel Cabido wrote: > I would like to inquire if in the next release of postgresql the database > will have to be compacted into a single file like what Interbase > database supports? I find this feature convenient because it will simplify > the updating of your database con

Re: [HACKERS] replacing shmem

2001-01-05 Thread Tom Samplonius
On Sat, 6 Jan 2001, Valter Mazzola wrote: > Excuse my ignorance. > Is there a way to replace the shmem and sem (ipc.c) to use files. In this > way we can have a sort of a parallel server using GFS. ... Besides the slowness of file IO, it also doesn't make sense to have a shared memory area f

[HACKERS] Re: [INTERFACES] Re: PHP and PostgreSQL

2001-01-02 Thread Tom Samplonius
On Tue, 2 Jan 2001, mlw wrote: > Bruce Momjian wrote: > > > > Does this requested chagne have to do with Apache or PostgreSQL? > > > I suspect it is a request that live postgresql processes can linger > around after a connection is completed and be re-assigned to a new > connection as soon as

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Tom Samplonius
On Thu, 7 Dec 2000, Alfred Perlstein wrote: > We recently had a very satisfactory contract completed by > Vadim. > > Basically Vadim has been able to reduce the amount of time > taken by a vacuum from 10-15 minutes down to under 10 seconds. ... What size database was that on? I looking at

Re: [HACKERS] Using Threads?

2000-12-04 Thread Tom Samplonius
On Mon, 4 Dec 2000, Junfeng Zhang wrote: > All the major operating systems should have POSIX threads implemented. > Actually this can be configurable--multithreads or one thread. I don't understand this. The OS can be configured for one thread? How would that be any of use? > Thread-only s

Re: [HACKERS] beta testing version

2000-12-02 Thread Tom Samplonius
On Sat, 2 Dec 2000, Don Baccus wrote: ... > Will Great Bridge step to the plate and fund a truly open source alternative, > leaving us with a potential code fork? If IB gets its political problems > under control and developers rally around it, two years is going to be a > long time to just sit

Re: [HACKERS] 8192 BLCKSZ ?

2000-11-27 Thread Tom Samplonius
On Mon, 27 Nov 2000, mlw wrote: > This is just a curiosity. > > Why is the default postgres block size 8192? These days, with caching > file systems, high speed DMA disks, hundreds of megabytes of RAM, maybe > even gigabytes. Surely, 8K is inefficient. I think it is a pretty wild assumption

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-26 Thread Tom Samplonius
On Sun, 26 Nov 2000, Alain Toussaint wrote: > > "I have all sorts of client apps, connecting in different ways, to > > my server. Some of the clients are leaving their connections open, > > but unused. How can I prevent running out of backends, and boot > > the inactive users off?" > > how abou

Re: [HACKERS] RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)

2000-11-16 Thread Tom Samplonius
On Thu, 16 Nov 2000, Alfred Perlstein wrote: > * Larry Rosenman <[EMAIL PROTECTED]> [001116 12:09] wrote: > > * Bruce Momjian <[EMAIL PROTECTED]> [001116 14:02]: > > > > > This sounds like an interesting approach, yes. > > > > Question: Is sleep(0) guaranteed to at least give up control? > > >

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

2000-11-15 Thread Tom Samplonius
On Wed, 15 Nov 2000, carl garland wrote: > >perhaps why, even at 5 clients, the page views he shows never went > >significantly above 10/sec? > > I think alot of it has to do with the web server/db setup not pg. They are > using Apache/PHP and looking at their code every page has the additio