On Mon, 5 Jun 2023 at 07:56, gzh wrote:
> Hi everyone,
> I'm running into some performance issues with my SQL query.
> The following SQL query is taking a long time to execute.
>
> Execution Plan：
> explain analyse
> select * from TBL_RES
> left outer join(select T_CUST.RSNO RSNO2 ,
> T_CUST.KNO
Hi,
Just wondering, does anyone else create apps which might not have 'big'
data, but quite complex arrangements of views joining to each other?
If so, do you have scripts to aid refactoring them e.g. drop/recreate/test
them in the right order etc.?
I'm really impressed with the way Postgres han
On Wed, 25 Aug 2021 at 15:16, jagadeeshwaraiah, Govindu <
govindu.jagadeeshwara...@dsm.com> wrote:
> Hello Team,
>
> Good day!!!
>
>
>
> We are using source as PostgreSQL with Power BI reports. We have
> established connection and created test dashboard in the PowerBI report.
> But we have install
On Mon, 23 Aug 2021 at 11:20, Marc wrote:
> On 23 Aug 2021, at 11:55, Oliver Kohll wrote:
>
> > Hi,
> >
> > Just wondering if anyone knows which release (if any) this is targeted
> for?
> >
> > https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
&
Hi,
Just wondering if anyone knows which release (if any) this is targeted for?
https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
Asking because this could make a massive difference to some of our
workload, even when limited to relatively simple queries. It's quite
exciting.
Regards
On Mon, 21 Jun 2021 at 15:09, Francisco Olarte
wrote:
> Oliver:
>
> On Mon, Jun 21, 2021 at 3:27 PM Oliver Kohll
> wrote:
> ...
> > My attempt to do that is the regex
> > select regexp_replace(
> > 'here is [[my text]] to replace and [[some more]]',
Hi,
I have some text
'here is [[my text]] to replace and [[some more]]'
which I want to transform to
'here is my_text to replace and some_more'
i.e. wherever there are double square brackets, remove them and replace
spaces in the contents with underscores.
My attempt to do that is the regex
DB, cruncy etc .
>
> this channel on youtube is pretty neat too. Scaling Postgres - YouTube
> <https://www.youtube.com/channel/UCnfO7IhkmJu_azn0WbIcV9A>
>
> I am not sure my reply is making it helpful or making it too loud for
> simple setups.
> anyways :)
>
>
> O
Hi,
We currently have an app with the database on the same server as the app
itself. I'd like to transition to a system where
1) in the short term, the db replicates to a different server. This will
allow us to take the daily pg_dump backups from the replica rather than the
primary server. They'r
Of course! Doh.
On 2 August 2018 at 14:27:02, David Rowley (david.row...@2ndquadrant.com)
wrote:
postgres=# select proretset from pg_proc where proname = 'regexp_matches';
proretset
---
t
t
(2 rows)
row on
the left side.
In any case, after deleting some obsolete rows, the plan seems to have
changed as the query now executes in a fraction of a second as opposed to
25 seconds.
Oliver
On 2 August 2018 at 13:21:32, David Rowley (david.row...@2ndquadrant.com)
wrote:
On 2 August 2018 at 21:17, Ol
Hi,
I've just been running explain analyze on a slow query and came across
something new to me - a node type of ProjectSet in the plan. What is that?
The plan is here: https://explain.depesz.com/s/4rqA
The query does a cross join of two tables to get every row in one combined
with every row in t
12 matches
Mail list logo
