Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> But when I switch to
> select into _BasketID1,_BasketID2 _BasketID1,_BasketID2 from testA();
> nothing get back from testB().
I think you've forgotten that plpgsql variables will be substituted
for, wherever they appear. The above is just an ext
On Jan 5, 2008 1:15 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Sat, 5 Jan 2008, Clodoaldo wrote:
>
> > I created a patch to change
> > XLOG_SEG_SIZE and built with it:
> > -#define XLOG_SEG_SIZE (16*1024*1024)
> > +#define XLOG_SEG_SIZE (1024*1024*1024)
>
> People sometimes get a small improv
On Sat, 5 Jan 2008, Clodoaldo wrote:
I created a patch to change
XLOG_SEG_SIZE and built with it:
-#define XLOG_SEG_SIZE (16*1024*1024)
+#define XLOG_SEG_SIZE (1024*1024*1024)
People sometimes get a small improvement setting this to 2-4 times larger
than the default when running a large ser
Clodoaldo <[EMAIL PROTECTED]> writes:
>> How did you get 8.3-beta4?
> I built from the source rpm, which i installed in my machine. There is
> something I forgot to mention. I created a patch to change
> XLOG_SEG_SIZE and built with it:
> -#define XLOG_SEG_SIZE (16*1024*1024)
> +#define XLOG_SEG_
Good day every one .
Im trying to make and insert returning with the connector Npgsql, where
can i read more about the syntax of the insert string? or how to
configure the Npgsql.command class.
Regards Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Cesar Alvarez
title:Web Development Asesor a
2008/1/5, Greg Smith <[EMAIL PROTECTED]>:
> On Fri, 4 Jan 2008, Clodoaldo wrote:
>
> > I built a new system and installed 8.3-beta4.
>
> How did you get 8.3-beta4?
I built from the source rpm, which i installed in my machine. There is
something I forgot to mention. I created a patch to change
XLOG
2008/1/4, Tom Lane <[EMAIL PROTECTED]>:
> Clodoaldo <[EMAIL PROTECTED]> writes:
> > The same insert query takes 20 minutes in the production system and 2
> > hours in the new one.
>
> Hmph. It's the same plan, so it's not a planner mistake. Could you
> post EXPLAIN ANALYZE rather than just EXPLAI
"Ed L." <[EMAIL PROTECTED]> wrote:
>
> On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
> > On Jan 4, 2008 6:38 PM, Ed L. <[EMAIL PROTECTED]> wrote:
> > > We need some advice on how to handle some large table
> > > autovacuum issues. One of our 8.1.2
> >
> > First of all, update your 8.1 in
