On Tue, 8 May 2007, Carlos Moreno wrote:

Daniel Griscom wrote:

 Several people have mentioned having multiple processors; my current
 machine is a uni-processor machine, but I believe we could spec the actual
runtime machine to have multiple processors/cores.

My estimate is that yes, you should definitely consider that.

 I'm only running one query at a time; would that query be guaranteed to
 confine itself to a single processor/core?

From what Joshua mentions, looks like you do have that guarantee.

isn't there a way to limit how many processes postgres will create?

if this is limited to 1, what happens when a vaccum run hits (or autovaccum)

David Lang


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to