Daniel Griscom wrote:
Thanks again for all the feedback. Running on a dual processor/core
machine is clearly a first step, and I'll look into the other
suggestions as well.
As per one of the last suggestions, do consider as well putting a dual
hard disk
(as in, independent hard disks, to allo
Thanks again for all the feedback. Running on a dual processor/core
machine is clearly a first step, and I'll look into the other
suggestions as well.
Thanks,
Dan
--
Daniel T. Griscom [EMAIL PROTECTED]
Suitable Systems http://www.suitable.com/
1 Centre Street, Suite 2
> Thanks for all the feedback. Unfortunately I didn't specify that this
> is running on a WinXP machine (the 3D renderer is an ActiveX plugin),
> and I don't even think "nice" is available. I've tried using the
> Windows Task Manager to set every postgres.exe process to a low
> priority, but th
You can use the workload management feature that we've contributed to
Bizgres. That allows you to control the level of statement concurrency by
establishing queues and associating them with roles.
That would provide the control you are seeking.
- Luke
On 5/8/07 4:24 PM, "[EMAIL PROTECTED]" <[E
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 s
On Tue, 8 May 2007, Daniel Griscom wrote:
Thanks for all the feedback. Unfortunately I didn't specify that this is
running on a WinXP machine (the 3D renderer is an ActiveX plugin), and I
don't even think "nice" is available. I've tried using the Windows Task
Manager to set every postgres.exe
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 ru
On Tue, May 08, 2007 at 07:03:17PM -0400, Daniel Griscom wrote:
> I'm only running one query at a time; would that query be guaranteed to
> confine itself to a single processor/core?
Yes; at least it won't be using two at a time. (Postgres can't guarantee that
Windows won't move it to another core
Thanks for all the feedback. Unfortunately I didn't specify that this
is running on a WinXP machine (the 3D renderer is an ActiveX plugin),
and I don't even think "nice" is available. I've tried using the
Windows Task Manager to set every postgres.exe process to a low
priority, but that didn't
Joshua D. Drake wrote:
Am I missing something?? There is just *one* instance of this idea
in, what,
four replies?? I find it so obvious, and so obviously the only
solution that
has any hope to work, that it makes me think I'm missing something ...
Is it that multiple PostgreSQL processes wil
On Tue, May 08, 2007 at 06:32:14PM -0400, Carlos Moreno wrote:
>> Or use a dual-core system. :-)
> Am I missing something?? There is just *one* instance of this idea in,
> what, four replies?? I find it so obvious, and so obviously the only
> solution that has any hope to work, that it makes me t
Carlos Moreno wrote:
Steinar H. Gunderson wrote:
Or use a dual-core system. :-)
Am I missing something?? There is just *one* instance of this idea in,
what,
four replies?? I find it so obvious, and so obviously the only solution
that
has any hope to work, that it makes me think I'm missin
Steinar H. Gunderson wrote:
Or use a dual-core system. :-)
Am I missing something?? There is just *one* instance of this idea in,
what,
four replies?? I find it so obvious, and so obviously the only solution
that
has any hope to work, that it makes me think I'm missing something ...
Is it
1. If you go the route of using nice, you might want to run the 3D
front-end at a higher priority instead of running PG at a lower
priority. That way apache, php and the other parts all run at the same
priority as PG and just the one task that you want to run smoothly is
elevated.
2. You may not
On Tue, 8 May 2007, Daniel Griscom wrote:
I'm building a kiosk with a 3D front end accessing PostGIS/PostgreSQL via
Apache/PHP. The 3D display is supposed to show smooth motion from location to
location, with PostGIS giving dynamically updated information on the
locations. Everything runs on t
In response to Daniel Griscom <[EMAIL PROTECTED]>:
> I'm building a kiosk with a 3D front end accessing PostGIS/PostgreSQL
> via Apache/PHP. The 3D display is supposed to show smooth motion from
> location to location, with PostGIS giving dynamically updated
> information on the locations. Ever
On Tue, May 08, 2007 at 04:27:10PM -0400, Daniel Griscom wrote:
> 3: ... some other solution I haven't thought of.
On a wild guess, could you try setting the CPU costs higher, to make the
planner choose a less CPU-intensive plan?
Other (weird) suggestions would include calling a user-defined func
17 matches
Mail list logo
