RE: [EXTERNAL] Re: pg_stat_statements

2022-05-05 Thread Godfrin, Philippe E
From: Julien Rouhaud Sent: Wednesday, May 4, 2022 10:24 PM To: Godfrin, Philippe E Cc: pgsql-hackers@lists.postgresql.org Subject: [EXTERNAL] Re: pg_stat_statements Hi, On Tue, May 03, 2022 at 01:30:32PM +, Godfrin, Philippe E wrote: > > I wasn't exactly clear about the q

pg_stat_statements

2022-05-03 Thread Godfrin, Philippe E
Hi, On Mon, May 02, 2022 at 12:45:28PM +, Godfrin, Philippe E wrote: >> Greetings, >> >> I want to limit the query text that gets captured in pg_stat_statements. We >> have sql statements with thousands of values clauses (upwards of 10,000) that >> run at a

limiting collected query text length in pg_stat_statements

2022-05-02 Thread Godfrin, Philippe E
Greetings, I want to limit the query text that gets captured in pg_stat_statements. We have sql statements with thousands of values clauses (upwards of 10,000) that run at a 1 second interval. When just a handful are running plus 2 or 3 loads using the same technique (10,000 entry values clause

toast tables and toast indexes

2021-12-28 Thread Godfrin, Philippe E
Folks, While experimenting with toast tables I noticed that the toast index lands in the same tablespace as the toast table itself. Is there a way to make the toast indexes create in a different tablespace? Phil Godfrin | Database Administration NOV NOV US | Engineering Data 9720 Beechnut St | H

RE: [EXTERNAL] Re: speed up verifying UTF-8

2021-12-10 Thread Godfrin, Philippe E
>-Original Message- >From: Heikki Linnakangas >Sent: Friday, December 10, 2021 12:34 PM >To: John Naylor ; Vladimir Sitnikov > >Cc: pgsql-hackers ; Amit Khandekar >; Thomas Munro ; Greg Stark > >Subject: [EXTERNAL] Re: speed up verifying UTF-8 > >On 20/10/2021 00:42, John Naylor wrote:

RE: [EXTERNAL] Re: should we document an example to set multiple libraries in shared_preload_libraries?

2021-12-10 Thread Godfrin, Philippe E
On Wed, Dec 1, 2021 at 5:15 AM Tom Lane wrote: > > Justin Pryzby writes: > > +1 to document it, but it seems like the worse problem is allowing > > +the admin to > > write a configuration which causes the server to fail to start, > > without having issued a warning. > > > I think you could fix

RE: [EXTERNAL] Re: track_io_timing default setting

2021-12-10 Thread Godfrin, Philippe E
>-Original Message- >Sent: Friday, December 10, 2021 9:20 AM >To: Jeff Janes >Cc: PostgreSQL Hackers >Subject: [EXTERNAL] Re: track_io_timing default setting >Jeff Janes writes: > Can we change the default setting of track_io_timing to on? >That adds a very significant amount of overhe