Re: [PERFORM] Index-Advisor Tools

Hi Neto, maybe HypoPG Can help you: https://github.com/dalibo/hypopg El 31 oct. 2017 2:13 PM, "Neto pr" escribió: > > Hello All I'm researching on Index-Advisor Tools to be applied in SQL > queries. At first I found this: - EnterpriseDB - > https://www.enterprisedb.com/docs/en/9.5/asguide/EDB_

Re: [PERFORM] [ADMIN] 2 server with same configuration but huge difference in performance

Hi Sumeet Shukla While script is running check the pg_stat_activity, this view can be util Regards Anthony On 01/08/17 10:16, Keith wrote: On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla mailto:sumeet.k.shu...@gmail.com>> wrote: Hi, I have 2 PG servers with same h/w and configura

Re: [PERFORM] How to access data of SQL server database from PostgreSQL

Hi Daulat This is not the list for that (check https://www.postgresql.org/list/), but if you want to access sql server look at tds_fdw( https://github.com/tds-fdw/tds_fdw), I do not know if it installs on windows, I've only used it on linux, and function very well. Regards Anthony On 01/08

Re: [PERFORM] Rollback table data.

HI, If you dont vaccum the table, You can read data modified with pg_dirtyread extension, but be carefull ;-) https://github.com/omniti-labs/pgtreats/tree/master/contrib/pg_dirtyread Regards On 07/06/17 07:33, Dinesh Chandra 12108 wrote: Dear Expert, Is there any way to rollback table data i