Hi Serge,
here are the some examples I posted in PERFORM list:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-planner-tp5749427.html
No - I do not compare Pg to anything - I am developer - before, I used SQL
Server - but two years ago I moved to Postgres - and I have no idea what
SQL Server
Hi,
I really don't know how to ask for what I'm looking for; but I think,
may be, calling it an ARRAY yielding aggregate function for use within a
query WINDOW would do?
I'm looking for something like:
SELECT DISTINCT issuer,amount, array(REFERENCE) over (partition by
invoice_nr) from invoi
maybe,
SELECT DISTINCT issuer,amount, array_agg(REFERENCE) over (partition by
invoice_nr) from invoices;
2013/3/24 Rafał Pietrak
> Hi,
>
> I really don't know how to ask for what I'm looking for; but I think, may
> be, calling it an ARRAY yielding aggregate function for use within a query
> WI
W dniu 03/24/2013 12:06 PM, Misa Simic pisze:
maybe,
SELECT DISTINCT issuer,amount, array_agg(REFERENCE) over (partition by
invoice_nr) from invoices;
RIGHT. Thenx. (and the first thing I did, I've read the doc on
array_agg() what stress makes from people :(
thenx again,
-R
2013
On a hourly basis 13 tables with number of columns between 50 to 70 columns
are updated with 170 rows.
The tables have a text and timestamps column with other columns being
real.
Kenroy
On Sat, Mar 23, 2013 at 8:40 PM, John R Pierce wrote:
> On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
>
>> I
Hi, Kenroy. Can you make a test suite so that you could run a performance
test on each platform? I see you will have different hardware and
operating systems.
Best,
Aleksey
On Sun, Mar 24, 2013 at 11:40 AM, Kenroy Bennett wrote:
>
>
> On a hourly basis 13 tables with number of columns between
Thanks for your assistance Tom.
On 19/03/2013, at 12:40 PM, Tom Lane wrote:
> I think you missed my point: you should not be insisting on a maximal
> set of required outer rels.
I’ve started generating multiple paths for the web services that support it,
which works great.
> In this particula
Adam Zegelin writes:
> On 19/03/2013, at 12:40 PM, Tom Lane wrote:
>> In this particular case, it won't generate a cross-product join of l1
>> and l2 because there's a heuristic that says that's unlikely to be a
>> good idea.
> Is this heuristic a tuneable parameter, or something that would requ
