Stado - General question about parallel queries
Hi, I'm about to try stado to do some tests with parallel queries involving a big table that I hold in a single PostgreSQL Standard Plus server (v9.1.3), the problem is that many clients had built many queries using this table, the question is: Can I use stado to increase performance and avoid the users lose their queries? (some queries are very complex). If not, which will be the best alternative to increase the performance without impact to the clients?
Thanks in advance.
César.
Example of a complex query, How stado will resolve a query like that if the table is partitioned in many nodes?:
select distinct
case when ticketnbr ~ '^[0-9]{13}-[0-9]+' then
left(ticketnbr, 13-length(
|| lpad((substring
+generate_
length(
else
case when ticketnbr ~ '^[0-9]
substring(
|| lpad((substring
+generate_
length(
else
left(ticketnbr, 13)
end
end as tkts_nmr_ticket,
first_
rsda.pnrlocatorid as rvas_cdg_pnr,
rsda.pnrcreatedate as rvas_fch_reserva,
rsda.loaddt as tkts_fch_inicio
from res.ressuspense
inner join aux.prioridad_
on ptt.cdg_
left join aux.gpnr_
on gre.loaddt=
where
(
(rsda.loaddt in ('2011-11-03', '2011-11-04') and rsda.pnrcreatedate between '2011-11-02' and '2011-11-03')
or
(rsda.loaddt in ('2011-11-05') and rsda.pnrcreated
)
and intrapnrsetnbr=0 and ticketnbr is not null
and resarractioncode in ('TA', 'TE', 'TK', 'TM', 'TR', 'TV') and gre.loaddt is null
and rsda.loaddt=
Question information
- Language:
- English Edit question
- Status:
- Solved
- For:
- Stado Edit question
- Assignee:
- No assignee Edit question
- Solved by:
- Jim Mlodgenski
- Solved:
- Last query:
- Last reply: