Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Stephen Frost
Subject Re: Any better plan for this query?..
Date
Msg-id 20090513014115.GZ8123@tamriel.snowman.net
Whole thread Raw
In response to Re: Any better plan for this query?..  (Aidan Van Dyk <aidan@highrise.ca>)
List pgsql-performance
* Aidan Van Dyk (aidan@highrise.ca) wrote:
> But, what really does preforking give us?  A 2 or 3% improvement?  The
> forking isn't the expensive part, the per-database setup that happens is
> the expensive setup...

Obviously that begs the question- why not support pre-fork with specific
databases associated with specific backends that do the per-database
setup prior to a connection coming in?  eg- I want 5 backends ready per
user database (excludes template0, template1, postgres).

Thoughts?

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: AMD Shanghai versus Intel Nehalem
Next
From: Scott Marlowe
Date:
Subject: Re: AMD Shanghai versus Intel Nehalem