Re: dsa_allocate() faliure

2019-02-04 Thread Justin Pryzby
On Mon, Feb 04, 2019 at 08:31:47PM +, Arne Roland wrote: > I could take a backup and restore the relevant tables on a throwaway system. > You are just suggesting to replace line 728 > elog(FATAL, > "dsa_allocate could not find %zu free > pages", npages); > by

RE: dsa_allocate() faliure

2019-02-04 Thread Arne Roland
It's definitely a quite a relatively complex pattern. The query I set you last time was minimal with respect to predicates (so removing any single one of the predicates converted that one into a working query). > Huh. Ok well that's a lot more frequent that I thought. Is it always the > same q

Re: ERROR: found xmin from before relfrozenxid

2019-02-04 Thread Mariel Cherkassky
dumping the table and then restoring it solved the case for me. select for update didnt help.. thanks ! ‫בתאריך יום ד׳, 30 בינו׳ 2019 ב-12:35 מאת ‪Mariel Cherkassky‬‏ <‪ mariel.cherkas...@gmail.com‬‏>:‬ > Hey, > As I said, I'm getting this error for all the objects in a specific db. I > cant eve

Sv: Re: Fw: server hardware tuning.

2019-02-04 Thread Andreas Joseph Krogh
På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria < prince.path...@goevive.com >: Hi Suganthi, I can give you a start, some pro users can suggest you better.   1. Don't use this much of connections on a single postgres server. Use a connection pooler

Re: Fw: server hardware tuning.

2019-02-04 Thread Prince Pathria
Hi Suganthi, I can give you a start, some pro users can suggest you better. 1. Don't use this much of connections on a single postgres server. Use a connection pooler in front of it. 2. RAM: Depends upon how much data you want to be cached. 3. Use PCIe SATA SSD with RAID10, Postgres uses a lot of

Fw: server hardware tuning.

2019-02-04 Thread suganthi Sekar
Hi , I need know how to calculate hardware sizing for database or query RAM CPU Config tuning Requirement : 1100 concurrent connection 1600 column of table 1GB of data can be select and dynamic aggregation will happen Regards SuganthiSekar

Re: dsa_allocate() faliure

2019-02-04 Thread Thomas Munro
On Mon, Feb 4, 2019 at 6:52 PM Jakub Glapa wrote: > I see the error showing up every night on 2 different servers. But it's a bit > of a heisenbug because If I go there now it won't be reproducible. Huh. Ok well that's a lot more frequent that I thought. Is it always the same query? Any chanc