jobs.product_id =
products.product_id;
in order to speed the union processing?
Thank you for any help on this.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
.
Regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
s are exactly the same, should I assume
that the cost will also be the same?
Thanks for any help.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
for any good pointers on this 'already seen' issue.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ld be nice to see that. It
would be easier for the DB admin and the coder; the moment this is not
slowing the system. : )
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On 24 Nov 2004 01:52:52 -0500, Greg Stark <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc <[EMAIL PROTECTED]> writes:
>
> > Thanks for those tips. I'll print and keep them. So in my case, the
> > product_code being varchar(24) is:
> > 4 bytes + string
roduct. So someone can know how much work time there is to do by
departments.
Thanks for any input, comments, tips, help, positive criticism to
learn more, etc.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Thu, 27 Jan 2005 17:27:40 +0100, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 10:23:34 -0500, Alexandre Leclerc
> <[EMAIL PROTECTED]> wrote:
> > Here a normal listing of design.product_department_time:
> > product
jobs. :) This
is a nice report, but I don't want to kill the database each time the
user want to see it.
Thanks for your contrib so far, this will help me looking for other
ways doing it. I'm always ready to hear more!
Regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
no more than 1 dimension and
> b: array bounds are known
>
> Let me know if you need it and I'll send it over.
Thank you for your offer. I think parsing an array is the easiest
thing to do for me in all this. :) If I encounter any problem, I'll
drop you a mail.
Regards.
--
ze anything, ever (and most of the time,
> you shouldn't!).
Thank you for all you help and time for this.
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Fri, 28 Jan 2005 09:07:59 +0100, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 12:43:56 -0500, Alexandre Leclerc
> <[EMAIL PROTECTED]> wrote:
> > On Thu, 27 Jan 2005 17:27:40 +0100, Dawid Kuroczko <[EMAIL PROTECTED]>
> > wrote:
>
On Fri, 28 Jan 2005 08:34:27 -0800, Joe Conway <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc wrote:
> >>>>>Here a normal listing of design.product_department_time:
> >>>>> product_id | department_id | req_time
> >>>>>
On Fri, 28 Jan 2005 10:24:37 -0800, Joe Conway <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc wrote:
> > I'm a little bit confused on how to install this contirb. I know my
> > contrib package is installed, but I don't know how to make it work in
> > postgresql
On Fri, 4 Feb 2005 12:48:43 -0500, Merlin Moncure
<[EMAIL PROTECTED]> wrote:
> > Alexandre Leclerc wrote:
> > Sorry for jumping in on this thread so late -- I haven't been able to
> > select * from crosstab(
> >'select product_id, department_id, req_t
16 matches
Mail list logo
