Re: does dml operations load the blocks to the shared buffers ?

Le jeu. 10 janv. 2019 à 11:40, Mariel Cherkassky < mariel.cherkas...@gmail.com> a écrit : > . Lets assume the amount of data I insert is bigger than the > shared_buffers. I didnt commit the transaction yet, the data will be saved > on temp files until I commit ? > What happens if I have in my tran

Detect missing combined indexes (automatically)

Is there a way to detect missing combined indexes automatically I am managing a lot of databases and I think a lot of performance could get gained. But I don't want to do this manually. My focus is on missing combined indexes, since for missing single indexes there are already tools available.

Re: does dml operations load the blocks to the shared buffers ?

. Lets assume the amount of data I insert is bigger than the shared_buffers. I didnt commit the transaction yet, the data will be saved on temp files until I commit ? What happens if I have in my transaction,I did a lot of changes and I filled the wal_buffers / shared buffers but I still didnt comm

Re: postgresql unix socket connections

Thanks Ken. I just wanted to make sure that it happened because of 9.6 packages installation and not because of any other reason. ‫בתאריך יום ה׳, 10 בינו׳ 2019 ב-11:42 מאת ‪Ken Tanzer‬‏ <‪ ken.tan...@gmail.com‬‏>:‬ > On Wed, Jan 9, 2019 at 7:09 AM Mariel Cherkassky < > mariel.cherkas...@gmail.com

Re: postgresql unix socket connections

On Wed, Jan 9, 2019 at 7:09 AM Mariel Cherkassky < mariel.cherkas...@gmail.com> wrote: > Hey Tom, > I'm aware of how I can solve it. I wanted to understand why after > installing the pg 9.6 packages suddenly psql tries to access the socket on > /var/run/postgresql. Does the libpq default unix sock

Re: PostgreSQL Read IOPS limit per connection

Hello, I am happy to hear that you have received all the help. Please feel free to contact us for professional assistance any time you may need in the future. Most Welcome! Regards, Mark Avinash Hogg Director of Business Development 2ndQuadrant +1(647) 770 9821 Cell www.2ndquadrant.com

Re: does dml operations load the blocks to the shared buffers ?

Le jeu. 10 janv. 2019 à 09:07, Mariel Cherkassky < mariel.cherkas...@gmail.com> a écrit : > Hey, > It is clear that when we query some data, if that data isnt in the shared > buffers pg will go bring the relevant blocks from the disk to the shared > buffers. I wanted to ask if the same logic works

Re: postgresql unix socket connections

In machine 2 : I found 4 libpq.so files : [root@~]# locate libpq.so /usr/lib64/libpq.so.5 /usr/lib64/libpq.so.5.2 /usr/pgsql-9.6/lib/libpq.so.5 /usr/pgsql-9.6/lib/libpq.so.5.9 cat /etc/ld.so.conf include ld.so.conf.d/*.conf ld.so.conf.d]# cat /etc/ld.so.conf.d/postgresql-pgdg-libs.conf /usr/pgsq

does dml operations load the blocks to the shared buffers ?

Hey, It is clear that when we query some data, if that data isnt in the shared buffers pg will go bring the relevant blocks from the disk to the shared buffers. I wanted to ask if the same logic works with dml(insert/update/delete). I'm familiar with the writing logic, that the checkpointer is the