Re: No commit nor Rollback button

On Tue, Oct 17, 2017 at 1:07 AM, Dave Page wrote: > I can see why for some people who choose to turn auto-commit/auto-rollback > off they may be useful, however we cannot simply add new features every > time someone asks for something. Doing so adds maintenance costs, and > increases complexity o

Re: Data grid: fetching/scrolling data on user demand

Hi, > On Tue, Oct 17, 2017 at 1:44 PM, Tomek wrote: > >> Hi, >> >> It is not exactly truth... In v3 the query is executed, fetched and all >> rows are displayed, > > No they're not, though they are all transferred to the client which is > why it's slower. They

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 1:44 PM, Tomek wrote: > Hi, > > It is not exactly truth... In v3 the query is executed, fetched and > all rows are displayed, > >>> > >>> No they're not, though they are all transferred to the client which is > why it's slower. > >> > >> They are not what? > > > > The

Re: Installation failure on Debian

On Tue, Oct 17, 2017 at 05:56:16PM +0530, Murtuza Zabuawala wrote: > Already answered here https://stackoverflow.com/questions/46707935/oserror-errno-13-permission-denied-var-lib-pgadmin> Thanks. Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data man

Re: Data grid: fetching/scrolling data on user demand

Hi, It is not exactly truth... In v3 the query is executed, fetched and all rows are displayed, >>> >>> No they're not, though they are all transferred to the client which is why >>> it's slower. >> >> They are not what? > > The handling of rows in pgAdmin 3 is not as you described.

Re: Installation failure on Debian

Already answered here On Tue, Oct 17, 2017 at 5:56 PM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Already answered here > > > On Tue, Oc

Re: Installation failure on Debian

On Tue, Oct 17, 2017 at 1:16 PM, Johann Spies wrote: > I am trying pgadmin4 again. > > I have downloaded pgadmin4-2.0-py2.py3-none-any.whl and did the following > (following the instructions on https://www.pgadmin.org/ > download/pgadmin-4-python-wheel/): > > $ pyvenv-3.6 pgadmin4 > $ cd pgadmin4

Re: Installation failure on Debian

Already answered here https://stackoverflow.com/questions/46707935/oserror-errno-13-permission-denied-var-lib-pgadmin> On Tue, Oct 17, 2017 at 5:46 PM, Johann Spies wrote: > I am trying pgadmin4 again. > > I have downloaded pgadmin4-2.0-py2.py3-none-any.whl and did the following > (following th

Installation failure on Debian

I am trying pgadmin4 again. I have downloaded pgadmin4-2.0-py2.py3-none-any.whl and did the following (following the instructions on https://www.pgadmin.org/download/pgadmin-4-python-wheel/): $ pyvenv-3.6 pgadmin4 $ cd pgadmin4 $ . bin/activate $ pip3 install ~Downloads/pgadmin4-2.0-py2.py3-none

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 11:35 AM, Tomek wrote: > Hi, > > >> It is not exactly truth... In v3 the query is executed, fetched and all > rows are displayed, > > > > No they're not, though they are all transferred to the client which is > why it's slower. > > They are not what? The handling of rows

RES: Faded text in pgAdmin 4 2.0/Win Server 2008r2

Thanks for your quick answer! If have anything I can test for you, would be my pleasure. Regards, Edson Richter Enviado do Email para Windows 10 De: Dave Page Enviado:terça-feira, 17 de outubro de 2017 08:48 Para: Edson R

Re: Faded text in pgAdmin 4 2.0/Win Server 2008r2

Looking at this is on my TODO, however I'm currently having issues spinning up a Windows Server VM which are holding things up. On Tue, Oct 17, 2017 at 11:46 AM, Edson Richter wrote: > > > Must be something wrong in my setup: Windows Server 2008 r2 TS, acessing > with two Full HD 24" monitors in

Faded text in pgAdmin 4 2.0/Win Server 2008r2

Must be something wrong in my setup: Windows Server 2008 r2 TS, acessing with two Full HD 24" monitors in 32bit color depth., themes disabled, font smoothing enabled, composition enabled, visual effects disabled. I just can't read texts... They are "faded". See attached screenshot for refer

Re: Data grid: fetching/scrolling data on user demand

Hi, >> It is not exactly truth... In v3 the query is executed, fetched and all rows >> are displayed, > > No they're not, though they are all transferred to the client which is why > it's slower. They are not what? What is slower - is the "display" part in both versions. You have data from se

Re: Data grid: fetching/scrolling data on user demand

Hi Tomek, On Tue, Oct 17, 2017 at 3:21 PM, Tomek wrote: > Hi, > > > As I mentioned in my previous email that we do not use server side > cursor, so it won't add any > > limit on query. > > > > The delay is from database driver itself, it has nothing to do with > pgAdmin4. > > Try executing the s

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 10:51 AM, Tomek wrote: > Hi, > > > As I mentioned in my previous email that we do not use server side > cursor, so it won't add any > > limit on query. > > > > The delay is from database driver itself, it has nothing to do with > pgAdmin4. > > Try executing the same query

Re: Data grid: fetching/scrolling data on user demand

Hi, > As I mentioned in my previous email that we do not use server side cursor, so > it won't add any > limit on query. > > The delay is from database driver itself, it has nothing to do with pgAdmin4. > Try executing the same query in 'psql', 'pgAdmin3' and third party tool which > use libpq

Re: Data grid: fetching/scrolling data on user demand

As I mentioned in my previous email that we do not use server side cursor, so it won't add any limit on query. The delay is from database driver itself, it has nothing to do with pgAdmin4. Try executing the same query in 'psql', 'pgAdmin3' and third party tool which use libpq library as backend, y

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 9:51 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > 1000 first rows are available in less than zone second. > See query with limit 1000. > We cannot add arbitrary limit/offsets to users queries. They will affect timing for those who are trying to tune queries,

Re: Data grid: fetching/scrolling data on user demand

1000 first rows are available in less than zone second. See query with limit 1000. Monitoring memory usage or PG_stat_activity shows that all the data is fetched. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 9:36 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Pgadmin doesn't have to Wait for all the data, > As he should only load/fetch the first 1000 rows. > > Loading all the data in memory will not be possible for big datasets. > > This is a design error at my poi

Re: Data grid: fetching/scrolling data on user demand

Pgadmin doesn't have to Wait for all the data, As he should only load/fetch the first 1000 rows. Loading all the data in memory will not be possible for big datasets. This is a design error at my point of view. PAscal SQLeo projection manager -- Sent from: http://www.postgresql-archive.org

Re: Data grid: fetching/scrolling data on user demand

On Tue, Oct 17, 2017 at 6:36 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > > On Tue, Oct 17, 2017 at 2:22 AM, legrand legrand < > legrand_legr...@hotmail.com> wrote: > >> How long does it take in your environnment >> to fetch the 1000 first records from >> >> select * from i

Re: No commit nor Rollback button

On Tue, Oct 17, 2017 at 6:26 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > > On Tue, Oct 17, 2017 at 2:03 AM, legrand legrand < > legrand_legr...@hotmail.com> wrote: > >> Hi Murtuza, >> >> I found those options for switching between autocommit mode and manual >> mode. >> >>