> On 6 Jul 2021, at 18:14, Pavel Stehule wrote:
> I thought about it more, and sometimes bitmap index scans are problematic
> too, index scans in nested loops can be a problem too.
Right. Depending on the circumstances, pretty much anything in a plan can be
something deemed problematic in some
Hi
út 6. 7. 2021 v 16:07 odesílatel Daniel Gustafsson napsal:
> Looking at this I like the idea in principle, but I'm not convinced that
> auto_explain is the right tool for this. auto_explain is for identifying
> slow
> queries, and what you are proposing is to identify queries with a certain
Looking at this I like the idea in principle, but I'm not convinced that
auto_explain is the right tool for this. auto_explain is for identifying slow
queries, and what you are proposing is to identify queries with a certain
"shape" (for lack of a better term) even if they aren't slow as per the
l
ne 18. 4. 2021 v 16:09 odesílatel Pavel Stehule
napsal:
>
>
> ne 18. 4. 2021 v 14:28 odesílatel Julien Rouhaud
> napsal:
>
>> On Sun, Apr 18, 2021 at 06:21:56AM +0200, Pavel Stehule wrote:
>> >
>> > The extension like pg_qualstat is good, but it does different work.
>>
>> Yes definitely. It was
ne 18. 4. 2021 v 14:28 odesílatel Julien Rouhaud
napsal:
> On Sun, Apr 18, 2021 at 06:21:56AM +0200, Pavel Stehule wrote:
> >
> > The extension like pg_qualstat is good, but it does different work.
>
> Yes definitely. It was just an idea if you needed something right now that
> could more or les
On Sun, Apr 18, 2021 at 06:21:56AM +0200, Pavel Stehule wrote:
>
> The extension like pg_qualstat is good, but it does different work.
Yes definitely. It was just an idea if you needed something right now that
could more or less do what you needed, not saying that we shouldn't improve the
core :
so 17. 4. 2021 v 20:51 odesílatel Pavel Stehule
napsal:
>
>
> so 17. 4. 2021 v 20:36 odesílatel Justin Pryzby
> napsal:
>
>> On Sat, Apr 17, 2021 at 05:22:59PM +0200, Pavel Stehule wrote:
>> > so 17. 4. 2021 v 17:09 odesílatel Justin Pryzby
>> napsal:
>> >
>> > > On Sat, Apr 17, 2021 at 04:36:5
so 17. 4. 2021 v 20:36 odesílatel Justin Pryzby
napsal:
> On Sat, Apr 17, 2021 at 05:22:59PM +0200, Pavel Stehule wrote:
> > so 17. 4. 2021 v 17:09 odesílatel Justin Pryzby
> napsal:
> >
> > > On Sat, Apr 17, 2021 at 04:36:52PM +0200, Pavel Stehule wrote:
> > > > today I worked on postgres's ser
On Sat, Apr 17, 2021 at 05:22:59PM +0200, Pavel Stehule wrote:
> so 17. 4. 2021 v 17:09 odesílatel Justin Pryzby napsal:
>
> > On Sat, Apr 17, 2021 at 04:36:52PM +0200, Pavel Stehule wrote:
> > > today I worked on postgres's server used for critical service. Because the
> > > application is very
so 17. 4. 2021 v 18:54 odesílatel Julien Rouhaud
napsal:
> On Sat, Apr 17, 2021 at 05:22:59PM +0200, Pavel Stehule wrote:
> >
> > The fullscan of this table needs about 30ms and has 200K rows. So
> > decreasing log_min_duration to this value is very risky.
> >
> > [...]
> >
> > I use pg_stat_all
On Sat, Apr 17, 2021 at 05:22:59PM +0200, Pavel Stehule wrote:
>
> The fullscan of this table needs about 30ms and has 200K rows. So
> decreasing log_min_duration to this value is very risky.
>
> [...]
>
> I use pg_stat_all_tables.seq_scan and I see seq scans there. But I need to
> know the rel
so 17. 4. 2021 v 17:09 odesílatel Justin Pryzby
napsal:
> On Sat, Apr 17, 2021 at 04:36:52PM +0200, Pavel Stehule wrote:
> > today I worked on postgres's server used for critical service. Because
> the
> > application is very specific, we had to do final tuning on production
> > server. I fix lot
On Sat, Apr 17, 2021 at 04:36:52PM +0200, Pavel Stehule wrote:
> today I worked on postgres's server used for critical service. Because the
> application is very specific, we had to do final tuning on production
> server. I fix lot of queries, but I am not able to detect fast queries that
> does fu
Hi
today I worked on postgres's server used for critical service. Because the
application is very specific, we had to do final tuning on production
server. I fix lot of queries, but I am not able to detect fast queries that
does full scan of middle size tables - to 1M rows. Surely I wouldn't log
a
14 matches
Mail list logo
