Re: SQL group by help

What > On Dec 11, 2020, at 10:24 AM, Chris Stephens wrote: > >  > I'm trying to create a visual representation of a 6x8 grid of samples on a > rack using the following SQL format: > > with rack_display as ( > select sr.ts rack_ts > , sr.rack_id > , r.rack_barcode >

Re: Required checkpoints occurs too frequently

On Fri, Dec 11, 2020 at 8:49 PM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > > > On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar wrote: > >> Hi, >> >> We are getting this alert frequently "Required checkpoints occurs too >> frequently" on postgres version 11.8 >> >> The RAM of the serve

Re: Required checkpoints occurs too frequently

On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar wrote: > Hi, > > We are getting this alert frequently "Required checkpoints occurs too > frequently" on postgres version 11.8 > > The RAM of the server is 16 GB. > > and we have already set the max_wal_size= 4096 MB > min_wal_size= 192 MB. > There are m

SQL group by help

I'm trying to create a visual representation of a 6x8 grid of samples on a rack using the following SQL format: with rack_display as ( select sr.ts rack_ts , sr.rack_id , r.rack_barcode , 1 as row_pos , max(case when rack_well = 0 then 'A1: '||sample_barcode end

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

My take is that there is presently no guarantee, and that with current efforts to add parallelism it is quite probable that observation of such non-orderedness is simply a matter of time. With batching it seems best to combine its use with single inserts in order to avoid this problem. David J.

Re: "Required checkpoints occurs too frequently"

Ok I m sorry, I had no idea of it. On Friday, December 11, 2020, Stephen Frost wrote: > Greetings, > > * Atul Kumar (akumar14...@gmail.com) wrote: > > Please help me in optimizing the same to avoid this alert. > > Please don't post the same question to multiple lists, nor post > the same questio

Re: "Required checkpoints occurs too frequently"

Greetings, * Atul Kumar (akumar14...@gmail.com) wrote: > Please help me in optimizing the same to avoid this alert. Please don't post the same question to multiple lists, nor post the same question over and over to the same list with little time between them. Thanks, Stephen signature.asc Des

Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

On Thu, 10 Dec 2020 at 19:37, David G. Johnston wrote: > On Wed, Dec 9, 2020 at 1:31 PM electrotype wrote: > >> Agreed. >> >> >> However, this isn't really the purview of JDBC - I'm doubting it does >> anything that would cause the order to be different than what is received, >> and the batch it

Re: Set COLLATE on a session level

On 10/12/2020 19:33, Dirk Mika wrote: There is a SET COLLATION command in the SQL standard that does this. Someone just has to implement it. It wouldn't be terribly difficult, I think. I think it would be analogous to the schema search path. Usually you notice right away if the "search_path"

Re: Set COLLATE on a session level

On 2020-11-30 10:11:38 +, Dirk Mika wrote: > > > pá 20. 11. 2020 v 15:28 odesílatel Dirk Mika > > > napsal: > > > > Let's assume there is an app that accesses the same database from > > > > different countries. And in this app data should be displayed ordered. > > > > And > > > > the sort ord

"Required checkpoints occurs too frequently"

Hi, We are getting this alert frequently "Required checkpoints occurs too frequently" on postgres version 11.8 The RAM of the server is 16 GB. and we have already set the max_wal_size= 4096 MB min_wal_size= 192 MB. Please help me in optimizing the same to avoid this alert. Regards, Atul

Required checkpoints occurs too frequently

Hi, We are getting this alert frequently "Required checkpoints occurs too frequently" on postgres version 11.8 The RAM of the server is 16 GB. and we have already set the max_wal_size= 4096 MB min_wal_size= 192 MB. Please help me in optimizing the same to avoid this alert. Regards, Atul