The discussion seems to have diverged a little, so I don't feel too bad
about making some semi-off-topic comments.
From: "Greg Stark" <[EMAIL PROTECTED]>
> Like I said though, we found "global indexes" defeated the whole purpose.
First semi-off-topic comment: I think this depends on the index, th
On Wed, Dec 15, 2004 at 11:56:40AM -0800, Josh Berkus wrote:
> Greg,
>
> > Well Oracle has lots of partitioning intelligence pushed up to the planner
> > to avoid overhead.
> >
> > If you have a query with something like "WHERE date = '2004-01-01'" and
> > date is your partition key (even if it's
Sorry for the late reply, so I included the whole thread. Should this be
a TODO?
On Wed, Dec 15, 2004 at 08:30:08PM -0500, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > But I'm a bit puzzled. Why would Append have any significant cost? It's just
> > taking the tuples from one plan n
> > A demo I've set up for sales seems to be spending much of it's time in
> > disk wait states.
> >
> >
> > The particular system I'm working with is:
> > Ext3 on Debian inside Microsoft VirtualPC on NTFS
> > on WindowsXP on laptops of our sales team.
>
> As this is only for demo purposes
On Fri, 2004-12-17 at 23:51 -0800, Ron Mayer wrote:
> Any advice for settings for extremely IO constrained systems?
>
> A demo I've set up for sales seems to be spending much of it's time in
> disk wait states.
>
>
> The particular system I'm working with is:
> Ext3 on Debian inside Microso
On Fri, Dec 17, 2004 at 11:51:12PM -0800, Ron Mayer wrote:
> Any advice for settings for extremely IO constrained systems?
>
> A demo I've set up for sales seems to be spending much of it's time in
> disk wait states.
>
>
> The particular system I'm working with is:
>Ext3 on Debian inside M
Gurpreet Sachdeva wrote:
I have recently transfered a big database on my master node of a 4
node openSSI Cluster... The system is working fine but sometimes, I
get following errors:
http://192.168.1.100/cgi-bin/search.py File
"/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line 3067, in
execut
